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