Error 7399 Msdaora Oledb
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: getting sql server 2012 linked server oracle Error 7399: OLE DB provider 'MSDAORA' reported an error -
Microsoft Sql Server Error 7303 Linked Server
Linked Server SQL Server > SQL Server Security Question 0 Sign in to vote Hi All, sql server oracle linked server query syntax I'm working with SQL Server 2000 SP4 running on Microsoft Windows Server 2003 Standard Edition SP2. Using linked servers, I'm trying to connect with one cannot create an instance of ole db provider oraoledb.oracle for linked server Oracle 10g R2 using ODBC. I created one connection using Oracle driver and when I try to connect using test connection button all is ok. But when try to use this data source on linked server, I get the follow error: Error 7399: OLE DB provider 'MSDAORA' reported an error.
Sql Server Linked Server Oracle Provider String
OLE DB error trace[OLE/DB Provider 'MSDAORA'IDBInitialize::Initializa returned 0x80004005: ]. I found some articles about but I'm not sure about the solution for this problem. Please, any idea to fix this problem? And if you need more information, please ask me. Thank you, Sergio Sergio Thursday, March 24, 2011 6:21 PM Reply | Quote Answers 0 Sign in to vote Hi Sergio, Thank you for your post. Please refer the below link with the detailed information about Error 7399: http://support.microsoft.com/kb/314530 Thanks, Weilin QiaoPlease remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread. Marked as answer by WeiLin QiaoModerator Monday, April 04, 2011 1:58 AM Tuesday, March 29, 2011 11:16 AM Reply | Quote Moderator All replies 0 Sign in to vote please check this MSDN blog http://support.microsoft.com/kb/280106 Thursday, March
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 oracle linked server equivalent » Administration » Linked Server MSDAORA error Linked Server MSDAORA error Rate sp_addlinkedserver oracle Topic Display Mode Topic Options Author Message Shelley AllenShelley Allen Posted Tuesday, July 11, 2006 10:30 AM SSC Journeyman
Oracle Linked Database
Group: General Forum Members Last Login: Monday, August 29, 2016 3:55 PM Points: 97, Visits: 106 I have created a Linked Server on a Windows 2003 server with MSSQL2000 server running. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/eb3e5d08-45e9-445d-920a-8281b6544024/getting-error-7399-ole-db-provider-msdaora-reported-an-error-linked-server?forum=sqlsecurity I installed the oracle client tools (oracle 9.1) and made the following registry updates.HKEY_LOCAL_MACHINE\software\microsoft\msdtc\mtxocioracleOcLIB (data) oci.dllOracleSqlLib (data) orasql9.dllOracleXaLib (data) oraclient9.dllThe TNSORA_Name is correct in the system environment variables. I can launch pl/sql and connect to the db with the same username as I use in the linked server. I have the exact server set up on a replica server that I use http://www.sqlservercentral.com/Forums/Topic293558-5-1.aspx for TEST and it works correctly. The problem I have is in PROD. But, I have had it working fine for about 2 years. Then about a month or two ago, for whatever reason, the linked server quits and I receive the below error:Error 7399: OLEDB providor 'MSDAORA' reported an error: OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBinitialize::initalize returned 0x80004005:]The set up I used when creating the linked server (and worked for 2 years and on TEST are below)Product Name: Microsoft OLEDB Provider for OracleProduct Name: OracleData Source: PROD Provider string: MSDAORAIn the security tab I have the last option and hard code the username and pwd.Has any experienced this problem. I just don't understand how it can work for 2 years and just not one day. Have I missed something? Any help is greatly appreciated. Post #293558 Joshua M PerryJoshua M Perry Posted Wednesday, July 12, 2006 7:51 AM SSC-Addicted Group: General Forum Members Last Login: Tuesday, September 13, 2016 3:09 PM Points: 460, Visits: 540 0x80004005 is access denied. This is definitely a permissions problem. Verify that the username and p
the last 4 hours of my day trying to get something as simple as a linked server in MSSQL 2000 to work. What I was doing was setting up a linked server between MSSQL 2000 and Oracle 9i https://rip747.wordpress.com/2007/12/14/sql-server-2000-linked-oracle-server-errors/ and ran into a lot of problem. Below is ranting and how I finally solved my http://forums.asp.net/t/982074.aspx?Error+7399+OLEDB+provider+MSDAORA+reported+an+error problem. The one thing I can't stand about setting up a linked server in MSSQL with Oracle is that it's never the same. Sometime you can get away with using the "Microsoft OLE DB Provider for Oracle", other times you need to use the "Microsoft OLE DB Provider for ODBC Drivers" and still sometimes you need to use the "Oracle Provider for OLE linked server DB". In summary you have 3 different providers to choose from depending on nothing but the toss of a hat. Just to prove my point, I already have a linked server setup on another MSSQL 2000 server using the "Microsoft OLE DB Provider for Oracle" provider. On the server I'm setting up, I following the EXACT same configuration and used the same provider and it wouldn't connect. I'm getting Error 7312 and Error 7399 every time I try to linked server oracle connect and view the tables. {Error 7399: OLE DB provider ‘MSDAORA' reported an error. OLEDB error trace [OLE/DB Provider ‘MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]} {Server: Msg 7321, Level 16, State 2, Line 1 An error occurred while preparing a query for execution against OLE DB provider ‘OraOLEDB.Oracle'. [OLE/DB provider returned message: ORA-00942: table or view does not exist]
OLE DB error trace [OLE/DB Provider ‘OraOLEDB.Oracle' ICommandPrepare::Prepare returned 0x80040e14]. } After playing around for 4 hours, I finally found the right combination to connect and run my queries. Here is what I tried. I will say this, that there is no definitive solution for this. You are going to have to try each suggestion and see which one works for you. I should note that I do all of this inside of Enterprise Manager. First off, pick one of the following providers and create your linked server: Microsoft OLE DB Provider for Oracle Microsoft OLE DB Provider for ODBC Drivers Oracle Provider for OLE DB Now once you have your linked server created, expand the link server and clicked on TABLES to see if you get a list of the tables or if you get the 7399 error. If you get the error, try a different provider until you get the list of tables. When you finally get the listing of tables, remember the value in the "schema" column for that table, it might come int
ASP.NET Community Standup Forums Help Home/ASP.NET Forums/Data Access/Oracle, MySQL, Sybase, Informix and other databases/Error 7399: OLEDB provider 'MSDAORA' reported an error Error 7399: OLEDB provider 'MSDAORA' reported an error RSS 1 reply Last post May 30, 2006 04:54 PM by Texrat ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply ilove.net2 None 0 Points 1 Post Error 7399: OLEDB provider 'MSDAORA' reported an error Apr 14, 2006 09:26 AM|ilove.net2|LINK Hi - I created the Linked Server in SQL 2000 to connect to Oracle 8i. I could create the linked server without any problem. However getting this following error "Error 7399: OLEDB provider 'MSDAORA' reported an error. OLEDB error trace [oledb provider MSDAORA IDBInitialize:: Initialize returned 0x80004005: ] * Is it a Oracle Priviledges issue on my user ? (i could query those tables on the Oracle SQL Plus) or * Is the SQL Server not properly configured for the Linked Server....? I really appreciate your suggestion. Thanks a lot Love .Net2 Reply Texrat None 0 Points 40 Posts Re: Error 7399: OLEDB provider 'MSDAORA' reported an error May 30, 2006 04:54 PM|Texrat|LINK I'm getting the exact same thing, but only on one of the 2 SQL Servers (2000) involved. As far asI can tell they're both configured essentially the same, too... but only one can effectively link to the Oracle databases. The other produces the same error you see if I try to retrieve a list of tables from the linked database. Query tests using Oracle's SQL Plus work perfectly on the Server with the error. Sure wish someone could provide an answer... ‹ Previous Thread|Next Thread › This site is managed for Microsoft by Neudesic, LLC. | © 2016 Microsoft. All rights reserved. Privacy Statement| Terms of Use| Contact Us| Advertise With Us| CMS by Umbraco| Hosted on Microsoft Azure Feedback on ASP.NET| File Bugs| Support Lifecycle