Jump to content
xisto Community
Sign in to follow this  
kservice

Lost Connection To Mysql Server During Query [ Please, Help

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.