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!

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!

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!