From: GreMa@t-online.de (Matthias Gresz)
Subject: Re: Connecting new instance with MS Access ?
Date: 1997/11/11
Message-ID: <648vmf$pn0$1@news00.btx.dtag.de>#1/1
References: <01bcee2a$a754c940$847253ce@deepwater>
X-Sender: 0722193570-0001@t-online.de (Immobilien Regional AG)
Organization: T-Online
Newsgroups: comp.database.oracle,comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools



Gerry West wrote:
> 
> I created a new instance to replace my outdated one.  I was able to connect
> via ODBC to MS Access
> to the old instance, but am having no luck with the new one.  The service
> summary on the listener status
> displays only my new instance.  I've modified the listener.ora and
> tnsnames.ora files
> to reflect the new instance as well as the old one using different ports
> and SIDs but the same host.
> 
> I restarted the listener just fine.  But received the following error when
> attempting to
> connect with ODBC to MS Access:
> 
> ORA–12505 TNS:Listener could not resolve SID given in connect descriptor
> 
> Cause
> The SID in the CONNECT_DATA was not found in the listener's tables.
> 
> Action
> Check to make sure that the SID specified is correct. The SIDs that are
> supported can be obtained by typing LSNRCTL STATUS SERVICE_NAME and
> matching the SID specified in TNSNAMES.ORA with one of the SIDs displayed
> in the services summary.
> 
> I've followed the above actions required to fix this problem, but still no
> connection.
> Is there something I need to reset to make this connection.
> 
> Thanks in advance,
> Gerry West
Hi Gerry,


why intoducing the old SID into tnsnames.ora when you replaced the old
instance by the new one?.


To access the new instance you've got to create a new db-alias for the
new instance or modify the old one to point to the new instance.
If you created a new one you need to setup ODBC-Administrator to use new
alias. 
Then check your connect string.
-- 
Regards

Matthias Gresz    :-)