ODBC Call Failed linking DB2/Oracle tables

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
Back
Top