Solved

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

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
asp day pilot 3 23
ASP.NET gridview select textbox on focus 2 57
Following an example - Why do I need to click Save button twice? 3 28
RLDC Reporting in Visual studio 11 30
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…
ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…

839 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