Oracle Database Discussions

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 using the Oracle Instant Client 10g.

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

Thanks a lot,
Alexander