From: info@mawnet.com   
      
   Hi Tom   
      
   Thank you for your reply.   
      
      
   > What's in the BLOB field?   
      
   Just a record. We put it like this for legacy reasons.   
   I could split it up into different fields, but this is quite a task :-(   
      
   > I'm guessing it can't be done with ADO.   
      
   What puzzles me is that there is an MSDN article from 2004 stating that at   
   the time it was impossible and that no one has come up with a solution in   
   the mean time.   
   There must be surely other people trying to access Paradox BLOB fields   
   through ADO.   
      
   Rds   
   Marc   
      
      
   "Tom Krieg"  schrieb im Newsbeitrag   
   news:471dc3c5@pnews.thedbcommunity.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)