Oracle BLOB with ADO - TechRepublic
General discussion
April 12, 2005 at 11:11 PM
divyesh

Oracle BLOB with ADO

by divyesh . Updated 21 years, 1 month ago

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.

This discussion is locked

All Comments