Hello Everyone... I need to put in the images table of the DB, 10 pictures of 60kb each one, when i do that, i lost the connection, but if a upload 10 pictures of 30kb each one, i haven't got the problem. I'm getting the following error when I run my select query within my VB code: [MySQL][ODBC 3.51 Driver][mysqld-3.23.27-beta-log]Lost connection to MySQL server during query. This seems like a timeout error to me, but I don't know how to compensate so that it doesn't time out. My VB code is using Microsoft's OLE DB provider for ODBC, and mysql's odbc connector. Any suggestions would be greatly appreciated. Thanks for your time...

Reply

I'm not sure if this post will be usefull to you, but I'll give it a shot...

First of all, I'm not using MySQL from VB that much (I am actualy starting to use it), but I most definitely WILL NOT use ADO, MS ODBC or anything like that... I will use MySQL directly, using some dll's.

Here's what you should do:
- Go to Planet Source Code, VB World
- Do a search on term 'MySQL'

There are several articles showing how to use MySQL without the help from ADO or other MS Engines...

That error you are receiving, is definitely timeout error, but I can't explain it. I myself have gotten this error, when connecting to a remote database from MySQL-Front...

Hope this helped...

Reply