Oracle CLOBs via ODBC?


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
 
Ad

Advertisements

A

Arsalan

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

Advertisements

P

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top