Connecting Tech Pros Worldwide Forums | Help | Site Map

ODBC to Oracle Question

Newbie
 
Join Date: Feb 2008
Posts: 17
#1: Mar 6 '08
Hi All,

I am new at Oracle, so bear with me.

I have installed InstantClient_10_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_10_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.clientname.com)(PORT = ####))
)
(CONNECT_DATA =
(SERVICE_NAME = xxxxxx.clientname.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.
Attached Thumbnails
new.jpg   new2.jpg  

Reply