Microsoft Data Link Error Ora-12514
Contents |
while creating a linked server to Oracle ★★★★★★★★★★★★★★★ SnehadeepJune 30, 201028 Share 0 0 This is one of the most common errors while creating linked server to Oracle database. Today I will discuss the reason for this
Ora-12154 Tns Could Not Resolve Service Name
error and possible resolutions.
Full error message: OLE DB provider "MSDAORA" for ora-12154 tns could not resolve the connect identifier specified windows 7 linked server "LINKED_ORA" returned message "ORA-12154: TNS:could not resolve the connect identifier specified". Msg 7303, Level 16, State 1, LineOra-12154 Tns Could Not Resolve Service Name Oracle 11g
1
Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "LINKED_ORA". First of all make sure you have reviewed the following Microsoft KB article that has a lot ora-12154 tns listener does not currently know of service requested in connect descriptor of good information on troubleshooting Oracle linked server issues. How to set up and troubleshoot a linked server to an Oracle database in SQL Server http://support.microsoft.com/kb/280106 Also make sure you have installed Oracle Client on the SQL server. If the SQL server is 64 bit then we need to install 64 bit Oracle provider. You can also create linked server using Oracle ODBC driver together with Microsoft OLE tns could not resolve the connect identifier specified oracle 10g DB provider for ODBC. Once again on a 64 bit SQL server you need to install the 64-Bit OLEDB Provider for ODBC (MSDASQL) and 64 bit Oracle ODBC drivers. However 64-Bit OLEDB Provider for ODBC (MSDASQL) is already there in Windows Vista/Windows Server 2008 and later OS. This particular error message is a very general error message and can happen for quite a number of reasons. For general understanding of the error, you can review oracle documentation like this http://ora-12154.ora-code.com/ In SQL Server Linked Server, it could indicate a few things (not limited to)– 1. SQL Server (and oracle net libraries) is not able to get the TNS alias from tnsnames.ora file. 2. Something is wrong with the way the alias is created in the tnsnames.ora file (incorrect syntax) 3. TNS alias could not be resolved into a connect descriptor Below is a list of things that you can try to resolve this issue. 1. Verify that the tnsnames.ora file has the alias and the service name that the customer is using. TNS entry for the Oracle database =========================== OracleDB_Dev = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = serv360 games PC games
Asp.net Ora-12154: Tns:could Not Resolve The Connect Identifier Specified
Windows games Windows phone games Entertainment All Entertainment tns could not resolve the connect identifier specified sqlplus Movies & TV Music Business & Education Business Students & educators
Error While Trying To Retrieve Text For Error Ora-12154
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet https://blogs.msdn.microsoft.com/dataaccesstechnologies/2010/06/30/ora-12154-tns-could-not-resolve-the-connect-identifier-specified-error-while-creating-a-linked-server-to-oracle/ Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/280106 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
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 it enabled. Please turn JavaScript back on and reload this page. Please enter https://community.oracle.com/thread/491837 a title. You can not post a blank message. Please type your message and try again. More discussions in ODBC All PlacesDatabaseDatabase Application DevelopmentWindows and .NETODBC This discussion is archived http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1140092715 7 Replies Latest reply on Sep 9, 2009 5:57 PM by vijay polsani ORA-12514: TNS:listener does not currently know of service requested 569109 Mar 27, 2007 4:54 AM I'm currently could not trying to set up a reporting data source in VS2005 in a Reporting project. Now when I try to create a new report using my Oracle based data source I get the following: A connection cannot be made to the database. Set and test the connection string. ERROR [NA000] [Microsoft][ODBC driver for Oracle][Oracle]ORA-12514: TNS:listener does not currently know of service requested could not resolve in connect descriptor ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). I've installed the data tools for VS2005 as well as the 10g client. I can tsnping the database, as well as connect to it using the SQLPlus tool. I only seem to have an issue when connecting through VS2005. Anyone able to shed some light?? Greg P.S. I'm using XP Pro. 35563Views Tags: none (add) This content has been marked as final. Show 7 replies 1. Re: ORA-12514: TNS:listener does not currently know of service requested 580406 Jun 12, 2007 8:39 AM (in response to 569109) Hi Greg, I am experiencing the same problem. I have found a lot of links in internet with different solutions but so far nothing works. Have you found a solution for this issue or a workaround? Josue Like Show 0 Likes(0) Actions 2. Re: ORA-12514: TNS:listener does not currently know of service requested 583990 Jun 19, 2007 9:02 PM (in response to 580
› › ‹ No topic | No topic › Pages: 1 Error ORA-12514 when trying to connect. (Read 20226 times) Gerrit-Jan Linker YaBB Administrator Posts: 75 Error ORA-12514 when trying to connect. 16.02.06 at 13:25:15 Error ORA-12514 when trying to connect. Quote:We use the SQL*XL software to connect Excel to our databases for business intelligent queries. We upgraded one of our servers to Oracle 10g. I installed the Oracle 10g client on my laptop. I now have both the Oralce 8.0.5 & Oracle 10.g clients on my machine. SQL XL has stopped working. When I use SQL*XL to connect from Excel to a database (either 8.05 or 10g) I get: "Oracle Connection Error received : Unable to make conection, ORA-12514: TNS:listerner does not currently know of service requested in connect descriptor." Why not give SQL*XL a try today. SQL*XL: SQL Excel software Download SQL*XL now! Answer: This is a TNS problem. While SQL*XL will try to use several different connections in the connection wizard to connect Excel to the Oracle database, this is a situation that it cannot overcome. The TNS configuration specifies the name under which the database is known on the computer and hides all server details. The problems must be sought in the specification of the TNS names and/or in the setup of the database server. Possibly your new database has a different listener. The configuration of your TNS name / Database alias may not be correct anymore. You can fix this by making a new database alias or TNS name using the Oracle configuration utilities on your PC. You can also try to edit the tnsnames.ora file on your PC if you know what you are doing. The following command may also be of help. Do Start -> Run : TNSPING <