Error 7399 Oracle Linked Server
Contents |
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home
Sql Server Error 7399 Linked Server
» SQL Server 2005 » Working with Oracle » Linked Server with msg 7399 linked server Oracle Database 12 posts,Page 1 of 212»» Linked Server with Oracle Database Rate Topic Display Mode Topic Options Author
Error 7303 Oracle Linked Server
Message pbyrumpbyrum Posted Tuesday, January 13, 2009 1:32 PM SSC-Enthusiastic Group: General Forum Members Last Login: Thursday, October 29, 2015 12:41 PM Points: 113, Visits: 227 I have a 64-bit oracle linked server equivalent SQL Server 2005 on Windows 2003 Server Standard Edition server. I have the Oracle 11g client installed, the 64 bit version. I also have an ODBC connection to the Oracle DB and that works. I have a Data Link (UDL) to access the Oracle table and that works. I also have the correct user name and password. The TNSNames.ora is oracle linked server query good. The linked server is created successfully, and I can see where you can select Tables and Views in the Catalogs. So, everything looks good. However, when I select to view the tables, I get the following error: The OLE DB Provider "OraOLEDB.Oracle" for linked server "PBLA" reported an error. Access denied. Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "OraOLEDB.Oracle" for linked server "PBLA". (MS SQL Server Error 7399)Any suggestions?Thank you! Post #635800 PaulB-TheOneAndOnlyPaulB-TheOneAndOnly Posted Saturday, January 17, 2009 7:42 AM Hall of Fame Group: General Forum Members Last Login: Tuesday, January 28, 2014 8:15 AM Points: 3,065, Visits: 4,639 Some people has fixed the issue by unchecking the "Allow inprocess" optionOn SQL Server Management Studio Server Objects --> Linked Servers --> Providers --> MSDAORA, right click select propertiesIt wouldn't hurt to try. _____________________________________Pablo (Paul) BerzukovAuthor of Understanding Database Administration available at Amazon and other bookstores.Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-prod
or Login Having an account grants you additional privileges, such as creating and participating in discussions. Cannot obtain the required interface ("IID_IBSchemaRowset") http://www.mssqlforum.com/threads/cannot-obtain-the-required-interface-iid_ibschemarowset.2067/ Discussion in 'Business Intelligence' started by Peter Schmitz, Feb 11, 2014. Peter Schmitz Administrator Staff Member I've been attempting to connect my SQL Development box at work to Oracle lately, and it's been a real struggle. I'll see if I can document the process a bit, in case someone else ends up running into issues (Why is it so difficult to set up linked server a connection to Oracle to begin with?). Today, after the so-manieth Oracle client install, and tweaking some settings the Linked Server I originally created (using MSDASQL) suddenly ceased to work with the following error message: Code (text): Cannot obtain the required interface("IID_IDBSchemaRowset") from OLE DB Provider "OraOLEDB.Oracle" for linked server "