Attempting an ODBC/DSN connection to Oracle

We have a Windows 2000 server running IIS application server and running Oracle 8.1.7.  On my local
machine I am running Windows 2000 and UltraDev 4.  When I try to set up a DSN connection, I am getting
the following error message from UltraDev:

[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS: could not resolve service name.

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed.

In the DSN setup on my local machine, I have defined the following:

Data Source Name:  TEST_FLTPROJ
User Name: TR/<password>
Server: IMAPTIS@MAP3.MSFC.NASA.GOV

IMAPTIS is the name of the ORACLE instance
TR is the table name
Where <password> is shown, I entered the actual password which I do not want to post here.

Where is my problem?  What have I not gotten right?

In my TNSNAMES.ora file, the IMAPTIS strings are defined correctly.  I can get into the Oracle database
from my machine via SQL*Net but not using the ODBC connectivity.
LVL 6
PIERCGGAsked:
Who is Participating?
 
waynezhuConnect With a Mentor Commented:
>>    Server: IMAPTIS@MAP3.MSFC.NASA.GOV (?)

Is it supposed to be "Server: IMAPTIS"
or                   "Server: IMAPTIS.MAP3.MSFC.NASA.GOV"

Check against the definition in the TNSNAMES.ORA.

The value entered at the Server field should be exactly same as the TNS connection string you have defined in the TNSNAMES.ora.
0
 
soraCommented:
will follow this thread


sora
0
 
PIERCGGAuthor Commented:
That was it.  Thanks you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.