accessing blob fileds from oracle

[Chenna Sudarsan]

Hello,
I am connecting to Oracle9.2 database from VB6.0 using MSDAORA provider. I
am using ADO2.5.
When I try to access a blob column of oracle I am getting the below
mentioned error.

--------------------
Run-time error '-2147467259 (80004005)':

Data type is not supported.
----------------------

When I try to connect using OracleOLEDB.Oracle provider I am able access the
blob column and get the image stored in the column.
I can not use this provider as all my clients will not contain this
provider. I need to use MSDAORA provider only.

Could any tell me what could the problem?

regards,
Chenna

 

[Armin Zingler]

Hello,
I am connecting to Oracle9.2 database from VB6.0 using MSDAORA
provider. I am using ADO2.5.

This is a VB.Net newsgroup. The best place to ask VB6 related database
questions is microsoft.public.vb.database.ado


Armin

 

[Paul Clement]

¤ Hello,
¤ I am connecting to Oracle9.2 database from VB6.0 using MSDAORA provider. I
¤ am using ADO2.5.
¤ When I try to access a blob column of oracle I am getting the below
¤ mentioned error.
¤
¤ --------------------
¤ Run-time error '-2147467259 (80004005)':
¤
¤ Data type is not supported.
¤ ----------------------
¤
¤ When I try to connect using OracleOLEDB.Oracle provider I am able access the
¤ blob column and get the image stored in the column.
¤ I can not use this provider as all my clients will not contain this
¤ provider. I need to use MSDAORA provider only.
¤
¤ Could any tell me what could the problem?

Yes, the Microsoft ODBC driver and OLEDB provider do not support a BLOB data type:

http://support.microsoft.com/default.aspx?scid=kb;en-us;244661


Paul
~~~~
Microsoft MVP (Visual Basic)