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!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Connecting to multiple oracle databases
- Thread starter mriozzo
- Start date
Similar threads
- Locked
- Question
- Locked
- Question