Solved

Connect to ORACLE tables from UltraDev

Posted on 2002-05-06
2
382 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

Question has a verified solution.

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

When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The purpose of this video is to demonstrate how to automatically show related posts at the bottom of a blog post in WordPress. This will be demonstrated using a Windows 8 PC. Plugin “Yet Another Related Posts Plugin” will be used. Go to your…
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…

617 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