Problems linking Sybase tables from different databases

  • Thread starter Thread starter Dean
  • Start date Start date
D

Dean

We are having problems in Access 2003 linking tables from
a DSN using the Sybase ODBC driver.

The first table I link works fine. If the second table
is in a different database, I get a list of the tables
and can select it but when I click ok to complete the
link, I get an error saying that the table can not be
found. I've tried Sybase Client 12.5 and 12.0.

I tried the same thing using MSSQL Server and it works
fine.

Thanks
 
-----Original Message-----
We are having problems in Access 2003 linking tables from
a DSN using the Sybase ODBC driver.

The first table I link works fine. If the second table
is in a different database, I get a list of the tables
and can select it but when I click ok to complete the
link, I get an error saying that the table can not be
found. I've tried Sybase Client 12.5 and 12.0.

I tried the same thing using MSSQL Server and it works
fine.

Thanks
.
Correction: The error occurs when I try to query the
Click to expand...
second table.
 
Dump the DSNs and just use the connect string to specify
your server and datatabase.

(david)
 
Back
Top