Msdaora Error 7303
Contents |
360 games PC games microsoft sql server error 7303 linked server Windows games Windows phone games Entertainment All Entertainment sql server 2012 linked server oracle Movies & TV Music Business & Education Business Students & educators error 7302 linked server oracle Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Sql Server Oracle Linked Server Query Syntax
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 provider string for oracle linked server 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
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 error and possible resolutions.
oracle linked server equivalent Full error message: OLE DB provider "MSDAORA" for linked server "LINKED_ORA" returned message "ORA-12154:Cannot Initialize The Data Source Object Of Ole Db Provider "oraoledb.oracle" For Linked Server
TNS:could not resolve the connect identifier specified".
Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data sourceSp_helplinkedsrvlogin
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 of good information on troubleshooting Oracle linked server issues. https://support.microsoft.com/en-us/kb/280106 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 DB provider for ODBC. Once again on a 64 bit SQL server you need 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/ 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 = server01.mydomain.com)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = OracleDB) (SERVER = DEDICATED) ) ) In the was facing while creating a Linked Server to an Oracle database. He was trying to create a Linked Server to a Oracle Database from a SQL Server 2005 instance. He had the Oracle Client components installed on the server hosting the SQL http://www.sqldbadiaries.com/2010/12/27/cannot-create-an-instance-of-ole-db-provider-oraoledb-oracle-for-linked-server/ Server instance. After giving all the details in the Linked Server properties when clicking on Ok, http://www.bigresource.com/MS_SQL-Linked-Server-Error-7399-MSDAORA-7ebP6nZl.html he would receive the following error message. Since the linked server is Oracle, the first thing that I tried was to check if the Server hosting the SQL Server instance, was able to connect to the listener on the Oracle Database Server using tnsping. tnsping successfully connected to the Oracle database from the SQL Server box. Then I moved on to check the Provider linked server details while creating the Linked Server. The Linked Server provider was Oracle Provider for OLE DB. This is the driver that gets installed along with the Oracle Client Components. This KB article states that Error 7302 can be a result of MSDAORA.dll not being registered correctly. In this case it had to be an issue with the dll related to Oracle Provider for OLE DB i.e.OraOleDB.dll. Before checking the dll related issues, I wanted to check if something was missing in oracle linked server the registry. The list of Providers in the Linked Server is populated from the Providers key in the registry. This key is located under the instance name under the below key. The entries in the registry looked like this. I could not find anything unusual here. Now it was confirmed that something must be wrong with the OraOleDB.dll. This dll is located under the bin directory of the folder where Oracle Client Components are installed (usually called oracle_home). When I navigated to that folder, I could not find any such files. To confirm this, I checked that directory on a *working* instance, the OraOleDB.dll was listed there. Now my job was easy. On the server which was having issues with the Linked Server, the Oracle Client Components were either not installed correctly or it was corrupt. I copied the dll from the *working* server and pasted it under
the oracle service and run queries. I set up the linked server just like I always do, but now when I attempt to access one of the tables on the linked server I get "Error 7399: OLE DB provider 'MSDAORA' reported an error. I am able to use the OLE DB provider for ODBC and connect with ODBC to oracle, but not with the MSDAORA OLEDB provider. Windows 2000 Advanced Server, Service Pack 2; SQL 2000 Server Any help would be great. Thank you in advance. --Bryan Parke View 1 Replies Similar Messages: Error 7399: OLE DB Provider 'MSDAORA' Reported An Error. OLE DB Error Linked Server Error 7399 Linked Server - Sybase - Error 7399 Linked Server To Access 97 - Error 7399 Linked Server - OLE/DB Provider 'MSDAORA' Invalid Use Of Schema Or Catalog For OLE DB Provider MSDAORA For Linked Server CUSTOMERLINK. OLE DB Provider MSDAORA For Linked Server DBNAME Returned Message ORA-01476: Divisor Is Equal To Zero Error Msg 7399, While Trying Run DMX Query From SQL Server The OLE DB Provider MSDAORA For Linked Server .... Does Not Contain The Table COUNTRY. The Table Either Does Not Exist Or The Current User Does Not Have Permissions On That Table. OLE DB Error Trace [Non-interface Error: CoCreate Of DSO For MSDAORA.1 Returned 0x80040154]. Ole Db Provider Msdaora Error Linked Server Authentication Error - [SQLSTATE 42000] (Error 7303) Linked Servers Error Microsoft SQL Server, Error: 7411 7399 Access Denied On Vista Linked Server Error Error With Linked Server Linked Server Error !!! Linked Server Error Error With Linked Server Linked Server Error Linked Server Error Linked SQL Server - Error 7353 Linked Server Query Error DBCOLUMNFLAGS_ISNULLABLE Error On Linked Server.... Linked Server: Error 7391 Error Calling RPC To Linked Server Linked Server Update Error Linked Server On A Cluster Error Linked Server Error 7416 Error Updating DB2 On MVS-MF From A Linked Server Linked Server Setup Error SQLNCLI Linked Server Error ADVERTISEMENT Error 7399: OLE DB Provider 'MSDAORA' Reported An Error. OLE DB Error Feb 18, 2007 My link server was working just fine until friday evening.It stopped worked over the week end.with and error Error 7399: OLE DB provider 'MSDAOR