Error 7399 Oracle
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Problems with OraOLEDB.Oracle SQL Server > SQL Server Data Access Question 0 Sign in to vote cannot initialize the data source object of ole db provider oraoledb.oracle for linked server 7303 Good day everyone.... I have installed the OraOLEDB.Oracle Provider on 3 different servers,
Ole Db Provider Oraoledb.oracle For Linked Server Returned Message Ora-12154
and have made a link server on all three. On two of the machines, I am successful in retrieving data from cannot get the column information from ole db provider "oraoledb.oracle" for linked server the Oracle database. But, on the third machine, I receive this error: Server: Msg 7399, Level 16, State 1, Line 1The OLE DB provider "OraOLEDB.Oracle" for linked server "employee_prod" reported an error. The
Microsoft Sql Server Error 7303 Linked Server Oracle
provider did not give any information about the error.Server: Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "tims2_prod". On the machine which is generating the error, I can use SQL*Plus to connect to the remote database. I can also connect to the database using the "ODBC Data Source Administrator" when I create a system allow inprocess DSN. It would appear that the driver is installed and working correctly, but SQL Server can not access it. I have also uninstalled/installed serveral times. All of our servers are running W2003 Standard X64 with SQL Server 2005 Standard 64-bit Edition. Does anyone have any suggestions? Wednesday, June 07, 2006 12:34 PM Reply | Quote Answers 12 Sign in to vote Found the solution.... "Allow inprocess" has to be checked in the provider options. Wednesday, June 07, 2006 12:58 PM Reply | Quote All replies 12 Sign in to vote Found the solution.... "Allow inprocess" has to be checked in the provider options. Wednesday, June 07, 2006 12:58 PM Reply | Quote 0 Sign in to vote hi can you please send me the steps on how to stepup a connection to Oracle Database throught SQL Database. I have created a linked server, but i keep getting an error message OLE DB provider "OraOLEDB.Oracle" for linked server "DBCONN" returned message "ORA-12154: TNS:could not resolve the connect identifier specified". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "DBCONN". My tns string is Prooracle and the da
New? Advanced Search Forum Database Discussions Oracle Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error If this is
Error 7399 Linked Server Sql Server
your first visit, be sure to check out the FAQ by clicking
Cannot Obtain The Required Interface ( Iid_idbschemarowset ) From Ole Db Provider
the link above. You may have to register before you can post: click the register link above to proceed. cannot initialize the datasource object of ole db provider for linked server 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 https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a1a8dcbc-027c-4794-b13a-8bd4d7d4d682/problems-with-oraoledboracle?forum=sqldataaccess 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 http://forums.databasejournal.com/showthread.php?44887-Error-7399-OLE-DB-provider-MSDAORA-reported-an-error-OLE-DB-error 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 Po
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 https://rip747.wordpress.com/2007/12/14/sql-server-2000-linked-oracle-server-errors/ setting 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 http://stackoverflow.com/questions/6370601/run-a-query-from-linked-server-oracle-in-sql-server2008-r2 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 linked server to use 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 ole db provider 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 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 linke
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 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 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Run a Query from Linked Server (Oracle) in SQL Server2008 R2 up vote 3 down vote favorite 1 I have the linked server set up in SQL Server 2008. But I could not run any query against the linked server. I tried to run this simple command but it's not working SELECT * FROM MYSERVER..ALANH.TEMP_UPDATE1 This is the error I got when I run the above command. Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "OraOLEDB.Oracle" for linked server "MYSERVER" reported an error. The provider did not give any information about the error. Msg 7312, Level 16, State 1, Line 1 Invalid use of schema or catalog for OLE DB provider "OraOLEDB.Oracle" for linked server "MYSERVER". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema. Could anyone help me to connect to the OracleLinkedServer? Thanks very much. oracle sql-server-2008 linked-server share|improve this question edited Feb 15 '13 at 1:35 bobs 16.3k93957 asked Jun 16 '11 at 10:48 TTCG 1,927174467 similar to this question –Richard Aug 23 '11 at 16:36 add a comment| 6 Answers 6 active oldest votes up vote 4 down vote you can be that way too: **SELECT * FROM OPENQUERY(MYSERVER, 'SELECT * FROM ALANH.TEMP_UPDATE1')** share|improve this answer edited Sep 5 '14 at 14:43 answered Oct 24 '13 at 16:02 fasr 514 add a comment| Did you find this question interesting? Try our newsletter Sign up for our