Oracle Error 7303
Contents |
while creating a linked server to Oracle ★★★★★★★★★★★★★★★ SnehadeepJune 30, 201028 Share 0 0 This is one of the
Sql Server 2012 Linked Server Oracle
most common errors while creating linked server to Oracle database. Today microsoft sql server error 7303 linked server I will discuss the reason for this error and possible resolutions.
Full error message:Sql Server Oracle Linked Server Query Syntax
OLE DB provider "MSDAORA" for linked server "LINKED_ORA" returned message "ORA-12154: TNS:could not resolve the connect identifier specified". Msg 7303, Level 16, State 1, oracle linked server equivalent Line 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 of good information on troubleshooting Oracle linked server issues. How to set up and troubleshoot a cannot create an instance of ole db provider oraoledb.oracle for linked server 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 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 oracl
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 a title. You can
Ora-12154: Tns:could Not Resolve The Connect Identifier Specified
not post a blank message. Please type your message and try again. More cannot initialize the data source object of ole db provider "oraoledb.oracle" for linked server discussions in Oracle Provider for OLE DB All PlacesDatabaseDatabase Application DevelopmentWindows and .NETOracle Provider for OLE DB This discussion is
Sql Server Linked Server Oracle Access Denied
archived 2 Replies Latest reply on Oct 10, 2012 1:55 AM by 967297 Steps to connect SQL Server to Oracle works but WHY ?? 888236 Sep 21, 2011 6:18 PM The following 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/ steps is what I have to do in order to get SQL Server to talk to an Oracle database. These steps, for me, work 100% of the time. Any deviation from the following steps will result in failure. Rebooting the machine didn't make any difference between each of the steps. My question is why I have to install the client a second time? All the https://community.oracle.com/thread/2289794 documentation that I have found at Oracle, Microsoft, or elsewhere state that I only need the InstantClient. ========================================= Some server I don't have access to with Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit installed Windows XP SP3 - 32bit with Microsoft SQL Server 2005 SP3 installed The following steps are done on the Windows XP machine. 1) install win32_11gR2_client Select: InstantClient (174.0MB) Path: C:\Oracle 2) install ODTwithODAC112021 Select: Oracle Data Access Components for Oracle Client Oracle Base: C:\Oracle Name: OraClient11g_home1 Path: C:\Oracle\product\11.2.0\client_1 3) Add entries for tnsnames.ora and sqlnet.ora 4) Ensure environmental variable ORACLE_HOME is set to C:\Oracle\product\11.2.0\client_1 5) SQL Server Management Studio Check "Allow Inprocess" for Oracle Provider OraOLEDB.Oracle Restart SQL Server Try to add link to Oracle - fails to connect "The test connection to the linked server failed." Additional information: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) Cannot initialize the data source object of OLE DB Provider "OraOLEDB.Oracle" for linked server "ORACLEDB". OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLEDB" returned message "". (Microsoft SQL Server, Error: 7303) 6) install win32_11gR2_client Select: Administrator (1.02GB) Oracle Base: C:\Oracle Software Location: C:\Oracle\product\11.2.0\client_1 7) Ensure environmental variable ORACLE_HO
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 Learn more about Stack Overflow http://stackoverflow.com/questions/14499977/cannot-create-an-instance-of-ole-db-provider-error-as-windows-authentication-u the company Business Learn more about hiring developers or posting ads with us 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 http://serverfault.com/questions/249677/unable-to-access-oracle-db-from-sql-server-with-odac million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up “Cannot create an instance of OLE DB provider” error as Windows Authentication user up vote 12 down vote favorite linked server 7 I am trying to run openrowset from MS SQL Server on an Oracle server. When i execute the following command: select * from OPENROWSET('OraOLEDB.Oracle','srv';'user';'pass', 'select * from table') the following error occurs Msg 7302, Level 16, State 1, Line 1 Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "(null)". Can anyone tell me how I can use openrowset with OraOLEDB.Oracle? I am using 64 bit version of linked server oracle MS SQL Server and Oracle OLEDB driver. Edit I have tried this on two machines running Windows 7 x64 & Windows Server 2008 x64 with MS SQL Server 2008 x64. Both showed the same error message. sql-server oracle oledb windows-authentication linked-server share|improve this question edited Nov 21 '13 at 14:10 patrickmdnet 2,3381627 asked Jan 24 '13 at 11:14 th1rdey3 2,05941544 I am trying to run OpenQuery against my linked server and getting same error. My linked server is using OraOLEDB.Oracle provider and I have already enabled the allow In Process option. The funny part is I have been using this linked server without any issue since last week, I did sql server reboot and it suddenly started to give error. –Amit Patel Jan 24 '13 at 17:22 add a comment| 4 Answers 4 active oldest votes up vote 28 down vote In SQL Server Enterprise Manager, open \Server Objects\Linked Servers\Providers, right click on the OraOLEDB.Oracle provider, select properties and check the "Allow inprocess" option. Recreate your linked server and test again. share|improve this answer edited Oct 1 '15 at 19:52 answered Jan 24 '13 at 12:28 David Brabant 18.1k64167 2 Brabank, I already tried that, but it still shows the same error. –th1rdey3 Jan 24 '13 at 12:47 Did you recreate
Start 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 Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Unable to access Oracle DB from SQL Server with ODAC? up vote 1 down vote favorite 1 I've downloaded and install the ODAC for connecting oracle DB into my SQL Server 2008 using http://download.oracle.com/otn/other/ole-oo4o/ODAC112021Xcopy_x64.zip The OleDB data provider for Oracle is now available in the SQL Server, but doesn't seems to be usable for now, Shall I install oracle 11gR2 client 64 bit on top of this ODAC ? the following is the result of the right clicking the connection to the oracle server that I just created to test the server connection. TITLE: Microsoft SQL Server Management Studio ------------------------------ The test connection to the linked server failed. ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "DW-DB_PROD". OLE DB provider "OraOLEDB.Oracle" for linked server "DW-DB_PROD" returned message "ORA-12541: TNS:no listener". (Microsoft SQL Server, Error: 7303) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.4000&EvtSrc=MSSQLServer&EvtID=7303&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ DW-DB_PROD is the DB instance name that is available and working from TNSPING command and I can get in from the SQLPLUS. Any kind of help would be greatly appreciated. Thanks windows-server-2008 sql-server sql-server-2008 oracle oracle-11g share|improve this question edited Mar 21 '11 at 4:17 asked Mar 21 '11 at 3:23 Server System Specialist 54321842 add a comment| 1 Answer 1 active oldest votes up vote 0 down