How long does it take before the error happens? Remember that IIS has a
default script timeout, which i believe is 90 seconds. Any query that
takes longer than that will fail. Cheers.
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
5 messages in com.mysql.lists.win32Re: adding a large file to a database...
