Problems linking Sybase tables from different databases

[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

 

[Guest]

-----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

second table.

 

[david epsom dot com dot au]

Dump the DSNs and just use the connect string to specify
your server and datatabase.

(david)