Reading binary images from database using ASP.net 1.1

Question

User-237554299 posted

Hi

Currently i am working on .net framework 1.1 and i want to read and display the images on to browser. Images are stored in oracle database in binary format. While reading the table i am getting following error.

Oracle 11.2G

.net framework 1.1 (ASP.NET)

error: query with blob requires 0CI8 mode but 0CI7 mode is used

Following is the code which i am using. while reading the data it throwing above error message

//OleDbConnection con = new OleDbConnection("Provider=MSDAORA.1;User Id=japhonie;Password=japhonie;Data Source=IDEV2.world"); 

//                      con.Open(); 

//                      OleDbDataAdapter empadap; 

//                      empadap = new OleDbDataAdapter(); 

//                      empadap.SelectCommand = new OleDbCommand("SELECT id FROM ad_emp", con); 

//                      DataSet dset = new DataSet("dset"); 

//                      empadap.Fill(dset); 

//                      DataTable dtable;

please help

Answer 1

User753101303 posted

Hi,

Seems an outdated Oracle driver. From http://www.oracle.com/technetwork/articles/technote-php-instant-084410.html my understanding is that OCI7 (would be the "Oracle Instant CLient" to connect to Oracle 7 and some later editions but that OCI8 would be required to use this particular feature and to connect to Oracle 8 up to 11 g).

As it seems a quite Advanced Oracle driver installation topic, you'll likely have better support in an Oracle forum. More likely you need to update your drivers (maybe from http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)