Can't connect to Oracle server

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:13:33 CST