If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ODBC CALL FAILED
When we try to run a query that passes a date variable we
encounter "ODBC CALL FAILED". This is not happening on all our computers but we can't seem to isolate the cause. We run both Win2k and XP boxes here. I have tried updating the MS Jet engine to no avail. Help! |
#2
|
|||
|
|||
ODBC CALL FAILED
What type of file is the ODBC link to? I have a database that is linked
to several Visual FoxPro tables and found that I had to install a file from MS on all XP machines to get those ODBC links to work. On all other machines (9x, NT, 2K) it works with no intervention. If it's FoxPro, I'll give you a link to the file. Darrell bikermike wrote: When we try to run a query that passes a date variable we encounter "ODBC CALL FAILED". This is not happening on all our computers but we can't seem to isolate the cause. We run both Win2k and XP boxes here. I have tried updating the MS Jet engine to no avail. Help! |
#3
|
|||
|
|||
ODBC CALL FAILED
It could be timing out on some computers if they are on a slower network
connection than others. I've seen this behavior in the past. It usually involves a query that must run on the local computer (at least in part) - using a vba function in the criteria, using a local table joined to the table on the ODBC "server", ??? Darrell Childress wrote: What type of file is the ODBC link to? I have a database that is linked to several Visual FoxPro tables and found that I had to install a file from MS on all XP machines to get those ODBC links to work. On all other machines (9x, NT, 2K) it works with no intervention. If it's FoxPro, I'll give you a link to the file. Darrell bikermike wrote: When we try to run a query that passes a date variable we encounter "ODBC CALL FAILED". This is not happening on all our computers but we can't seem to isolate the cause. We run both Win2k and XP boxes here. I have tried updating the MS Jet engine to no avail. Help! |
Thread Tools | |
Display Modes | |
|
|