Connect to ORACLE tables from UltraDev

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>

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.
Who is Participating?
graf27Connect With a Mentor Commented:
If your tnsnames.ora looks like this:


than your connect string is:

Data Source Name:  TEST_FLTPROJ
                     User Name: TR/<password>
                     Server: IMAPTIS.WORLD

where .WORLD is the domain-name from the database ! ( You can also leave the .WORLD).

So I don't understand your  "@MAP3.MSFC.NASA.GOV" in the TNS-name.

You can also put the whole line from tnsnames.ora to the connect-information:

Data Source Name:  TEST_FLTPROJ
                     User Name: TR/<password>
                     Server: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) .... <all together in one line !>

This is possible since SQL-NET 3.0

One way to test the TNS-String is:

c:\oracleHome1\bin\tnsping IMAPTIS.WORLD
PIERCGGAuthor Commented:
You were absolutely correct!!!  The @msfc part of the TNS was wrong.
All Courses

From novice to tech pro — start learning today.