Solved

Connect to ORACLE tables from UltraDev

Posted on 2002-05-06
2
377 Views
Last Modified: 2013-12-24
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.
0
Comment
Question by:PIERCGG
2 Comments
 
LVL 3

Accepted Solution

by:
graf27 earned 300 total points
ID: 6993828
If your tnsnames.ora looks like this:

IMAPTIS.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
  (HOST=map3.msfc.nasa.gov)(PORT=1521))(CONNECT_DATA=(SID=IMAPTIS)))

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
0
 
LVL 6

Author Comment

by:PIERCGG
ID: 6996543
You were absolutely correct!!!  The @msfc part of the TNS was wrong.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question