TNS Service Name selector for ODBC configuration on W2k shows trash with Instant Client 10g

[Alexander Skwar]

Hello!

I'm having some problems with the Instant Client 10g on a Windows
2000 Server SP4 machine. On this machine, I'm trying to setup a ODBC
connection and fail, as the "TNS Service Name" list only contains
"junk". Please see the screenshot at

http://server3.pictiger.com/img/613385/computer-games-and-screenshots/w2k-oracle-odbc-tns-service-name-trash.php

To get so far, I downloaded and unzipped the following files to
C:\Oracle\instantclient_10_2:

* instantclient-basic-win32-10.2.0.2-20060508.zip
* instantclient-odbc-win32-10.2.0.2-20060508.zip
* instantclient-sqlplus-win32-10.2.0.2-20060508.zip

Next, I added some System environment variables:

* ORACLE_HOME=C:\Oracle\instantclient_10_2
* TNS_ADMIN=C:\Oracle\instantclient_10_2\network\admin\tnsnames.ora

To PATH, I added (at the end): C:\Oracle\instantclient_10_2. After
having done so, I created the file
C:\Oracle\instantclient_10_2\network\admin\tnsnames.ora, which
contains exactly this (see http://vz6tml.pastebin.ca/211376):

ORABDE.EUROPE.DELPHIAUTO.NET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.233.30.8)(PORT = 1521))
)

(CONNECT_DATA =
(SERVICE_NAME = orabde.delphi)
)

That's the only file with "tnsname" in its name on the local
harddrives of this server.

After having done all of this, I ran odbc_install and had the server
rebooted later in the night.

This morning, ie. after reboot, I logged on to the system and started
the "Data Sources (ODBC)" configuration of Windows 2000. I clicked on
"Add" and selected "Oracle in instantclient10-2". Then I expanded the
list of the available TNS Service Name entries and see only junk. On
a different W2k server, I am able to setup a ODBC connection usign
the Oracle Instant Client 10g.

What am I doing wrong, and how do I do it correctly?

Thanks a lot,
Alexander

[Sachin Arora]

firstly ..

TNS_ADMON should not be

 

* TNS_ADMIN=C:\Oracle\instantclient_10_2\network\admin\tnsnames.ora
 

it should be

* TNS_ADMIN=C:\Oracle\instantclient_10_2\network\admin

 

Also .. after setting this try "tnsping ORABDE.EUROPE.DELPHIAUTO.NET " from command prompt of client and see if it works..

 

Sachin

 

[Alexander Skwar]

Hi!

Sachin Arora schrieb:

> firstly ..
> TNS_ADMON should not be
>
> * TNS_ADMIN=C:\Oracle\instantclient_10_2\network\admin\tnsnames.ora
>
> it should be
> * TNS_ADMIN=C:\Oracle\instantclient_10_2\network\admin

Great! That did the trick!

Thanks a lot.

Alexander