NEED HELP ---- OLE DB provider - for linked server. The provider supports the interface, but returns a failure code when it is used.

Hi Guys

Can someone help me please?  

I upgraded sql server 2000 to sql server 2005.  

Connecting sql server to oracle 8i worked fine in 2000 but not in 2005.  

This is the error I receive now:  

"OLE DB provider "OraOLEDB.Oracle" for linked server "ORADB" returned
message "Table does not exist.".

OLE DB provider "OraOLEDB.Oracle" for linked server "ORADB" returned message "Table does not exist.".

OLE DB provider "OraOLEDB.Oracle" for linked server "ORADB" returned message "Table does not exist.".

Msg 7311, Level 16, State 2, Line 1

Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider
"OraOLEDB.Oracle" for linked server "ORADB". The provider supports the
interface, but returns a failure code when it is used."

This is the code I am executing:

"Select

Z31_REC_KEY, Z31_DATE, Z31_STATUS, Z31_SUB_LIBRARY, Z31_TYPE, Z31_CREDIT_DEBIT, Z31_SUM, Z31_PAYMENT_DATE_KEY, Z31_PAYMENT_RECEIPT_NUMBER from

ORADB..LUS51.Z31 where

Z31_REC_KEY not in

(Select Z31C_REC_KEY from ALEPH.dbo.Z31C)

"

Does anybody knows how can I fix this?

Thanks

Paulo Gomes

--
http://www.freelists.org/webpage/oracle-l