RE: ado , blob reading problem

2002-11-27 Thread Mike Hillyer
You cannot get a BLOB back in one piece. I wrote an article at www.dynamergy.com/mike/blobaccessvb.html that describes how to use the adodb.stream object to access MySQL BLOB data through VB. Mike Hillyer -Original Message- From: Lalit Chandwani [mailto:[EMAIL PROTECTED]] Sent: Wednesday

Re: ado , blob reading problem

2002-11-27 Thread John Ragan
you won't get a large blob back in one piece. to retrieve blobs, you need to use the getchunk method. refer to getchunk in the vb documentation. it also has an excellent example. > i am using vb,ado,myodbc,mysql > > i have some values in longblob,mblob fields > > when i read it with ad