Microsoft Sql Server Error 7303 Msdaora
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My sql server 2012 linked server oracle Forums Answered by: Problems with OraOLEDB.Oracle SQL Server > microsoft sql server error 7303 linked server oracle SQL Server Data Access Question 0 Sign in to vote Good day everyone.... I have sql server oracle linked server query syntax installed the OraOLEDB.Oracle Provider on 3 different servers, and have made a link server on all three. On two of the machines, I am cannot create an instance of ole db provider oraoledb.oracle for linked server successful in retrieving data from 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 provider did not give any information about the error.Server: Msg
Oracle Linked Server Equivalent
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 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 repli
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2008 » Working with Oracle » Source Object Failing to
Cannot Initialize The Data Source Object Of Ole Db Provider "oraoledb.oracle" For Linked Server
Initialize for... Source Object Failing to Initialize for MSDAORA Provider Rate Topic Display Mode sql server linked server oracle access denied Topic Options Author Message AnthonyFourieMSAnthonyFourieMS Posted Friday, July 6, 2012 5:10 AM SSC Rookie Group: General Forum Members Last Login: Monday, October sql server linked server oracle provider string 17, 2016 5:40 AM Points: 49, Visits: 422 Hi Guys,I'm at a loss with this one:Problem/Error:I have a job that executes a stored procedure in a databaseThis stored proc accesses an Oracle linked server and https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a1a8dcbc-027c-4794-b13a-8bd4d7d4d682/problems-with-oraoledboracle?forum=sqldataaccess just selects data from an Oracle TableThe problem is that this proc has been failing returning vague errors, that I unable with my experience to follow up on, I need a help with regards to how Linked Servers are working in the background, where I should be looking to get this sorted out, and any pointers on what to be aware of when setting up these linked servers.Background Info:This job ran successfully http://www.sqlservercentral.com/Forums/Topic1325990-1044-1.aspx time and time again and has just recently begun failingThe user account utilized by the linked server has more than sufficient privileges on the Oracle DatabaseThe SQL Server Version is: SQL Server 2005 Standard Edt. 9.00.4035.00The SQL Server Architecture: x86The Windows Version is: Windows Server 2003 R2 Enterprise Edt. SP2 Build 3790The Windows Architecture is: x86Installed CPU: AMD Opteron 275 2.21GHz Installed RAM: 4GBThe Oracle Version is: 10.2.0.4The Oracle OS Architecture: x64The Oracle Database is setup in a RAC configuration (I take it that's a form of clustering)Tests:I have checked that the tnsnames.ora file is correct (Entries are correct)I can TNSPING
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 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 6.2 million programmers, just like you, helping each other. Join them; it only takes a 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 linked server 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 linked server 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,05441544 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 18.1k64167 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 exper