Oraoledb.oracle Microsoft Sql Server Error 7399
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
Cannot Initialize The Data Source Object Of Ole Db Provider Oraoledb.oracle For Linked Server 7303
0 Sign in to vote Good day everyone.... I have installed the cannot get the column information from ole db provider "oraoledb.oracle" for linked server OraOLEDB.Oracle Provider on 3 different servers, and have made a link server on all three. On two of the ole db provider oraoledb.oracle for linked server returned message ora-12154 machines, I am 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
Microsoft Sql Server Error 7303 Linked Server Oracle
provider "OraOLEDB.Oracle" for linked server "employee_prod" reported an error. The 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
Allow Inprocess
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 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 73
360 games PC games cannot initialize the datasource object of ole db provider for linked server Windows games Windows phone games Entertainment All Entertainment
Cannot Initialize The Data Source Object Of Ole Db Provider "msdaora" For Linked Server
Movies & TV Music Business & Education Business Students & educators cannot create an instance of ole db provider oraoledb.oracle for linked server Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a1a8dcbc-027c-4794-b13a-8bd4d7d4d682/problems-with-oraoledboracle?forum=sqldataaccess Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/280106 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
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 http://stackoverflow.com/questions/14499977/cannot-create-an-instance-of-ole-db-provider-error-as-windows-authentication-u 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 http://www.dbaglobe.com/2009/09/how-to-adding-linked-server-for-oracle.html 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 linked server 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 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 ole db provider 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 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,05941544 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
for provider "OraOLEDB.Oracle" USE [master]GOEXEC master.dbo.sp_MSset_oledb_prop N'OraOLEDB.Oracle', N'AllowInProcess', 1GOStep 2: add one linked serverLinked server: Test (here is name of your linked server)Provider: Oracle Provider for OLE DBProduct name: OracleData source: Test (here is the tns name for Oracle database)Provider string: (empty)Security tab: Remote login: system With password: (system password for oracle)Step 3: VerifyPerform selection from remote Oracle databse:select * from [TEST]..[SYSTEM].[T]goupdate [TEST]..[SYSTEM].[T]set username='TEST' where sid=143;goselect * into test1from [TEST]..[SYSTEM].[T]goselect * from test1godelete from [TEST]..[SYSTEM].[T]goinsert into [TEST]..[SYSTEM].[T]select * from test1goselect * from [TEST]..[SYSTEM].[T]goCaution: If you hit following error message, please go to step 1The OLE DB provider "OraOLEDB.Oracle" for linked server "TEST" reported an error. The provider did not give any information about the error.Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "TEST". (Microsoft SQL Server, Error: 7399) Posted by Donghua Luo at 5:57 PM Labels: MsSQL, Oracle Newer Post Older Post Home Subscribe to: Post Comments (Atom) Labels AIX (1) Apache Cassandra (7) Apache Spark (5) C++ (1) Cassandra (1) Data Lake (1) DB2 (5) EMC (5) Enterprise Manager (2) GoldenGate (3) HPUX (2) Linux (52) Microsoft SQL Server (71) MongoDB (6) MsSQL (10) MySQL (28) Oracle (316) Python (5) Redhat (3) Solaris (18) VirtualBox (3) Windows (15) Blog Archive ► 2016 (26) ► October (9) ► July (2) ► June (5) ► May (2) ► March (5) ► February (3) ► 2015 (89) ► November (4) ► October (15) ► September (3) ► August (14) ► July (4) ► June (15) ► May (7) ► April (13) ► March (12) ► January (2) ► 2014 (105) ► December (14) ► November (7) ► October (5) ► September (8) ► August (8) ► July (21) ► June (23) ► May (1) ► April (1) ► February (15) ► January (2) ► 2013 (45) ► December (24) ► November (13) ► August (2) ► May (6) ► 2012 (11) ► December (1) ► August (2) ► May (5) ► April (1) ► January (2) ► 2011 (101) ► December (4)