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

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


Armin

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

Search Arraylist in Arraylist.
PropertyBag in VB.NET?
Saving a Database to Disk
Windows Form Application Help
Allowing access to controls from another thread
PostMessage and Combobox
Question about Control Collection in VB.net
Cast from string "" to type 'Date' is not valid
Accessing controls from another thread
project source design question