Hi All,
I am new at Oracle, so bear with me.
I have installed InstantClient_1 0_2 and installed the Oracle10.2 drivers on my computer. I am trying to establish the ODBC Connection. Here are the steps I am taking.
1. Go to Administrative Tools > Data Sources (ODBC) > System DNS Tab
2. Click Add... and select the "Oracle in Instantclient_1 0_2" driver
Then I try to set up my DNS. I get an error message. The DBA gave me this script as the TNS:
XXX.CLIENTNAME. COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =xxxxx.clientna me.com)(PORT = ####))
)
(CONNECT_DATA =
(SERVICE_NAME = xxxxxx.clientna me.com)
)
)
See the screenshots below for my setup and error message I receive.
Could someone help me out with how to correctly configure the ODBC connection into Oracle. Thanks.
I am new at Oracle, so bear with me.
I have installed InstantClient_1 0_2 and installed the Oracle10.2 drivers on my computer. I am trying to establish the ODBC Connection. Here are the steps I am taking.
1. Go to Administrative Tools > Data Sources (ODBC) > System DNS Tab
2. Click Add... and select the "Oracle in Instantclient_1 0_2" driver
Then I try to set up my DNS. I get an error message. The DBA gave me this script as the TNS:
XXX.CLIENTNAME. COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =xxxxx.clientna me.com)(PORT = ####))
)
(CONNECT_DATA =
(SERVICE_NAME = xxxxxx.clientna me.com)
)
)
See the screenshots below for my setup and error message I receive.
Could someone help me out with how to correctly configure the ODBC connection into Oracle. Thanks.