Error 7399 Sql Server Msdaora
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: getting Error 7399: OLE DB provider 'MSDAORA' reported
Sql Server Error 7399 Invalid Authorization Specification
an error - Linked Server SQL Server > SQL Server Security Question microsoft sql server error 7399 0 Sign in to vote Hi All, I'm working with SQL Server 2000 SP4 running on Microsoft
Sql Server Error 7399 Linked Server
Windows Server 2003 Standard Edition SP2. Using linked servers, I'm trying to connect with one Oracle 10g R2 using ODBC. I created one connection using Oracle driver and when I microsoft sql server error 7303 linked server 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. 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 sql server 2012 linked server oracle 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 24, 2011 8:20 PM Reply | Quote 0 Sign in to vote Hi, Thanks. I tried this solution but still with the same problem. Sergio Thursday, March 24, 2011 9:22 PM Reply | Quote 0 Sign in to vote Hi Serg
New? Advanced Search Forum Database Discussions Oracle Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error If this is your first
Cannot Create An Instance Of Ole Db Provider Oraoledb.oracle For Linked Server Error 7302
visit, be sure to check out the FAQ by clicking the link above. sql server oracle linked server query syntax You may have to register before you can post: click the register link above to proceed. To start viewing
Sql Server Linked Server Oracle Provider String
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 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 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. http://forums.databasejournal.com/showthread.php?44887-Error-7399-OLE-DB-provider-MSDAORA-reported-an-error-OLE-DB-error 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
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 https://rip747.wordpress.com/2007/12/14/sql-server-2000-linked-oracle-server-errors/ up a linked server between MSSQL 2000 and Oracle 9i and ran into a lot of problem. Below is ranting and how I finally solved my 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 sql server the "Microsoft OLE DB Provider for ODBC Drivers" and still sometimes you need to use the "Oracle Provider for OLE 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 sql server error 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 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 lin