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)
<div>
error: query with blob requires 0CI8 mode but 0CI7 mode is used
</div>
Following is the code which i am using. while reading the data it throwing above error message
<div>
//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);
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).
None
0 Points
1 Post
Reading binary images from database using ASP.net 1.1
Nov 06, 2015 03:39 AM|Mangesh1|LINK
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)
<div>error: query with blob requires 0CI8 mode but 0CI7 mode is used
</div>Following is the code which i am using. while reading the data it throwing above error message
<div>//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;
</div>please help
All-Star
48720 Points
18186 Posts
Re: Reading binary images from database using ASP.net 1.1
Nov 06, 2015 04:58 AM|PatriceSc|LINK
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)