ODBC CALL FAILED

  • Thread starter Thread starter bikermike
  • Start date Start date
B

bikermike

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
 
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", ???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Query ODBC --- call failed 11
update query ODBC--call failed 3
ODBC--Call failed. 4
Pass-Through Query Error 1
ODBC Call failed 3
ODBC -- update on a linked table [table name] failed 1
add a value to a date 8
ODBC-call failed. 5

Back
Top