We have web application in ASP.NET framework 1.1 which connects to oracle database 11.0.2. Application uses Microsoft OLEDB provider (MSDAORA.1) to connect to oracle and works fine.
Now we have new requirement to read image stored in BLOB data type of oracle table.
Please refer to sample code below.
While executing the reader, we get the error Data type is not supported.
OleDbConnection con = new OleDbConnection("Provider=MSDAORA.1;UserId=japhonie;Password=japhonie;Data Source=IDEV2.world");
con.Open();
OleDbCommand cmd= new OleDbCommand("SELECT id,photo FROM ad_emp", con);
OleDbDataReader dr = cmd.ExecuteReader();
Microsoft says this provider does not support BLOB type, and they have stopped support for MSDAORA provider.
We are now trying to use Oracle OLEDB provider (OraOLEDB.Oracle) for .net 1.x, “Oracle 11g ODAC and Oracle Developer Tools for Visual Studio 11.1.0.6.21”
We want to use the MSDAORA.1 provider for the existing functionality in the application and for new requirement of reading BLOB data we want to use Oracle OLEDB provider.
When we installed this new driver Oracle OLEDB with default setting on same machine, the existing functionality of application using MSDAORA.1 provider fails as it cannot connect to database.
Is it possible to use both the drivers in one machine and use these two providers in single application to achieve our requirement?
When we installed this Oracle OLEDB driver with different path and set the Oracle home path in environment variable we are able connect to oracle using oracle client, but the existing functionality in application stops working.
What is the way to install new driver and what configurations we need to do to achieve the connectivity using both drivers.
Regards, Thanks in advanve.