Re: MS_Access ODBC Oracle7???

Gary T Lefko (lefkogt%rr%usafa_at_sc4199.usafa.af.mil) wrote:
: Need help creating ODBC connections to our Oracle7 db on HP9000 on
: TCP/IP network. We have SQL*NET 2.0 on both the server/client ends
: and have Oracl7 Windows 3.1 ODBC driver installed. We try the
: connect string 'T:128.236.201.2:admis' and get failures. admis is the
: alias of Oracle7 on HP9000. We have no experts here to get help.
: How about all of you out here?
: Thanks
: SSgt Gary Lefko (Air Force Academy)

You are using a SQLNET 1.0 - style connect string. With Sqlnet 2.0, everything is managed through TNSNAMES which need to be setup on all machines you need to connect.

Oracle SQLNET 2.0 has a tool to define your network names (sorry I forget the executable file name) so you don't need to modify the TNSNAMES file directly. But the basic idea is this: 1) add the SQLNET 2.0 reference to the server on the client machine, with the name 'admis' The entry will reference the host location, transport, instance and other details if required 2) just use the connect string 'admis' in the ODBC definition.

Good luck!

--
Michael Conant                mike_at_conant.com
Conant Consulting             San Jose, CA