Ole Db Error Trace Ole Db Provider Msdaora
Contents |
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » Notification Services » Administration » Linked Server problem ! Linked Server problem ! Rate Topic Display Mode sql server linked server oracle provider for ole db Topic Options Author Message Olivier TACKELSOlivier TACKELS Posted Monday, September 26, 2005 4:06 AM Forum Newbie microsoft sql server error 7303 linked server oracle Group: General Forum Members Last Login: Thursday, June 15, 2006 3:18 AM Points: 1, Visits: 1 I try to link a Oracle Server
Sql Server Oracle Linked Server Query Syntax
with a SQL Server but this message always appears : "Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]."So, I installed Oracle client 7.3.3.5.0 on my SQL
Cannot Create An Instance Of Ole Db Provider Oraoledb.oracle For Linked Server
Server. This server is a Windows 2000 Server SP4. When I use a "SQL Plus 3.3", little Oracle tool to query building I can connect my Oracle Server.But, when I want to create a "Linked Server", after that I clicked on "Tables" I receive message that you had read more high.I inputed this paramaters :"Product name : Oracle7""Data Source : MyDBOracle" (Oracle DB Name)"Provider String : MSDAORA"Can you help me ?Olivier Post #223480 dbuchandbuchan Posted Tuesday, oracle linked server equivalent September 27, 2005 12:19 AM SSC-Enthusiastic Group: General Forum Members Last Login: Monday, September 28, 2009 5:41 PM Points: 182, Visits: 61 What version is the Oracle database ? Can you make an ODBC connection on the SQL server ? (To the Oracle Database)You have also set the login/password in the Linked server for the Oracle connection ?I'd still be going for a later client....DB The systems fine with no users loggged in. Can we keep it that way ?br> Post #223790 Steve MedvidSteve Medvid Posted Tuesday, September 27, 2005 6:41 AM Forum Newbie Group: General Forum Members Last Login: Wednesday, February 19, 2014 1:27 PM Points: 3, Visits: 82 Also check your MDAC Version on the SQL Server machine. We had out brilliant IT Team push out new security patches that include MDAC Changes. Well - All linked servers went down - for Oracle. I don't know the exact changes they made to fix the issue, but they had Microsoft on the telephone and made some registry changes. htwh, Post #223862 Ian YatesIan Yates Posted Tuesday, September 27, 2005 9:36 AM Ten Centuries Group: General Forum Members Last Login: Wednesday, January 14, 2015 8:59 PM Points: 1,038, Visits: 445 I had awful trouble once trying to just understand the myriad of things to do with Oracle - client had an app with it that we had
360 games PC games
Sql Server Linked Server Oracle Provider String
Windows games Windows phone games Entertainment All Entertainment cannot initialize the data source object of ole db provider "oraoledb.oracle" for linked server Movies & TV Music Business & Education Business Students & educators sql server linked server oracle access denied Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://www.sqlservercentral.com/Forums/Topic223480-92-1.aspx 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
first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum http://www.dbforums.com/showthread.php?983352-ODBC-Oracle-Linked-Server-Problem that you want to visit from the selection below. Results 1 to 4 of 4 Thread: ODBC / Oracle Linked Server Problem Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 02-15-04,14:13 #1 seagull View Profile View Forum Posts Registered User Join Date Feb 2004 Posts 2 Unanswered: ODBC / Oracle Linked Server Problem I have linked server a SQL server that I am trying to link to a number of Oracle environments. After much tuning, we managed to achieve this although the four-part naming was not possible and we had to use Openquery and run pass throughs. Nothing in our configuration has changed and SQL Server is no longer able connect to the linked databases. The Oracle client on the PC is fine and is able tnsping any of the remote linked server oracle databases. I am also able to create ODBC connections to the remote databases on the SQL box that are fine. Using a datalink in DTS, I can connect to the remote databases. This suggests to me that there is something wrong within the actual database links. I have set them up using the working ODBC DSN's on the SQL box. If I try and run a query against them in Query Analyser, I get the following error message : Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'MSDAORA' reported an error. [OLE/DB provider returned message: ORA-12154: TNS:could not resolve service name ] OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]. If I click on the tables icon in EM to view the remote catalogues I get the following error : Error 7399: OLE DB provider 'MSDORA' reported an error. OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]. Any help that could be give on this would be greatly appreciated. Reply With Quote 02-17-04,15:22 #2 hmscott View Profile View Forum Posts Registered User Join Date Dec 2002 Posts 1,245 Can you post the script(s) that you used to create the linked servers on your SQL Server? Also, I think it would be helpful if you could post the content of the