Error 7399 Oraoledb.oracle
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » Working with Oracle » Getting Error 7399 - OLE DB provider... Getting Error 7399 - OLE DB provider 'ORAOLEDB.ORACLE' reported an error. The provider did not give any information about the error. Rate Topic Display Mode Topic Options Author Message Marios PhilippopoulosMarios Philippopoulos Posted Thursday, April 17, 2008 4:04 PM SSCommitted Group: General Forum Members Last Login: Friday, October 7, 2016 12:29 PM Points: 1,869, Visits: 3,723 I'm getting the following error while using OPENROWSET:OLE DB provider 'ORAOLEDB.ORACLE' reported an error. The provider did not give any information about the error. [SQLSTATE 42000] (Error 7399) OLE DB error trace [OLE/DB Provider 'ORAOLEDB.ORACLE' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.]. [SQLSTATE 01000] (Error 7300). The step failed.The OPENROWSET call is done like this:SET @SQL = 'INSERT INTO #tbl (col1, col2, col3) SELECT [col1], [col2], [col3] FROM OPENROWSET(''ORAOLEDB.ORACLE'','''+@Server+'''; '''+@Login+'''; '''+@Password + ''','''+ @querysql + ''')EXEC (@sql)Anyone have any ideas what could be wrong and how to fix it?Thanks! __________________________________________________________________________________Persisting SQL Server Index-Usage Statistics with MERGETurbocharge Your Database Maintenance With Service Broker: Part 2Turbocharge Your Database Maintenance With Service Broker: Part 1Preparing for the Unthinkable - a Disaster/Recovery Implementation Post #486832 lucky-80472lucky-80472 Posted Thursday, April 17, 2008 4:18 PM Ten Centuries Group: General Forum Members Last Login: Thursday, January 28, 2016 12:54 PM Points: 1,295, Visits: 842 Marios Philippopoulos (4/17/2008)I'm getting the following error while using OPENROWSET:OLE DB provider 'ORAOLEDB.ORACLE' reported an error. The provider did not give any information about the error. [SQLSTATE 42000] (Error 7399) OLE DB error trace [OLE/DB Provider 'ORAOLEDB.ORACLE' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.]. [SQLSTATE 01000] (Error 7300). The step failed.The OPENROWSET call is done like this:SET @SQL = 'INSERT INTO #tbl (col1, col2, col3) SELECT [col1], [col2], [col3] FROM OPENROWSET(''ORAOLEDB.ORACLE'','''+@Server+'''; '''+@Login+'''; '''+@Password + ''','''+ @querysql + ''')EXEC (@sql)Anyone have a
Oracle 10g Oracle 11g MySQL MongoDB Vertica DB MS Access Netapp Linux Powershell Windows ← Where to look forErrors SQL Server 2005 DiagnosticsQueries → Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "LinkedServerName". July 9, 2009 2 Comments Today an incident was raised with me whereby a user wasnt able to remotely query an oracle database (10g) via a SQL Server instance. SELECT * FROM http://www.sqlservercentral.com/Forums/Topic486832-1043-1.aspx OPENQUERY(LinkedServerName, ‘select * from oracleschema.tablename') Interestingly, the query worked perfectly when running it directly on the Server which hosted the SQL Server Instance. The problem was when the query was run remotely on the client machine – which gave the error below: Msg 7302, Level 16, State 1, Line 1Cannot create an instance https://dbamohsin.wordpress.com/2009/07/09/cannot-create-an-instance-of-ole-db-provider-oraoledb-oracle-for-linked-server-linkedservername/ of OLE DB provider "OraOLEDB.Oracle" for linked server "LinkedServerName I did quite a lot of research on this and the issue can be resolved by editing the Provider Properties (right-click the provider in the providers folder) and ticking the "Allow inprocess" option corrects my problem.Existing linked servers will not pick up the provider setting, so new linked server objects will have to be created. But the new ones work. http://www.sqlservercentral.com/Forums/Topic491682-149-1.aspx Similar errors about linked servers on SQL Server linking to Oracle Msg 7399, Level 16, State 1, Line 1The OLE DB provider "OraOLEDB.Oracle" for linked server "LinkedServerName" reported an error. Access denied.Msg 7332, Level 16, State 2, Line 1Cannot rescan the result set from OLE DB provider "OraOLEDB.Oracle" for linked server "LinkedServerName". Unknown provider error. http://www.sqlservercentral.com/Forums/Topic482481-146-1.aspx
Rate this:Share:FacebookTwitterLinkedInRedditMorePrintEmailLike this:Like Loading... Related Filed under SQL Server 2005 2 Responses to Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "LinkedServerName". win says: Mayhere 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 http://stackoverflow.com/questions/14499977/cannot-create-an-instance-of-ole-db-provider-error-as-windows-authentication-u 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 4.7 million programmers, just like you, helping each other. Join them; it only takes a http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=155692 minute: Sign up “Cannot create an instance of OLE DB provider” error as Windows Authentication user up vote 12 down vote favorite 7 I am trying to run openrowset from MS SQL Server on an Oracle server. When i execute error 7399 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 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 error 7399 oraoledb.oracle 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 you recreate your linked server? –David Brabant Jan 24 '13 at 12:48 yes, I have even restarted the sql service before recreating the linked server. but still no luck. –th1rdey3 Jan 24 '13 at 12:56 2 Thanks for this answer, it saved my day. –binu Jul 30 '13 at 15:04 5 In my exp
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2008 Forums SQL Server Administration (2008) linked server problem Reply to Topic Printer Friendly Author Topic andyhallam Starting Member United Kingdom 9 Posts Posted-01/25/2011: 08:05:47 I am running 64bit windows vista with SQL SERVER 2008 SP1.11.2 Oracle on windows (all on the same machine)I am trying to set up a linked server to Oracle.Using OraOLEDB.Oracle as MSDAORA is not shown in the SQL SERVER Providers list???Am doing -exec sp_addlinkedserver @server='andyh', @srvproduct='Oracle', @provider='OraOLEDB.Oracle', @datasrc='MYORACLE'exec sp_addlinkedsrvlogin @rmtsrvname='andyh', @useself='false', @locallogin='sa', @rmtuser='myuser', @rmtpassword='xxxx'tnsping MYORACLE works fine.- I execute the belowselect * from andyh..SCOTT.EMP- I get OLE DB provider "OraOLEDB.Oracle" for linked server "andyh" returned message "ORA-01017: invalid username/password; logon denied".The @rmtuser and @rmtpassword are correct - I can connect via sqlplus using these values no problem.Help RickD Slow But Sure Yak Herding Master United Kingdom 3608 Posts Posted-01/25/2011: 08:31:15 You need to install the 32 bit Oracle client as well as far as I can remember. This is due to support issues, will try to find a kb article for you..Can't find one straight up, but read this:http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/8cea4b0f-28b4-4224-809c-6935a624205a/ Edited by - RickD on 01/25/2011 08:33:54 andyhallam Starting Member United Kingdom 9 Posts Posted-01/25/2011: 09:37:59 I have got both the 11.2 32bit & 64bit clients installed.I have also installed 11.2 ODAC.The thing that puzzles me is the "invalid username/password" - or is this just a red herring?The full error message I get is:OLE DB provider "OraOLEDB.Oracle" for linked server "andyh" returned message "ORA-01017: invalid username/password; logon denied".Msg 7303, Level