From: Chris Reid <chrisr@mistral.co.uk>
Subject: Re: HElP!!  ODBC Oracle
Date: 1996/11/11
Message-ID: <32872B2C.47E4@mistral.co.uk>#1/1
references: <01bbccef$9d44c340$91b597ce@orion.sgi.net.sgi.net>
to: Kochis <djkochis@sgi.net>
content-type: text/plain; charset=us-ascii
organization: BRI International
mime-version: 1.0
newsgroups: comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools
x-mailer: Mozilla 3.0 (Win95; I)



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@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