Summary of problems with using oledb to connect to Oracle

Summary 1:

Problem: Use the followingCodeWhen filling in dataset,

Dataset DS = new dataset ();
Try
{
 
Oledbdataadapter command = new oledbdataadapter (sqlstring, connect );
Command. Fill (DS, "ds ");
}
Catch (system. Data. oledb. oledbexception ex)
{
// Throw new exception (ex. Message );
}
Return Ds;

An Oracle error occurred, but the error information cannot be retrieved from Oracle. The data type is not supported.

Explanation:

If you want to read BLOB fields in the Oracle database, you cannot use it. net built-in system. data. for oledb class libraries, you must use oracleclient (a class library dedicated for operating and managing Oracle databases, similar to the sqlclient class library) (oracleconnection, oraclecommand, oracledataadapter ,. net does not contain oracleclient. You need to add system. data. oracleclient. DLL reference can be used, this file can be downloaded on msdn.

Question 2:

After installing. NET Framework 2.0, no oracle provider for ole db is found in oledb Configuration Manager.

Can download: http://www.microsoft.com/downloads/details.aspx? Familyid = 4f55d429-17dc-45ea-bfb3-076d1c052524 & displaylang = ZH-CN

Then install.

Alternatively, install. NET Framework 2.0 SP1 with v2.0.50727.

SP1 already contains