I have linked an oracle 10g db to SQL server 2000 using microsoft OLE DB driver. I want to make a view in the SQL server which will return data from the linked oracle db.
It works fine except when I'm trying to acess the BLOB type of field. Then I receive an error:
Server: Msg 7354, Level 16, State 1, Procedure Document, Line 12
OLE DB provider 'MSDAORA' supplied invalid metadata for column 'DATA'. The data type is not supported.
Any ideas how to workaround this problem. The blob's fields contain images and I suppose I can convert them to image type...
Very important is that I do not need the data into the sql server. It should be into the oracle DB !!! I just need the view which will select from there.