Solved

ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Posted on 2009-06-30
2
7,484 Views
Last Modified: 2012-05-07
Hi
I have an ASP.NET website which works on a server but not on my machine. (I just copied the code from the server to my machine)

I get the error "ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA"

It seems to happen on the line
Dim myConnection As New OleDbConnection(ConnectionString)

where connectionstring is
"Provider=MSDAORA;User ID=INV_ROUT;password=xxx;Data Source=B733"

Any ideas?
Thanks
0
Comment
Question by:hmcgeehan
2 Comments
 
LVL 22

Accepted Solution

by:
prairiedog earned 50 total points
ID: 24745718
In order to connect to an Oracle database, you will need a file called "tnsnames.ora" which contains the necessary settings for the Oracle database. It seems that you don't have the file on your local machine. You should be able to copy the one from server and pasted on your machine.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

930 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

8 Experts available now in Live!

Get 1:1 Help Now