Home > tns could > ora 12154 error in visual studio 2010

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 File

Du 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

 

Related content

error in initializing provider ora-12154

Error In Initializing Provider Ora- table id toc tbody tr td div id toctitle Contents div ul li a href Ora- Tns Could Not Resolve The Connect Identifier Specified Windows a li li a href Tns Could Not Resolve The Connect Identifier Specified Oracle g a li li a href Tns- Failed To Resolve Name a li ul td tr tbody table p while creating a linked server to Oracle x x x x x x x x x x x x x x x SnehadeepJune This relatedl is one of the most common errors while ora tns could not

error ora 12154 tns could not resolve connect identifier specified

Error Ora Tns Could Not Resolve Connect Identifier Specified table id toc tbody tr td div id toctitle Contents div ul li a href Ora Tns Could Not Resolve The Connect Identifier Specified Xe a li li a href Ora Tns Could Not Resolve The Connect Identifier Specified g a li li a href Ora Tns Could Not Resolve The Connect Identifier Specified N a li li a href Ora Tns Could Not Resolve Service Name Oracle i a li ul td tr tbody table p while creating a linked server to Oracle x x x x x x x

error ora-12154 tns could not resolve the connect

Error Ora- Tns Could Not Resolve The Connect table id toc tbody tr td div id toctitle Contents div ul li a href System Data Oracleclient Oracleexception Ora Tns Could Not Resolve The Connect Identifier Specified a li li a href Ora Tns Could Not Resolve Service Name Oracle i a li li a href Ora Tns Could Not Resolve Service Name Windows a li ul td tr tbody table p TNS received bad packet type from network layer Cause Internal error Action Not normally visible to the user For further details turn on tracing and relatedl reexecute the operation

oci error 12154

Oci Error table id toc tbody tr td div id toctitle Contents div ul li a href Test Connection Failed Because Of An Error In Initializing Provider Ora- a li li a href Ora- Sqlplus a li ul td tr tbody table p Read Quick Links Today's Posts View Site Leaders Who's Online Advanced Search Forum Microsoft SSIS Connectors and Change Data Capture by Attunity Microsoft SSIS Connectors by Attunity Microsoft SSIS Oracle Connector relatedl ORA- TNS could not resolve the connect identifier specified Results to ora tns could not resolve the connect identifier specified g of Thread ORA- TNS

odbc error ora-12514

Odbc Error Ora- table id toc tbody tr td div id toctitle Contents div ul li a href Ora- Tns Could Not Resolve Service Name Oracle g a li li a href Ora Tns Could Not Resolve Service Name Oracle i a li li a href Ora Error In Oracle g a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us relatedl Learn more about Stack Overflow the company Business Learn more about

odp.net tns error

Odp net Tns Error table id toc tbody tr td div id toctitle Contents div ul li a href Ora Tns Could Not Resolve The Connect Identifier Specified g a li li a href Ora- Oracle c a li li a href Ora Tns Could Not Resolve Service Name a li li a href Oracle Managed Data Access a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the relatedl workings and policies of this site About Us Learn more p h

oo4o tns error

Oo o Tns Error table id toc tbody tr td div id toctitle Contents div ul li a href Ora- Tns Could Not Resolve The Connect Identifier Specified Windows a li li a href Tns Could Not Resolve The Connect Identifier Specified Visual Studio a li li a href Oracle Provider For Ole Db a li ul td tr tbody table p CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError You don't have JavaScript enabled This tool uses JavaScript and much of it will not work correctly without relatedl it enabled Please turn JavaScript back on and ora tns could

ora 12154 error visual studio

Ora Error Visual Studio table id toc tbody tr td div id toctitle Contents div ul li a href Ora- Tns Could Not Resolve The Connect Identifier a li li a href Ora- Tns Could Not Resolve The Connect Identifier Specified Windows a li li a href Tns Could Not Resolve The Connect Identifier Specified Oracle g a li li a href Tnsnames ora Location a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have relatedl Meta Discuss the workings and policies of this

ora-12154 ssis error

Ora- Ssis Error table id toc tbody tr td div id toctitle Contents div ul li a href Ora Tns Could Not Resolve The Connect Identifier Specified g a li li a href Ora- Tns Could Not Resolve Service Name a li li a href Tns Could Not Resolve The Connect Identifier Specified Visual Studio a li li a href Tns Could Not Resolve The Connect Identifier Specified Oracle g a li ul td tr tbody table p HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ relatedl Search related threads Remove From My Forums p h

ora-12154 sqlplus error

Ora- Sqlplus Error table id toc tbody tr td div id toctitle Contents div ul li a href Tnsping Works But Sqlplus Does Not Ora- a li li a href Ora- Tns Could Not Resolve Service Name a li li a href Sqlnet ora Example a li ul td tr tbody table p log in tour help Tour Start here for a quick overview of relatedl the site Help Center Detailed answers to any tns could not resolve service name sqlplus questions you might have Meta Discuss the workings and policies of p h id Tnsping Works But Sqlplus Does

oracle error 12151

Oracle Error table id toc tbody tr td div id toctitle Contents div ul li a href Ora- Tns Could Not Resolve Service Name a li li a href Error While Trying To Retrieve Text For Error Ora- a li li a href Tns Could Not Resolve The Connect Identifier Specified Odbc a li ul td tr tbody table p TNS received bad packet type from network layer Cause Internal error Action Not normally visible to the user For relatedl further details turn on tracing and reexecute the operation ora error in oracle g If error persists contact Worldwide Customer

oracle listener error code 10559

Oracle Listener Error Code table id toc tbody tr td div id toctitle Contents div ul li a href Ora Tns No Listener a li li a href Ora- Tns Could Not Resolve Service Name Oracle g a li li a href Tns Could Not Resolve The Connect Identifier Specified Sqlplus a li ul td tr tbody table p TNS received bad packet type from network layer Cause Internal error Action Not normally visible to the user For further details turn on tracing relatedl and reexecute the operation If error persists contact Worldwide Customer ora- error Support ORA- TNS unable