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" <aldemaar@[EMAIL PROTECTED]
> schrieb im Newsbeitrag
news:471dc3c5@[EMAIL PROTECTED]
> 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 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?
>>
|
