I have an Oracle linked server in SQL Server 2000 which works fine for the most part until I try to access a table with a CLOB datatype. Then I get this error:

[OLE/DB provider returned message: Data type is not supported.]

And I can't access any data in that table whatsoever.

Does anyone know of a way around this so I can access the data in that table? Irritatingly, I used to link the the Oracle tables into Access and I used to have no problems at all. It would just convert the CLOB datatype to Memo. Its kinda annoying that I can't do the same with SQL Server.