Oracle CLOBs via ODBC?

  • Thread starter Thread starter Kev
  • Start date Start date
K

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
 
¤ 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)
 
Back
Top