Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

TNS Service Name selector of ODBC config on W2k shows trash w/ IC 10g

Status
Not open for further replies.

ASkwar

Programmer
Jun 7, 2002
3
US
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":


To get so far, I downloaded and unzipped the following files to [tt]C:\Oracle\instantclient_10_2[/tt]:
[tt][ul]
[li]instantclient-basic-win32-10.2.0.2-20060508.zip[/li]
[li]instantclient-odbc-win32-10.2.0.2-20060508.zip[/li]
[li]instantclient-sqlplus-win32-10.2.0.2-20060508.zip[/li]
[/ul][/tt]
Next, I added some System environment variables:
[tt][ul][li]ORACLE_HOME=C:\Oracle\instantclient_10_2[/li]
[li]TNS_ADMIN=C:\Oracle\instantclient_10_2\network\admin\tnsnames.ora[/li][/ul][/tt]
To [tt]PATH[/tt], I added at the end: [tt]C:\Oracle\instantclient_10_2[/tt]. After having done so, I created the file C:\Oracle\instantclient_10_2\network\admin\tnsnames.ora, which contains exactly this:
Code:
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 [tt]odbc_install[/tt] 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,
Alexander
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top