Re: connecting to remote oracle 7.3 DB using odbc

From: Phil Caskanette <caskanet_at_mc1adm.UWaterloo.ca>
Date: Wed, 02 Dec 1998 13:42:43 -0500
Message-ID: <36658A23.9B690216@mc1adm.UWaterloo.ca>

I haven't used WinNT but if it's anything like a Win95 ODBC connection, you have to run SQL*Net. The TCP/IP connection parameters are defined in a file used by SQL*Net called tnsnames.ora. The ODBC connection uses the instance name as defined in the tnsnames file.

Mike Irvine wrote:
>
> I'm trying to determine from the rather sparse ODBC documentation
> how to create a winNT ODBC datasource that connects to
> a remote Oracle 7.3 running on an HP unix box using TCP/IP.
>
> The oracle ODBC documentation doesn't outline remote database connection
> strings.
> The ODBC driver field in question is most likely:
> Service name(normally just something like:beq-local.world)
> and possibly userID.
> The only other fields in the Oracle ODBC driver set up are:
> Data source Name, Description, Connection in read only, prefetch count,
> translation option, and translation library
>
> Anyone done this before? Is there any good documentation on this problem(no
> faq found that helps)?
>
> Thanks,
>
> -Mike

--

---

Phil Caskanette                 |  e-mail: caskanet_at_UWaterloo.ca
Senior Auditor                  |  phone:  (519) 888-4567 x2774
University of Waterloo          |  fax:    

Waterloo, Ont., Canada N2L 3G1 |

---

Disclaimer: All expressed opinions are mine, and are not necessarily the views of my employer. Received on Wed Dec 02 1998 - 12:42:43 CST