Re: Oracle BLOB and ODBC connection

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"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

  • RE: oracle linked serve error "OLE/DB provider returned an invalid schema definition" - issue st
    ... linked Oracle tables in your SQL Server queries. ... resolve this open issue with MDAC / Microsoft ODBC Driver for Oracle. ...
    (microsoft.public.sqlserver.connect)
  • Re: Need help with Access 97 and Oracle 9i
    ... I'm trying to make the connection on the my local machine. ... discussed using ODBC driver to connect to Oracle. ... I found that the Microsoft ODBC Driver doesn't ... I'm looking for anything I can get; suggestions, recommendations, ...
    (microsoft.public.access.externaldata)
  • RE: ORACLE DRIVER
    ... The thing is that I'm using in a Linux machine. ... So is there any free Oracle ODBC driver for Linux? ... UnixODBC is a freeware but couldn't find any free Oracle Drivers. ...
    (perl.dbi.users)
  • Re: CA-Realia, SqlState -91, Odbc preprocessor and Oracle database
    ... Using Microsoft Odbc Driver for Oracle, the buffer size was 64K ...
    (comp.lang.cobol)
  • RE: SQLFetch() very slow with Oracle
    ... Based on my understanding, the problem is when calling the SQLFetchto ... fetch the data from Oracle database, you found Microsoft's ODBC driver is ... so much slower than the Oracle driver to complete the above operation. ... ODBC driver and Oracle driver just as you mentioned. ...
    (microsoft.public.vc.database)