Russian Sleep Experiment: the best short story I've read. 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. You cannot vote within polls. Thanks man Reply With Quote 02-28-2007,08:53 AM #7 skhanal View Profile View Forum Posts Experts Join Date Nov 2002 Location New Jersey, USA Posts 3,896 Use the Microsoft driver for Oracle, check these guys out
Linked Servers: Performing Select, Insert, Update and Delete (CRUD) actions « Rip's Domain said, on December 14, 2007 at 6:11 pm […] my last post, I spend 4 hours trying Reply Greg Wlodarczyk says: November 11, 2013 at 7:54 am Our nightly refresh would intermittently fail causing the server to hang. Component services ->My Computer --> Properties verify that below options are set:In the ‘Default Properties' tab: - ‘Enable Distributed COM on this computer' is checked. says: January 14, 2011 at 4:45 am Most valuable.
Installing Oracle7 Client on the SQL Server machine 2. Have I missed something? Reply AWEInCA says: June 1, 2015 at 5:30 pm Regarding this paragraph: "MSDAINITILIAZE is initiated by users connected to SQL Server. Sql Server 2012 Linked Server Oracle Reply Mihir Patel says: June 15, 2016 at 5:06 pm I get the same error even after applying all changes as indicated.
All other tabs (rather fields in them) are disabled. Microsoft Sql Server Error 7399 Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! All test connection works successfully but upon trying to query i get the following error. https://blogs.msdn.microsoft.com/dataaccesstechnologies/2010/08/19/permissions-needed-to-set-up-linked-server-with-out-of-process-provider/ Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum!
Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. http://www.sqlservercentral.com/Forums/Topic293558-5-1.aspx I can launch pl/sql and connect to the db with the same username as I use in the linked server. Sql Server Error 7399 Invalid Authorization Specification Reply [email protected] says: October 9, 2013 at 10:56 pm Thanks, It works. Sql Server Error 7399 Linked Server Join the community of 500,000 technology professionals and ask your questions.
Thanks again. 0 Message Author Comment by:rmission2003-02-05 To Experts-exchange cordinators, How can I share the points among 2 people? 0 Message Expert Comment by:CleanupPing2003-09-03 rmission: This old question needs Sorted my issue morten said, on September 10, 2009 at 10:05 am hi I got the 7312 error while trying to query a linked server to Oracle. Is it Oracle 8i ? check over here Re: Linked Server : OLE DB provider 'MSDAORA' reported an error svenkatn-Oracle Mar 5, 2015 2:47 AM (in response to 2896541) Hi,You have two options for creating a linked server when
Close Box Join Tek-Tips Today! Sql Server Oracle Linked Server Query Syntax You can make use of Oracle Provider for OLEDB - In this case choose the provider as "Oracle Provider for OLEDB" or2. Msg 7399, Level 16, State 1, Line 2 The OLE DB provider "mrOleDB.Provider.2" for linked server "(null)" reported an error.
Report Abuse. You cannot edit other posts. Re: Linked Server : OLE DB provider 'MSDAORA' reported an error 2896541 Mar 4, 2015 4:24 PM (in response to svenkatn-Oracle) HiWhat is the version of the database used for linked Sql Server Linked Server Oracle Provider String Under Change owner to select the local Administrators group and click on Apply/OK and then click Ok again.3.
Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. You cannot edit your own posts. My home PC has been infected by a virus! this content I found some articles about but I'm not sure about the solution for this problem.