We currently have a problem accessing 2 Sybase databases on the same ASE
(12.0) thru the use of ODBC in MS Access 2000.
If we use the same DSN for the 2 databases, we can create an ODBC link to
tables in the 2 DBs, but when we try to reconnect to those tables, we get a
connection error (MS Access doesn't find one of the 2 DBs).
Anyway, if we use 2 different DSNs, it works (after connecting twice with 2
different DBs on the same DB server).
Is there no way of using the same DSN for 2 Sybase databases on the same
server?

Thanks,
Bart