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.

To request this thread, e-mail <mysq...@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-php_dev=inge...@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php