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:
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
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)
)
)
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