Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Paradox > Accessing BLOB ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 1291 of 1390
Post > Topic >>

Accessing BLOB fields through ADO in VBS

by "Marc" <info@[EMAIL PROTECTED] > Oct 23, 2007 at 10:53 AM

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
 




 5 Posts in Topic:
Accessing BLOB fields through ADO in VBS
"Marc" <info  2007-10-23 10:53:03 
Re: Accessing BLOB fields through ADO in VBS
Tom Krieg <aldemaar@[E  2007-10-23 19:49:43 
Re: Accessing BLOB fields through ADO in VBS
"Marc" <info  2007-10-23 19:31:40 
re : Accessing BLOB fields through ADO in VBS
"gupta_atul18"   2007-10-30 00:15:36 
Re: re : Accessing BLOB fields through ADO in VBS
Tom Krieg <aldemaar@[E  2007-11-03 17:59:41 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Wed Jul 9 1:32:50 CDT 2008.