Hi Jim, Your advice is indeed correct for the access denied problem. For your own problem, you might consider taking a look at max_allowed_packet variable of MySQL, as this error is common when you are sending a large blob update and the variable is too small for the update SQL, i.e. max_allowed is 1Mb and you are sending a 2Mb SQL statement. Also the client write and read timeout also causes this error, i.e. when you are doing a query which takes longer than say 60 seconds and your read timeout is set for a default 30 seconds.
Kind Regards SciBit MySQL Team http://www.scibit.com MySQL Products: http://www.scibit.com/products/mycon http://www.scibit.com/products/mysqlcomponents http://www.scibit.com/products/mysqlx http://www.scibit.com/products/mascon > > -----Original Message----- > From: "Jim Zipper" <[EMAIL PROTECTED]> > To: "Emmanuel d" <[EMAIL PROTECTED]> > CC: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > Subject: Re: error > Sent: Thu, 23 Dec 2004 03:58:55 GMT > Received: Thu, 23 Dec 2004 04:01:35 GMT > Read: Thu, 23 Dec 2004 09:05:20 GMT > I am no expert by any means but over the last week I have been trying to > solve why I can't connect from W XP as well. I keep getting the error > message 2013 "lost connection during SQL query." But what I have learned I > think is that the error message you have received indicates that you have > not set up the proper MySQL user access privileges. As I understand it you > need to define access privileges for the client host, user and password. > There are wildcard settings and defaults when these fields are left blank. I > learned allot from these sections of the MySQL manual > http://dev.mysql.com/doc/mysql/en/Privilege_system.html & > http://dev.mysql.com/doc/mysql/en/User_Account_Management.html but > unfortuantely I have still not solved my problem. > > I don't know if this helps or not but I thought I would try to help. If > there is anything you can suggest to solve my problem please respond as well > > TTFN > > ----- Original Message ----- > From: "Emmanuel d'Ange" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, December 22, 2004 3:26 PM > Subject: error > > > Hi, > I've install odbc 3.51driver on win XP. I've already configure the > connector with the correct parameter but when I try to test the connection, > I've got this message : [MySQL][ODBC 3.51 Driver]Access denied for user: > '[EMAIL PROTECTED]' (using password: yes) > I don't know what to do. > thanks > Best regard > > e.d'Ange > > > > -- > MySQL ODBC Mailing List > For list archives: http://lists.mysql.com/myodbc > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
