HELP on connection to Oracle with Microsoft ODBC for Oracle Driver
Hi Eric,
Darshan here, you are getting this msg "TNS:could not resolve service name"
may be two reasons.
1. May be you have not installed Oracle Client on the machine
( if Oracle Client is already installed on your machine then
first execute SQL*Plus using the same "connect string" which
you are using it in your ODBC DSN make sure that is connecting
to ORACLE )
2. If you are using ORACLE 8 then you must create a directory
named "NETWORK" into your ORACLE HOME directory
because all previous versions of ORACLE was using "NETWORK"
directory as a base directory for SQL*Net but from ORACLE 8
onwards they are using directory named "NET80" and that is a
problem for Visual Basic 5 because Microsoft ODBC for
Oracle Driver is still searching the SQL*Net into directory "NETWORK"
so you can do one thing copy all files from NET80 directory into
NETWORK
directory it will definitely work.
I hope this will solve your problem, feel free to contact.
regards,
Darshan Desai
Tecnimont ICB Limited
Bombay, India.
Quote:
> Greetings!
> Sorry for the major cross-posting but I really need help here. BTW: Thanks
> in advance.
> The Problem:
> I am trying to setup an ODBC DSN to an Oracle server that resides at
> Stanford U across The Internet. I have everything set up to the best of my
> knowledge correctly but when I attempt to connect via the ODBC DSN via
> 32-bit ODBC Test app (or any other app that supports ODBC connections for
> that matter) I get the following...
> The Error:
> SQLSTATE: 08001
> Native Error Code: 12154
> Driver Message:[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154
> TNS:could not resolve service name
> A Further Wrinkle:
> I have set up another DSN using the Oracle provided ODBC driver and this
> seems to work fine... So you ask "why not use the Oracle driver if it
> works?" Well, the app that I am trying to get up and running uses RDO and
> our testing shows that RDO and Oracle's ODBC drivers don't get along at all
> so we are stuck with the Microsoft Oracle driver. NOTE: I have tried a
> couple of different versions of the Microsoft driver and get the same thing.
> Oh yes, I should tell you that SQL Plus 3.3 connects to the server fine.
> Also TNSPING.EXE finds the server fine.
> The Platform:
> Windows NT 4.0 - Service Pack 3
> Oracle 7.3 Workgroup full install
> DAO 3.5
> ODBC 3.5 (3.510.3002.13)
> MDAC 2.0
> tried/no workie: Microsoft ODBC Driver for Oracle Ver. 2.00.006325
> tried/no workie: Microsoft ODBC for Oracle Ver. 2.573.292700
> tried/works/can't use: Oracle73 Ver. 2.00.0301
> The TRSNAMES.ORA Section:
> FAMIS_TEST.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = zzz.stanford.edu)
> (Port = 1521)
> )
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = zzz.stanford.edu)
> (Port = 1526)
> )
> )
> (CONNECT_DATA = (SID = test)
> )
> )
> Thanks again. If I can provide anyone with any further info please let me
> know! Also, please email me directly at this address as well as posting in
> the group.
> Thanks,
> Eric
