Advice on ORaacle Data Provider.

  • Thread starter Thread starter Ricky A.
  • Start date Start date
R

Ricky A.

What would be the best provider to support the Lobs's (clob in particular)
data type. I'm aware that the OLEDB provider doesn't support the data type.
My choices then are ODP.net provided by Oracle and the Oracle Client
provider by Microsoft. Using a Data Access Layer that uses both an OLEDB and
SQL Client providers. Please advise on the better choice for Oracle 9i
support.


Thanks you.
 
Ricky said:
What would be the best provider to support the Lobs's (clob in particular)
data type. I'm aware that the OLEDB provider doesn't support the data type.
My choices then are ODP.net provided by Oracle and the Oracle Client
provider by Microsoft. Using a Data Access Layer that uses both an OLEDB and
SQL Client providers. Please advise on the better choice for Oracle 9i
support.
Click to expand...

If you want specific types for CLOB and BLOB types so you can fetch then per
block, you should go for ODP.NET, as ODP.NET has more functionality for that.

Frans.
 
Back
Top