Re: SqlNetV2, odbc and MSQuery problem
Date: 1995/07/09
Message-ID: <3tpaib$ade_at_sun.sirius.com>#1/1
Lots of things can cause this. First, TNSNAMES.ORA must have the right symbolic set up. Is the Oracle home directory in your DOS search path? Also, SQLNET.ORA (in the orawin\network\admin directory) can specify a domain (this is an Oracle SQL*Net domain, not an IP domain.) If one is specified (Oracle folks usually set up one called "world" as a default) then you MAY have to qualify the TNS name in the connect string thus:
TNS:MYDATA.world
Hope this helps... GOOD LUCK!
kgv_at_godel.denver.ssds.com (Kurt Vaag) wrote:
>I run into a problem with MSQuery talking to SqlNetV2 via Oracle's
>odbc driver. I choose "Open File" from MSQuery's pull down menu,
>it prompts me for my Oracle password and then I get an error:
>ORA-12154: TNS: could not resolve service name.
>however,
>if I first choose "Table Definition", I log into Oracle successfully.
>Then I choose "Open File" to open a saved query things work fine.
>The Oracle documentation on "ORA-12154" says to check the "TNSNAMES.ORA"
>file for accesiblity and syntax.
>If the syntax is bad or the file can not be found why does the query
>work when I choose "Table Definition" first ?
>Anyone out there have any idea what the fark is going on here ?
>Thanks beforehand,
>Kurt
Received on Sun Jul 09 1995 - 00:00:00 CEST