Hi All
I need to read from a VB Script a BLOB field in my Paradox 7 table
"messages".
Using the script below, I was able to connect to the database and retrieve
some of the entries, but ADO does not return the BLOB fields.
MSDN KB confirms this situation:
Q300189: Paradox ISAM Does Not Sup****t Some Paradox 4.x Types
As this article if from 2004, is there a solution in the meantime to read
BLOB fields through ADO?
Rds
Marc
***************
Set dbc_conn = CreateObject("ADODB.Connection")
dbc_conn.Open "Driver={Microsoft Paradox Driver (*.db )};" & _
"DriverID=538;" & _
"Dbq=c:\database\;" & _
"CollatingSequence=ASCII"
set rs= createobject("adodb.recordset")
sql="select * from messages"
rs.open sql, dbc_conn,1
while not rs.eof
for each i in rs.fields
MsgBox rs(i.name)
next
rs.movenext
wend