ODBC Call Failed linking DB2/Oracle tables

G

Guest

I have a bit of vb code that uses Catelog Append to programatically link tables from Oracle and DB2 datasources. The problem I am having on some client machines is that the link will take anywhere from 1 to 3 minutes to link the table. When I manually link the tables, it takes no time at all. Note that only certain client have the problem, and the problem will sometimes go away.
These clients will usually get an ODBC Call Failed message after 60 seconds. But if I set the timeout settings for Jet ODBC to 0, then the error goes away, but the link still takes too long
Any ideas?
 
G

Guest

Well, I found my problem
When I was setting the table name property, I was not including the Schema ID. Once I fully qualified the table name, no problems.
 

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

Access 2007 ODBC for Oracle linked table issue 0
Error: Cannot add MS ODBC for Oracle 1
ODBC call failed. 3
Linking to Oracle 2
linking oracle to access 1
Problems not seeing all linked tables in Ms Access 2002 2
Access Oracle ODBC 2
Decimal-error when linking Oracle database tables via ODBC to Acce 1

Top