Home > Visual Studio > Visual Studio 2010 Ora-12154 Error

Visual Studio 2010 Ora-12154 Error


That way, we'll be able to get a better idea. Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file. Data Source=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=; Reply Gr says: October 4, 2013 at 11:43 am How Can Write Code in Access So That Link To Specified Table In ORacle Without Using ODBC, When Give Sign in Statistics 51,400 views 41 Like this video? navigate here

What does "M.C." in "M.C. Feb 08, 2007 01:13 AM|ramana123|LINK Hi did you give permissions to the ASP.NET users for ORacle home folder and subfolders too[Check this at subfolders level whether the permissions were set or Oracle ORA-12154 Reply mfouwaaz Member 541 Points 265 Posts Re: to oracle application produces error ORA-12154 :TNS:could not resolve the connect ide... None 0 Points 1 Post Re: to oracle application produces error ORA-12154 :TNS:could not resolve the connect ide...

Visual Studio Ora-12154

Privacy statement Dev Centers Windows Office More... With your advics I found my problem was TNS_ADMIN and ORACLE_HOME in regedit. See also the FAQ entry, can I use ODT 11g with an Oracle 10 or Oracle 9 database? Thanks Tom Reply mfouwaaz Member 541 Points 265 Posts Re: to oracle application produces error ORA-12154 :TNS:could not resolve the connect ide...

In almost all cases it will work fine. Exception Details: System.Data.OracleClient.OracleException: ORA-12154: TNS:could not resolve the connect identifier specified Source Error: An unhandled exception was generated during the execution of the current web request. Jun 05, 2008 12:14 PM|TheEarthWillShake|LINK Does this help at all? Oracle Developer Tools For Visual Studio ya da man yosif, btw do you know how to add TNS_NAMES variable in visual studio installer?

This comment has been removed by the author. Tns Could Not Resolve The Connect Identifier Specified Visual Studio These permissionsare standardfix for ORA-12154 but theOLDcomputer name wasa twistnot mentionedamong all the posts I've read. No complaints. website here My scenario is as follows: - Win 2008 - Oracle 11g - IIS 7.0, configured to manage .svc-styled web services Oracle connectivity has been tested through a standard ODP client -

If it's a local account (on your webserver) it won't be able to be authentified on a network ressource. Ora-12545: Connect Failed Because Target Host Or Object Does Not Exist I think you might have found a problem !! , I thought the path would be C:\InstantClient In my enviroment variables I have the following System variables Path variable "C:\XEClient\bin"..."C:\instantClient" SQLPATH So, I think the problem is with access to tnsnames.ora or sqlnet.ora, because when you run your app in VS Developement Server it runs under your account's right (or user who Unfortunatley it did not resolve the TNS error I'm recieving.

Tns Could Not Resolve The Connect Identifier Specified Visual Studio

I can debug into the service method and the connection.Open() method throws an exception when the connection string is identical to the one that was used in the simple database client. Which is the most acceptable numeral for 1980 to 1989? Visual Studio Ora-12154 Life issues 101 views 13:08 C# Connect Oracle Database - Duration: 16:19. Oracle Dataaccess Client Oracleexception Ora 12154 Here is my attempt to clarify them: 1. "Alias" is referred to as "Connection Name" in Oracle SQL Developer.

C# Tutorial 96,971 views 49:55 How to Fix ORACLE 6i Error "ORA-12154: TNS:could not resolve the connect identifier specified". - Duration: 4:02. Monday, August 22, 2011 7:24 AM Reply | Quote 0 Sign in to vote Thanks for the effort:- 1. Sign in Share More Report Need to report the video? Check if the environment variable ‘PATH' has the path for tnsnames.ora file specified.

Sample Value of Environment Variable PATH:

E:\app\product\11.1.0\client_1\bin;C:\Program Files\Business Objects\Common\3.5\bin\NOTES\;C:\Program Files\Business Objects\Common\3.5\bin\NOTES\DATA\;%Systemroot%\Microsoft.NET\Framework\v1.1.4322;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Dell\SysMgt\oma\bin;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\Common Ora 12154 Tns Could Not Resolve The Connect Identifier Specified 11g

rhina disouza 2,023 views 1:24 Oracle Forms 6i setup and TNS configuaration (SEFAT) - Duration: 13:37. The Visual Studio wizard told me: "ORA-12154: TNS:could not resolve the connect identifier specified". Star 8561 Points 2044 Posts Re: to oracle application produces error ORA-12154 :TNS:could not resolve the connect ide... his comment is here Skip navigation UploadSign inSearch Loading...

Was able to edit the TNS_Names and to get it working after a 2nd Oracle Client attempt was made. Check the "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES\HOME_COUNTER" key value.

10. Any ideas?

Apr 05, 2007 10:30 AM|aidoco|LINK Hi PTEKelly I have in the web.config and I *believe* I have the correct permission for teh ASPNET user on teh appropriate

Sign in to make your opinion count. November 5, 2012 at 8:38 PM Anonymous said... Sign in Statistics 4,949 views 18 Like this video? The only exception is with the automatic .NET code generation feature.

Dim conn As New Odbc.OdbcConnection Dim cmd As New Odbc.OdbcCommand Dim drResult As Odbc.OdbcDataReader Dim connString As String Dim QuerySQL As String connString = "Driver={Microsoft ODBC for Oracle};CONNECTSTRING=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ORACLEDB01)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORACLE_INSTANCE_NAME)));Uid=john;Pwd=mypassword;" QuerySQL = "select Try to connect to Oracle from the SQL server using the UDL. Reply fab777 1235 Posts Re: ORA-12154: TNS:could not resolve the connect identifier specified Oct 04, 2012 03:29 AM|fab777|LINK Yes, that makes sense, it's a best practice. Can I use the latest features in Oracle Developer Tools 11g and still use ODP.NET version 10.x or 9.x in my application?

But you can still mark it as answer if it's helped you. Working... This works great. Solution: Download the latest ODAC 11g release and install it.

My 21 yr old adult son hates me Using "están" vs "estás" when refering to "you" Does the reciprocal of a probability represent anything? Add to Want to watch this again later? share|improve this answer edited Aug 30 '12 at 16:53 answered Aug 29 '12 at 15:12 LeftyX 21.9k1674144 OK, this is weird...when I take the connection information from my TNSNames.Ora Solution: Yes!

Sign in to add this to Watch Later Add to Loading playlists... Published on Jan 31, 2014In this tutorial you will learn how to resolve the ora 12145 error. Word/phrase/idiom for person who is no longer deceived What is mathematical logic? You are the man!

This was removed - there's no #4. 5. Solution: In general, if any errors occured during the installation process, you should correct the problem before attempting to use the product or this error may result. Autoplay When autoplay is enabled, a suggested video will automatically play next. Wysheid Wysheid 10,553 views 5:29 Oracle DBA Justin - How to reset a user accounts password in an Oracle database - Duration: 11:26.

I do have permissions to the file so I can access the file. When you use visual studio to run this web application, it did work fine. Even when I do that it still keeps on giving me the same error. This helped me a great deal April 24, 2014 at 3:11 AM Anonymous said...

Make sure you can ping any server names short or long. Please try again later. Browse other questions tagged visual-studio-2010 oracle or ask your own question.