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