You may use ADO Stream object for retriving and saving BLOB data.
>>> deep kapasi <[EMAIL PROTECTED]> 08/13/02 06:03PM >>>
Hi,
I have already posted this query 4-5 days ago but no
reply yet so posting 2nd time.
Here is the query.
Application Used: Visual Basic 6
Database: MySQL 4.0.2
ODBC: MyODBC 3.51.03
I have create a table which has BLOB field in which i
want to save a bitmap file.
To save record i create a ADO recordset for that table
and after that update that field with binary data of
image file, but problem is that though field is of
BLOB datatype ADO recordset say its size is only 64K
so if i try to save file larger than 64K it truncates
remaining data.
Following is the table structure and vbcode i use
----------------------------------------------------
MySQL Tables -->
create table attachment
(
attachmentid int auto_increment not null primary key,
attachmentname varchar(200),
attachment longblob
)type=innodb;
VBCode -->
Dim cnn as New ADODB.Connection
Dim rst as New ADODB.Recordset
cnn.open "Driver={MySQL ODBC 3.51
Driver};SERVER=localhost;DB=test;UID=root;PWD=pwd;OPTION=35"
With rst
Set .ActiveConnection = cnn
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockPessimistic
.Open _
Source:="SELECT * FROM
Attachment",Options:=adCmdText
End With
Debug.print rst.fields("Attachment").DefinedSize
------------------------------------------------------
Any Help/Suggestion is appreciated.
Waiting for help/suggestion.
__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
posting. To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail [EMAIL PROTECTED] instead.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
