Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kowani1
Starting Member
42 Posts |
 Posted - 2007-08-20 : 19:04:12
|
| Please help me here:I am using the Oracle OLEDB driver in my linked server to an Oracle 9i Db and am getting the error:" Error 7311: Could not obtain the schema rowset for OLE DB provider 'UNKNOWN'. The provider supports the interface, but returns a failure code when it is used.OLE DB error trace [OLE/DB Provider 'UNKNOWN' IDBSchemaRowset::GetRowset returned 0x80040e37:]"I have the 'AllowInProcess' and 'NestedQueries' enabled in the Provider options.Thanks.jungle dba |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-20 : 23:00:02
|
| Tried with odbc driver? |
 |
|
|
kowani1
Starting Member
42 Posts |
Posted - 2007-08-21 : 01:28:38
|
| It was a bug with the Oracle OLEDB driver provided by the Oracle client installation.Patch 4019247 from Oracle metalink resolved this issue.thanks.jungle dba |
|
|
|
|
|
|
OLE DB Linked Server Error 7311