Discussion Locked

Oracle BLOB with ADO

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi All,
I have installed Oracle 8i server on one system and client on another system.
Now I creates two table as follows on server.

->Create table first (id number(2),data LONG RAW);
->Create table second (id number(2),data BLOB);

Now I am using MS Visual C++ and ADO to retrieve the values from those two tables from client with DSN.

Values from First table can be retrieved by "Select * from First". All OK.

But the problems in Second table. Even the open method for recordset fails. If I do not select the BLOB field then All works OK. But BLOB column can not be selected.

To solve my problem , send some suggestions.

1 reply

by ed woychowsky

Had a simular problem, in my case the BLOB was bigger than 32K causing ADO .Net to choke. The work-around was to use ODP .Net as a provider, it allows for BLOBs of 2G. It is available as a download from Oracle.

This discussion is closed to new replies.