Connecting Access to multiple Oracle DBases

[mriozzo]

I'm trying to connect via OBDC to a set of Oracle Databases that reside on the same server. I do not have any problem accessing them thru their Database SID's using the Oracle Discoverer software, however, I cannot seem to find where to specify the SID's in the MS ODBC setup. I want to have access to both dbases so I can query them using MS Access. The database SID's are ORCL and SSMA. The ORCL database existed first, and this is the only dbase I can connect to thru ODBC and MS Access. Any help is most appreciated!

 

[THoey]

Did you go to Start -> Settings -> Control Panel -> ODBC Connections and create an entry for this new database? After that, you should be able to link the tables through Ms. Access and get to the data... Terry M. Hoey

 

[mriozzo]

I did that, however, there is no prompt for the database name with the Oracle driver, only the server name...

 

[Quehay]

Why not use ADO? It's faster and more functional that ODBC.
If you want linked tables then it's ODBC, but writing the connection code isn't bad with ADO--there are plenty of examples out there to imitate.

 

[mriozzo]

I did want linked tables which is why I did not investigate the ADO option. I noticed on MS knowledge base that it seems that the latest ODBC driver that works with 8i does not support multiple world access and only goes to the default database. Does anyone know if this is true?