Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with ODBC Service Name / SQL*NET connect string
Assuming a tnsnames.ora of
oracle <the servicename>
=
(address_list = (address=(host=localhost)(protocol=tcp)(port=1521)))) etc.
the connect descriptor in ODBC should equal the service name in
tnsnames.ora. The name of the ODBC DSN doesn't matter.
t:ORCL refers to sqlnet 1, and I would be suprised 2: working, 2:ORCL
probably
Hth,
Sybrand Bakker, Oracle DBA
John Tannahill wrote in message
<7soV2.25525$134.290551_at_tor-nn1.netcom.ca>...
>Running PO8 8.0.4.0 on Windows 98 and trying to confirm ODBC driver is
>working (8.0.4.4). Can anyone provide example service name for ODBC driver
>(getting tsnames - fail to reslove error). Have tried
>2:
>ORCL
>t:ORCL
>with no luck
>
>Regards, John
>
>
Received on Tue Apr 27 1999 - 15:08:51 CDT