Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Connect to ORACLE tables from UltraDev

Posted on 2002-05-06
2
Medium Priority
?
387 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 1200 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

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!
Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
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 reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…

824 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