From: info@mawnet.com   
      
   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 Support 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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)