Oracle CLOBs via ODBC?

[Kev]

Hi all,

We've got an application which accesses an oracle database, but uses the
ODBC .NET drivers, not the Oracle specific drivers. It works fine, but
now we want to access a CLOB in the database. Any select is currently
breaking on it. So is there a way to access the CLOB column through the
ODBC drivers or do I have to switch to the Oracle drivers for that?

Thanks in advance,
Kev

 

[Arsalan]

Use Oracle Specific Driver, its optimized for Oracle, rather than using ODBC
controls

 

[Paul Clement]

¤ Hi all,
¤
¤ We've got an application which accesses an oracle database, but uses the
¤ ODBC .NET drivers, not the Oracle specific drivers. It works fine, but
¤ now we want to access a CLOB in the database. Any select is currently
¤ breaking on it. So is there a way to access the CLOB column through the
¤ ODBC drivers or do I have to switch to the Oracle drivers for that?

The Microsoft ODBC and OLEDB drivers for Oracle do not support CLOB. You have to use the Oracle
drivers.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)