Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is it possible to connect to 7.1 oracle db using 7.3.4 c
Message
 
 
To
08/04/2001 06:16:10
Peter de Moel
Omnisys Automatisering
Hoevelaken, Netherlands
General information
Forum:
Oracle
Category:
Other
Miscellaneous
Thread ID:
00493161
Message ID:
00493344
Views:
24
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform