Error 7399 Ole Db Provider Msdaora Reported An Error
New? Advanced Search Forum Database Discussions Oracle Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 8 of 8 Thread: Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 02-18-2007,05:01 PM #1 indyandumi View Profile View Forum Posts Registered User Join Date Jan 2007 Posts 36 Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error 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 'MSDAORA' reported an error. OLE DB error . ---my oracle 10g client is working just fine --TNS names looks fine ---i recreated the link but i am still getting the same error. I need your help because a lot of jobs are using that link on Monday it is going to be crazzzy. Reply With Quote 02-18-2007,07:11 PM #2 rmiao View Profile View Forum Posts Moderator Join Date Sep 2002 Posts 5,938 Reboot sql server if possible or try odbc provider for linked server. Reply With Quote 02-18-2007,07:43 PM #3 indyandumi View Profile View Forum Posts Registered User Join Date Jan 2007 Posts 36 rmaio, is to stop sql server the same as to reboot? What i did i stopt sql server and restarted, and then i used ODBC Connection but i keep getting the same error. ---I went to ODBC and setup oracle connection . Any new ideas Reply With Quote 02-18-2007,09:36 PM #4 rmiao View Profile View Forum Posts Moderator Join Date Sep 2002 Posts 5,938 Stopping sql is different from rebooting server since it can't recover os or n
up 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 http://forums.databasejournal.com/showthread.php?44887-Error-7399-OLE-DB-provider-MSDAORA-reported-an-error-OLE-DB-error 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 http://www.sqlservercentral.com/Forums/Topic486832-1043-1.aspx 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 erro
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 https://community.oracle.com/thread/3681678 back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions https://www.experts-exchange.com/questions/20493685/Error-7399-OLEDB-Provider-'MSDAORA'-reported-an-error.html in Oracle Provider for OLE DB All PlacesDatabaseDatabase Application DevelopmentWindows and .NETOracle Provider for OLE DB This discussion is archived 7 Replies Latest reply on Mar 5, error 7399 2015 4:11 AM by 2896541 Linked Server : OLE DB provider 'MSDAORA' reported an error 2896541 Mar 4, 2015 9:35 AM I have an issues with linked server to Oracle...at first the server running SQL Servre 2000 and Oracle8i, and the linked server works well...But after IT Department installs an Oracle 11g Client error 7399 ole on the server...When I execute my open query in SQL Server, I get an error message[OLE/DB provider returned message: Oracle error occurred, but error message could not be retrieved from Oracle.]OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ].Msg 7399, Level 16, State 1, Line 1OLE DB provider 'MSDAORA' reported an error. Hope you guys can help me out, thanks. 3227Views Tags: none (add) This content has been marked as final. Show 7 replies 1. Re: Linked Server : OLE DB provider 'MSDAORA' reported an error svenkatn-Oracle Mar 4, 2015 11:40 AM (in response to 2896541) Hi,What is the version of the database used for linked serer ? Is it Oracle 8i ? Please confirm.If database is 8i and Oracle Client is 11gr2, these versions are not compatible.After installing the Oracle Client 11g, have you registered the OLEDB driver.Restart the SQL Server, after installing the Oracle Client and then create the linked server.thanks and reg
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Error 7399: OLEDB Provider 'MSDAORA' reported an error Want to Advertise Here? Solved Error 7399: OLEDB Provider 'MSDAORA' reported an error Posted on 2003-02-02 MS SQL Server 2 Verified Solutions 10 Comments 7,349 Views Last Modified: 2012-08-14 I want to set up a linked server on SQL Server 2000 which is running on a Win2k Advance Server. The linked server I want to setup is required to link to an Oracle 7 database that is sitting on a WinNT4.0 server. Below is what I have done on the SQL Server server. 1. Installed the Oracle client version 7.3.4 2. Setup the linked server on SQL Server - I am using MS OLE DB Provider for Oracle as the Provider name. 3. Although setting up the linked server gives me no problem, clicking on either TABLEs or VIEWS in this linked server gives me the error above (in the title - Error 7399: ...). Is there something that I am missing out that will make my linked server to work? Your help will be appreciated. Rochus 0 Question by:rmission Facebook Twitter LinkedIn Google LVL 5 Best Solution byLazyStudent INFO: Limitations of Microsoft Oracle ODBC Driver and OLEDB Provider http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q244661 Go to Solution 10 Comments LVL 5 Overall: Level 5 MS SQL Server 1 Message Accepted Solution by:LazyStudent2003-02-02 INFO: Limitations of Microsoft Oracle ODBC Driver and OLEDB Provider http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q244661 0 Message Author Comment by:rmission2003-02-02 LazyStudent, What does the article that you provided the link give me, in terms of an answer to my question. By the way, is MDAC 2.1+ a requirement for my linked server to work? Thanks. 0 LVL 4 Overall: Level 4 MS SQL Server 4 Message Assisted Solution by:xxg48132003-02-02 Hi, This is my experience for installing link server for oracle, for your reference only. Mine is using Oracle 9i, i think it should be no problem with other versions; Also i am using Microsoft ODBC for Oracle: 1. tnsnames.ora Install Oracle 9i Client Modify the tnsnames.ora under c:\orant\network\admin MOON81.XXXX.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRES