DTS Package error: TNS-12541: TNS:no listener

I have created a connection to an Oracle database. I am able to connect to
one server and not to the other. The error message I get is : TNS-12541:
TNS:no listener
Here are the steps I took before creating this connection:
Oracle Client instaled on SQL Server
TNS Names file configured with oracle server and port
Can someone tell me what to do? thanks
James
"James Juno" <JamesJuno@.discussions.microsoft.com> wrote in message
news:3F163D43-04EE-4D5B-B9D8-22DEF0819C80@.microsoft.com...
> I have created a connection to an Oracle database. I am able to connect
to
> one server and not to the other. The error message I get is : TNS-12541:
> TNS:no listener
> Here are the steps I took before creating this connection:
> Oracle Client instaled on SQL Server
> TNS Names file configured with oracle server and port
> Can someone tell me what to do? thanks
> James
Your TNSNames file needs to have an entry for each Oracle server that you
wish to connect to along with the appropriate credentials.
HTH
Rick Sawtell
|||Rick,
Thank you so so much. I did have the right port in the TNSname file but not
the right host name. As soon as I fixed that credential, it worked fine.
Thanks again.
James
"Rick Sawtell" wrote:

> "James Juno" <JamesJuno@.discussions.microsoft.com> wrote in message
> news:3F163D43-04EE-4D5B-B9D8-22DEF0819C80@.microsoft.com...
> to
> Your TNSNames file needs to have an entry for each Oracle server that you
> wish to connect to along with the appropriate credentials.
> HTH
> Rick Sawtell
>
>