No idea what system you are trying this on, but possibly where you put the
tnsname.ora entries is not where Oracle is looking for them. Scan your
system for all tnsnames.ora files and work from there.
"Thomas R. Hummel" <tom_hummel_at_hotmail.com> wrote in message
news:a2c0eeb8.0302071313.1b1b0cbe_at_posting.google.com...
> Hello,
>
> I am currently trying to set up a connection between a MS SQL Server
> and an Oracle database. The Oracle client tools are installed on the
> machine and I've copied the appropriate entry from my own tsnames.ora
> file to the same file on the SQL Server. I am able to connect to the
> server from my own machine. However, I can't connect to Oracle from
> the SQL Server. I always get the ORA-12154 error (TNS:could not
> resolve service name).
>
> I tried going into the Net8 Configuration Assistant, but it was
> completely useless. If I select the "Local Net Service Name
> configuration" and click the "Next" button nothing happens, despite
> the fact that the button is enabled. Actually, something happens - the
> button clicks. The window remains the same.
>
> I tried going into the "Net8 Assistant", clicked on the "Local"
> subtree and then clicked on the "Service Naming" subtree. Nothing
> listed under there, so I tried to add a listing. Once again, despite
> the button for adding being enabled and the Edit->Create menu being
> enabled, neither of them actually did anything.
>
> Any thought or ideas? I have almost no Oracle experience, so please
> include as many details as you can.
>
> Thanks!
> -Tom.
Received on Fri Feb 07 2003 - 15:18:27 CST
