Solved

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

Posted on 2009-06-30
2
7,489 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Not showing page correctly 3 40
Replace &lt; with < 14 59
What .NET URL re-routing tool did I use? 2 54
SQL Login 17 50
Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
In this Article, I will provide a few tips in problem and solution manner. Opening an ASPX page in Visual studio 2003 is very slow. To make it fast, please do follow below steps:   Open the Solution/Project. Right click the ASPX file to b…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

776 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