From: aldemaar@REMOVEgmailTHIS.com   
      
   What's in the BLOB field? I had a similar situation where I had to try   
   and access a Paradox table via VB6 and ADO. I used the Merant ODBC   
   driver (comes with Paradox 10) to create a DSN. I could connect fine,   
   but not transfer BLOB fields.   
      
   I couldn't transfer a BLOB field to SQL Server 2000 either, using DTS.   
      
   I'm guessing it can't be done with ADO.   
      
   I do, however, use Paradox (the program) to update SQL Server 2000   
   databases. I can transfer a MEMO field by casting it as a string, and   
   then using the subsequent string in a SQL UPDATE statement, within   
   Paradox (the program).   
      
   TomK   
      
   Marc wrote:   
   > 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?   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)