Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to connect to different database in Oracle 7 ?
Hi,
We are porting from MS SQL Server 6.5 to Oracle 7.3 and are quite confused, as you might expect, so please bear with me 8)
There is a concept in SQL Server of multiple databases on a given server
which can
contain the same schema (tables, stored procedures, etc.). When connecting
with
DB-Lib, the dbuse() API can be used to set the desired default database, so
that
SQL commands like "Select Name from My_Table" can be executed.
However, I cannot see how to do this with OCI or even Embedded SQL. It
would seem
that the database name must be specified for non-default databases, e.g.
"Select Name from MyDatabase.MyTable".
Any insight would be appreciated !
--
Rob Yang
Sr. Software Engineer
San Jose, CA, USA
Received on Mon Apr 20 1998 - 14:14:56 CDT