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

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 Tom

Thank you for your reply.


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 :-(

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 (AT) REMOVEgmailTHIS (DOT) com> schrieb im Newsbeitrag
news:471dc3c5 (AT) pnews (DOT) thedbcommunity.com...

Hi Dear

I l be very thank full of u if u tell me how u has converted the
paradox database containing memo or blob field in to sql server.
as i m not able to convert memo or blob field in sql server
rest i have done
thank you very much.


Message sent by gupta_atul18 from mombu the microsoft forum http://www.mombu.com/microsoft/

------------------------------------------------------------------------
gupta_atul18's Profile: http://www.mombu.com/microsoft/member.php?u=3730
View this thread: http://www.mombu.com/microsoft/Comp-...S-1115448.html

I used Paradox (the program) to cast the MEMO field as a string, then
updated the SQL Server using an UPDATE statement and pass-through SQL.
MS ODBC driver and BDE 5.2.

I've never tried to transfer anything other than a memo field.

As I said, I don't think you can do it with ADO and you need Paradox
(the program).

TomK

gupta_atul18 wrote: