Re: HElP!! ODBC Oracle

From: Chris Reid <chrisr_at_mistral.co.uk>
Date: 1996/11/11
Message-ID: <32872B2C.47E4@mistral.co.uk>#1/1

Kochis wrote:
>
> Currently running NT Server and Oracle Workgroups 7.1 with a 95 client.
> Tyring to do ODBC with Intersolv driver. Have two instances. Need to
> connect to second instance, not the default. Have SQL*Net 2.1 running on
> both. SQLplus works fine to either, but need to get ODBC running fast.
>
> ODBC driver asks for "Server Name". Both instances are on the same
> server???
>
> Thanks
> David
> djkochis_at_sgi.net

when using easy sqlnet setup you create database alias which is a combination of host name and SID

when configuring odbc driver use alias as server name

make sure listener is listening for both services on host

good luck

chris Received on Mon Nov 11 1996 - 00:00:00 CST