Re: adding a large file to a database.... - Mark Mchugh - com.mysql.lists.win32

5 messages in com.mysql.lists.win32Re: adding a large file to a database...

From	Sent On	Attachments
Mark Mchugh	24 Jan 2005 08:30
Mike Hillyer	24 Jan 2005 08:32
Armando	24 Jan 2005 08:34
John L.Utz III	24 Jan 2005 08:47
Mark Mchugh	24 Jan 2005 08:55

Subject:	Re: adding a large file to a database....
From:	Mark Mchugh (mark...@yahoo.com)
Date:	01/24/2005 08:55:23 AM
List:	com.mysql.lists.win32

thanks Mike, as correct as ever!!!

--- Mike Hillyer <mhil...@mysql.com> wrote:

Mark;

Sounds like you did not set MAX_ALLOWED_PACKET on the server to something higher than 1.5M.

Mike

Mark Mchugh wrote:

hi all, I am trying to add a large file to my database, and it does not seem to work? i am using the following code

Dim mystream As ADODB.Stream Set mystream = New ADODB.Stream mystream.Type = adTypeBinary Set rs = New ADODB.Recordset rs.ActiveConnection = connMySQL rs.Open sqlstr, connMySQL, adOpenStatic, adLockOptimistic

rs.AddNew mystream.Open mystream.LoadFromFile strFileName

rs!file_name = CatDir

rs!file_size = mystream.Size rs!File = mystream.Read

rs.Update mystream.Close rs.Close

when i try to add a file that is ( dont laugh) 1.5 megs or over, i get a message saying " lost connection to mysql server during query"

can anybody help?

thanks

-- Mike Hillyer, Technical Writer MySQL AB, www.mysql.com Office: +1 403-380-6535 Mobile: +1 403-330-0870

MySQL User Conference (Santa Clara CA, 18-21 April 2005) Early registration until February 28: www.mysqluc.com

-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: