vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi I have SQL2005 linked server to Oracle9i, but it does not work, I get this error when I try to list Tables and Views from SSMS: The OLE DB provider "MSDASQL" for linked server "ORACLEODBC03" reported an error. Access denied. Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "MSDASQL" for linked server "ORACLEODBC03". (.Net SqlClient Data Provider) I can tnsping to the SID, and ODBC test works I ´ve changed MTxOCI reg entry to OracleXaLib=oraclient9.dll and the others I´m using Oracle ODBC (oralce on OraHome92) even, I reinstall SQL SP2 and changed "allowinprocess" parameter I´m using: SQL 2005 sp2 oracle 9.2.0.4.0 Any ideas? Regards |