Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't connect to Oracle server
Thanks for the suggestions. I checked the file syntax and everything
looked ok, but your post gave me an idea which worked. I renamed the
tsnames.ora file and then ran the Net8 Assistant thinking that it
would probably create a file from scratch. After going through the
wizard for a local name it worked properly. The only difference that I
see in the entry that I had added and the one added by the wizard was
that the wizard used a full computer name for the entry, including the
domain name, while my entry just had the computer name. I thought that
I remembered seeing something that said that there was a default
domain for the client, but maybe that wasn't set right. It's also
possible that one of the other entries was incorrect, which is what
I'm leaning towards. In any event, it's working now.
Thanks again!
-Tom.
Karsten Farrell <kfarrell_at_belgariad.com> wrote in message news:<MPG.18add8d229705ff0989692_at_news.la.sbcglobal.net>...
> I assume you meant that you have Oracle client installed on the same
> server as you have SQL Server, so you're doing an Oracle to Oracle
> connection.
>
> When you said you "copied the appropriate entry" do you mean you
> manually did that, with an editor? If so, are you sure you copied the
> *entire* entry, all the left and right parens? Oracle is very finicky
> about this file, and often won't report any syntax errors (but will just
> ignore the entry). Since Net8 Assistant (much better at what you want to
> do than the Net8 Configuration Assistant) is acting like you say, it
> sounds like it's attempting to process the file, but doesn't know what
> to do with a syntax error. Carefully count the parens and compare the
> entry in your SQL Server server's tnsnames.ora to another *working*
> file.
>
> If you can't see a syntax error, maybe you could post the entry on this
> NG. Sometimes those of us who've looked at tnsnames.ora entries till
> we're blue in the face, might spot something amiss.
Received on Mon Feb 10 2003 - 08:52:05 CST