Advice on ORaacle Data Provider.

[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.

 

[Frans Bouma [C# MVP]]

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.

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.