Solved

Connect to ORACLE tables from UltraDev

Posted on 2002-05-06
2
376 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

In this short web based tutorial, I wanted to show users how they can still use the powers of FrontPage in conjunction with Expression Web 3.  Even though Microsoft eliminated the use of Web components, we can still use them with FrontPage and edit …
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…
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…
The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…

867 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now