>C:\orawin95\bin is already in the DOS environment search path.
>
>I was forgotten to tell that :
>when I make a connection from this Windows98 machine to another unix server with a 7.3 oracle database then it works ok.
>
>Can I use this connector to both databases? Is there a special setting required?
>Or should I also install the 16 bits version?
>I need to have a connection to both databases.
>
>Thanks.
>Peter.
You can connect to any Oracle db with the same client. The key is getting all the services into the TNSNAMES.ORA file. You need 1 service for each Oracle server you intend to connect to. An example of 2 services each connecting to a different server:
SDWISFED =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 123.45.678.9)(PORT = 1522))
(CONNECT_DATA =
(SID = ORAP)
)
)
REG6 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 246.81.357.9)(PORT = 1521))
(CONNECT_DATA =
(SID = ORCL)
)
)
When you launch SQL Plus you would use SDWISFED or REG6 as the host string. If you connect using ODBC, you also use these names as the Connect String or Server name. The ODBC DSN does NOT have to be named the same.
Mark McCasland
Midlothian, TX USA