Ora 12154 Error In Visual Studio 2010
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta
Visual Studio Ora-12154
Discuss the workings and policies of this site About Us Learn tns could not resolve the connect identifier specified visual studio more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us
Ora-12154 Tns Could Not Resolve The Connect Identifier
Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, ora-12154 tns could not resolve service name helping each other. Join them; it only takes a minute: Sign up Oracle ORA-12154 error on local IIS, but not with Visual Studio Development Server up vote 3 down vote favorite 2 I've got an ASP.NET application that can connect to Oracle when it's started by Visual Studio Development Server, but when I deploy it to my ora-12154 tns could not resolve the connect identifier specified windows 7 local IIS, it does not connect, showing the "ORA-12154: TNS:could not resolve the connect identifier specified" error. My connection string was: Data Source=ABC; User Id=USER; Password=PASSWORD; Tt's using TNS. My tnsnames.ora is located at C:\oracle\instantclient_10_2\network\admin, and my ORACLE_HOME system variable is pointing to C:\oracle\instantclient_10_2. To make it work, I changed the connection string to: "SERVER=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = server1.theplaceiwork.com)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = server2.theplaceiwork.com)(PORT = 1521))(LOAD_BALANCE = yes))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = ABC)(FAILOVER_MODE =(TYPE = SELECT)(METHOD = BASIC))));uid=USER;pwd=PASSWORD;" So TNS is used no longer. But I'd like to know why I can connect using TNS while debbuging with Visual Studio, but when using IIS I can't. Any tips? PS. I can use SqlDeveloper with TNS showing no connection errors. Thanks asp.net oracle iis tns share|improve this question asked Aug 24 '11 at 13:30 Fabio Gouw 1,80921838 Is IIS sitting on the same machine as VS? –NullUserException Aug 24 '11 at 14:07 Yes, it's a development machine (Win2003). –Fab
Visual Studio Development > Visual Studio Setup and Installation Question 0 Sign in to vote Just installed VS 2010 Prof. - form the Server Explorer - I try to add Data Connection to
Tns Could Not Resolve The Connect Identifier Specified Oracle 10g
Oracle database I get: ORA-12154: TNS:could not resovle the connect identifier specified BUT ora-06413 SQL, TNSPING and MSQuery thro OBDC all work fine so I know the TNSname definition is good. Doesnt matter wether i
Tnsnames.ora Location
use OLE, ODBC, .NET for Oracle - all ot=ptions fali to connect. Any ideas??? Kev Wednesday, August 17, 2011 11:56 AM Reply | Quote Answers 0 Sign in to vote Found a solution from link http://stackoverflow.com/questions/7176252/oracle-ora-12154-error-on-local-iis-but-not-with-visual-studio-development-serv below http://stackoverflow.com/questions/4228739/vs2010-oracle-driver-ora-12154-tsncould-not-resolve-the-connect-identifier-s Rather than giving the TNSname i gave server/SDI eg //DHA03116-SSDp06:1521/GFDDev Connected OK.Kev Gibson Marked as answer by KevGibson Monday, August 22, 2011 10:40 AM Monday, August 22, 2011 10:39 AM Reply | Quote All replies 0 Sign in to vote Hi Kev, Welcome to the MSDN forum. Under my research, for the error “ORA-12154: TNS:could not resovle the connect identifier specified”, the possible cause is that https://social.msdn.microsoft.com/Forums/vstudio/en-US/452f4eb5-f86e-4c02-8826-69b01f3e6bb5/ora12154-tnscould-not-resovle-the-connect-identifier-specified?forum=vssetup a connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository could not be located or reached. I have found some possible solution about this issue: 1. Create the environment variable: ORACLE_HOME via: control panel > system > advanced > environment variables and then DBArtisan knew where to find tnsnames.ora. 2. Make sure that "TNSNAMES" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA) 3. Verify that a TNSNAMES.ORA file exists and is in the proper directory and is accessible. 4. Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file. 5. Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file. Look for unmatched parentheses or stray characters. Errors in a TNSNAMES.ORA file may make it unusable. 6. Change the Oracle connection from "TNSNAME Mode" to "Standard mode". 7. "Allow inprocess" has to be che
resolve the connect identifier specified” ★★★★★★★★★★★★★★★ SnehadeepJanuary 26, 201010 Share 0 0 When you try to develop an SSIS https://blogs.msdn.microsoft.com/dataaccesstechnologies/2010/01/26/connectivity-issue-with-oracle-in-x64-environment-ora-12154-tnscould-not-resolve-the-connect-identifier-specified/ package in x64 Environment in BIDS that connects to a https://www.youtube.com/watch?v=QVJ1xO2V7Dc Oracle Database, you will invariably run into connectivity issues if the installed Oracle Client tools version is 10.2.0.1 (x86). You will obviously need to install the 32-BIT version of Oracle Client to communicate with BIDS which is a 32-BIT application!
Subject: tns could ORA-12154 or ORA-6413 Running 32-bit Oracle Software on 64-bit Windows OS. Applies to: Oracle Net Services - Version: 8.1.7.0 to 10.2.0.1 Oracle Data Provider for .NET - Version: 8.1.7.0 to 10.2.0.1 Oracle Objects for OLE - Version: 8.1.7.0 to 10.2.0.1 Oracle Provider for OLE tns could not DB - Version: 8.1.7.0 to 10.2.0.1 Oracle ODBC Driver - Version: 8.1.7.0 to 10.2.0.1 Microsoft Windows XP (64-bit Itanium) Microsoft Windows Server 2003 (64-bit Itanium) Microsoft Windows XP (64-bit AMD64 and Intel EM64T) Microsoft Windows Server 2003 (64-bit AMD64 and Intel EM64T) Symptoms: You are attempting to connect to the Oracle database from a Windows platform using one of the following programmatic interfaces · ODBC · OLEDB · OO4O · ODP.NET After installing 32-bit Oracle client software on a 64-bit Windows operating system (OS) you receive one of the following errors: ORA-12154: TNS:could not resolve the connect identifier specified or ORA-6413: Connection not open. Cause: 64-bit Microsoft OS's install 32-bit applications into the following location "C:\Program Files (x86)\…" rather than the typical location of "C:\Program FileDu kan ändra inställningen nedan. Learn more You're viewing YouTube in Swedish. You can change this preference below. Stäng Ja, behåll den Ångra Stäng Det här videoklippet är inte tillgängligt. VisningsköKöVisningsköKö Ta bort allaKoppla från Läser in ... Visningskö Kö __count__/__total__ Ta reda på varförStäng How to resolve the ora 12154 error DBA Pro PrenumereraPrenumerantSäg upp1 9751 tn Läser in ... Läser in ... Arbetar ... Lägg till i Vill du titta på det här igen senare? Logga in om du vill lägga till videoklippet i en spellista. Logga in Dela Mer Rapportera Vill du rapportera videoklippet? Logga in om du vill rapportera olämpligt innehåll. Logga in Statistik 50 612 visningar 42 Gillar du videoklippet? Logga in och gör din röst hörd. Logga in 43 17 Gillar du inte videoklippet? Logga in och gör din röst hörd. Logga in 18 Läser in ... Läser in ... Läser in ... Rankning kan göras när videoklippet har hyrts. Funktionen är inte tillgänglig just nu. Försök igen senare. Publicerades den 31 jan. 2014In this tutorial you will learn how to resolve the ora 12145 error. Kategori Människor och bloggar Licens Standardlicens för YouTube Visa mer Visa mindre Läser in ... Automatisk uppspelning När automatisk uppspelning är aktiverad spelas ett föreslaget videoklipp upp automatiskt. Kommer härnäst Oracle - Understanding the tnsnames.ora and listener.ora files - Längd: 12:46. Chris Ostrowski 91 272 visningar 12:46 How to Fix ORACLE 6i Error "ORA-12154: TNS:could not resolve the connect identifier specified". - Längd: 4:02. SYED AIZAD RAZA KAZMI 3 522 visningar 4:02 ora - 12514 and ora - 12505 tns listener error fixed in 90 seconds ✅ - Längd: 1:30. CBOT 1 746 visningar 1:30 解决 Oracle ora-12514错误 - Längd: 33:45. Maclean Liu 1 025 visningar 33:45 Listener Basics For DBA - Längd: 45:23. Satish Lodam 14 492 visningar 45:23 Oracle 10g Listener and Database Creation - Längd: 6:05. Recouner 7 681 visningar 6:05 Best way to connect Oracle with Visual Studio .NET (no BadImageFormatException or mismatch error) - Längd: 9:45. Samiul Al Hossaini 12 779 visningar 9:45 Easy guidelines to fix Error 12514 - Längd: 1:24. rhina disouza 2 023 visningar 1:24 Oracle - TNS : Protocol Adapter Error Working Solution - Längd: 0:57. Srijit