Re: Oracle BLOB and ODBC connection



"Patrick Boyd" <PatrickBoyd@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:96884DBC-54F3-4011-B248-73EFEE4B4BB7@xxxxxxxxxxxxxxxx
>I am trying to access a BLOB field in an Oracle 8i database
>using the
> microsoft ODBC driver for Oracle. Accessing the data in code
> (VB6), results
> in an error: "Data type is not supported.".
>
> Can somebody help me here with a suggestion for how to get
> access to BLOB
> data in an Oracle DB. I've found pages on MSDN that tell me
> that Microsoft's
> ODBC driver does not support Oracle BLOB data, but i have some
> difficultly
> believing that there is no way around this...!

Believe it. The MS ODBC driver for Oracle is ancient. Use the
Oracle driver.

- Arnie


.



Relevant Pages