> -----Original Message----- > From: Robert Bielik [mailto:[EMAIL PROTECTED] > Sent: Sunday, January 22, 2006 9:33 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Writing/reading blobs > > I think he has more or less abandoned that project. So I've > had to tweak > the ODBC driver to work with > blobs anyway (because the 0.65 ODBC driver could only handle text). > > I've tweaked the SQLGetData to retrieve a blob correctly, > haven't tried it > yet with large data tho.. but > not SQLPutData yet (at least not sufficiently). So you mean > I'd alloc a > buffer in SQLBindParameter > (where length of data is given), then fill that buffer in > SQLPutData (til > its done), and then pass it to SQLite?
Something to that effect would probably work, provided you knew in advance what size the blob would be. Robert