Re: Connecting new instance with MS Access ?

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    :-)