Binary Data and BLOB Problem

[Kevin Wixson]

Having trouble with my first MySQL database. I want to upload and install image files to a database for online sample photo gallery for our customers. The system I've created so far sometimes works, sometimes doesn't. It seems to depend on the size of the file being uploaded, but tests have been inconclusive. Having trouble diagnosing the problem since the error is most often "Internal Server Error," which doesn't tell me much. Otherwise I get:


Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

[MySQL][ODBC 3.51 Driver][mysqld-4.0.5-beta-max-nt]Lost connection to MySQL server during query

/shooters/Insert.asp, line 148

The relevant code is:

' Checking to make sure if file was uploaded
If fileSize > 0 Then

set rsImage = Server.CreateObject("ADODB.Recordset")
rsImage.ActiveConnection = MM_connShooters_STRING
rsImage.Source = "select * from web_lab.Images limit 0"
rsImage.CursorType = adOpenKeyset
rsImage.CursorLocation = adUseClient
rsImage.LockType = adLockPessimistic
rsImage.Open()
rsImage_numRows = 0

' Adding data
rsImage.AddNew
rsImage("userID") = userID
rsImage("imageType") = contentType
rsImage("imageSize") = fileSize
rsImage("imageName") = fileName
rsImage("imageCaption") = caption
Do While lngOffset < fileSize
varChunk = LeftB(RightB(fileData, fileSize - lngOffset), conChunkSize)
rsImage("imageData").AppendChunk varChunk
lngOffset = lngOffset + conChunkSize
Loop

ERROR--> rsImage.Update

'adoImageStream.Close
rsImage.Close
Set rsImage = Nothing

Response.Write "<font color=""green"">File was successfully uploaded..."
Response.Write "</font>"
Else
Response.Write "<font color=""brown"">No file was selected for uploading"
Response.Write "...</font>"
End If

My connection string is:

MM_connShooters_STRING = "driver={MySQL ODBC 3.51 Driver}; database=[name];uid=[id];pwd=[pass];OPTION=16427;"

The constant conChunkSize is 100. I have checked the max packet size (set to 15500000) and as you can see, set cursors to client.

Alternatively, I have also tried to use the stream object, but I haven't had any luck there either. I'm sure I'm not doing it right.



Thank you,

Kevin Wixson
IT Manager
Norman Camera & Video

(616) 567-5552
1-800-900-6676
Fax: (616) 343-6410
e-mail: [EMAIL PROTECTED]

Visit us on the web at: http://www.normancamera.com


---------------------------------------------------------------------
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