Error 7303 Linked Server Oracle
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: not able to create a link server to access an Oracle DB from SQL server sql error 7303 linked server oracle 2005 SP2 SQL Server > SQL Server Database Engine Question 0 Sign in microsoft sql server error 7303 linked server oracle to vote Hi all,I'm not able to create a link server to access an Oracle DB from SQL server. My
Error 7302 Linked Server Oracle
environment: - Windos XP- SQL 2005 Dev SP2- Oracle 10g & Client & Oracle Provider for OLD DB 10.2... - MDAC 2.8 I linked Oracle from within SQL Management studio.I'm able to Ping
Error 7399 Linked Server Oracle
the server using TNSPING oracleservername and I'm able to connect to sql server using oracel toolsI test the connection to Oracle via OraOLEDB.Oracle.1 using a UDL file and the connection is successful.Also I'm able to connect to the oracle server using the SSSI 2005 DTSwizard using the Oracle Provider for OLE DBI'm NOT Able to connect using the linked server: sp_addlinkedserver 'LS_ora10g', 'Oracle','OraOLEDB.Oracle','ORA10G_NAME.COM'gosp_addlinkedsrvlogin 'LS_ora10g','False', NULL, 'user', linked server to oracle from sql server 2012 'password' MyTNSNAME.org is like:ORA10G_NAME.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ORA10G_NAME.COM)(PORT = 1521)) ) (CONNECT_DATA = (SID = oracleservername) (SERVER = DEDICATED) ) When I try test the connection o GOT "The test connection to the linked server failed." Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "LS_ora10g". (Microsoft SQL Server, Error: 7302) Any ideas what is wrong ?? Is my sqlquery missing something???Thanks
Monday, September 10, 2007 11:14 PM Reply | Quote All replies 2 Sign in to vote This is most probably due to the Oracle provider loaded out of process. If you set it to load in process then it should work. So in SSMS, go to Server Objects\Linked Servers\Providers and locate the Oracle provider. Set the 'AllowInProcess' option to true. You will have to restart SQL Server services and try again. Saturday, September 15, 2007 6:47 PM Reply | Quote 0 Sign in to vote Hi Thanks for your response. Yes I check the AllowInProcess set to true, but still doesn't work. My Registry on MSDTC is like this: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI OracleOciLib = oci.dllOracleSqlLib = SQLLib80.dllOracleXaLib = xa80.dll May be this values shoudl point tup Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » SQL Server
Linked Server To Oracle From Sql Server 2008
2005 General Discussion » Problems with Linked Server 28 posts,Page 1 of 3123»»» linked server to oracle from sql server 2008 r2 Problems with Linked Server Rate Topic Display Mode Topic Options Author Message J39L4753J39L4753 Posted Friday, January 29, 2010 3:21 AM cannot create an instance of ole db provider oraoledb.oracle for linked server SSC-Enthusiastic Group: General Forum Members Last Login: Friday, March 14, 2014 3:20 AM Points: 117, Visits: 382 I am trying to create a Linked Server to an Oracle db.I have installed Oracle Database 10g https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5c57848b-d61e-4920-abad-4ba9eb1ceac5/not-able-to-create-a-link-server-to-access-an-oracle-db-from-sql-server-2005-sp2?forum=sqldatabaseengine Client Release 2 and then installed Oracle 10g Release 2 ODACI changed the TNSNAMES.ora to this MyDatabase = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ServerName)(PORT = 1535)) ) (CONNECT_DATA = (SERVICE_NAME = MyDatabase ) ) )I then Rebooted the server and started to configure the Link Server using OraOLEDB.OracleI did this belowLinked Server - HSPProvider - Oracle Provider for OLE DBProduct Name - http://www.sqlservercentral.com/Forums/Topic855925-149-1.aspx OracleData Source - ServerName taken from the HOST in TNSNAMES.oraUnder Security I chose Be made using this security context and entered the username and passwordWhen clicked ok it created a Linked Server, but when I ran SELECT TOP 10 * FROM HSP ..SYS.HELP to test the link it returned this error.OLE DB provider "OraOLEDB.Oracle" for linked server "HSP" returned message "ORA-12541: TNS:no listener".Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "HSP".I have tried to google it and have had no joy in getting it to work. How can I get it working? Post #855925 DNA_DBADNA_DBA Posted Friday, January 29, 2010 7:44 AM SSCrazy Group: General Forum Members Last Login: Thursday, October 6, 2016 1:40 AM Points: 2,954, Visits: 2,675 No listener means that the Oracle server side could not be contacted from the client. Have you tested the connection via sqlplus or tnsping? Post #856087 J39L4753J39L4753 Posted Friday, January 29, 2010 7:49 AM SSC-Enthusiastic Group: General Forum Members Last Login: Friday, March 14, 2014 3:20 AM Points: 117, Visits: 382 DNA_DBA (1/29/2010)No listener means that the Oracle server side could not be contacted from the clie
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 http://www.ideaexcursion.com/2009/01/05/connecting-to-oracle-from-sql-server/ 4.7 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 linked server favorite 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 linked server oracle of 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,03941544 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 17.9k64067 2 Brabank, I already tried that, but it still shows the same error. –th1rdey3 Jan 24 '13 at 12:47 Did
revised guide for connecting with SSIS using newer components. Unfortunately, setting up a linked server to Oracle is not as easy as it should be. In fact, you"ll have to install some software on your server to make things work. I"ve put together a short guide on connecting to Oracle from SQL Server. The process doesn"t take very long but there are several hoops to jump through. Install Oracle Database 10g Client Release 2 Install using the InstantClient option Install Oracle 10g Release 2 ODAC (64-bit, 32-bit) Select the Oracle Data Access Components option (not .NET!) Edit TNSNAMES.ora