Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
Dear all,
I get errors about "An unhandled win32 exception occured in mysqld-nt.exe" in Visual Studio Just-In -Time Debugger and "Error Code : 2003 Can't connect to MySQL server on 'localhost' (10061)" when i executing my query.
Below is the query I executing. I tried few times and tried in different database.
But still get the same error.
Can anyone help me with this? Is the query I execute got problem? Or there is another problem that happened? Thanks in advance.
UPDATE con_sales SET con_sales.suppmargin = (SELECT DECODE(con_margin.mode,'@5$@dAsEfv^&%5$aks19Dc2008') FROM con_margin WHERE con_sales.DiscRate = DECODE(con_margin.mode3,'@5$@dAsEfv^&%5$aks19Dc2008') AND con_margin.groupid = con_sales.GroupID AND con_sales.brandid = con_margin.brandid) WHERE con_sales.receiptDate = '2013-02-19'
Posted 20-Feb-13 17:34pm
Des DC533
Edited 25-Feb-13 14:53pm
v2
Comments
Mohibur Rashid at 25-Feb-13 20:33pm
   
where does your error start? it says cannot connect to your database server. check if you are able to connect at all.
Des DC at 25-Feb-13 20:39pm
   
I tried other queries. Its works and can connect. But once use this query then the Visual Studio Just In Time Debugger appear,then I click no button. Then the MySQL show error can't connect to server.
Mohibur Rashid at 25-Feb-13 20:44pm
   
how about executing this query on mysql-client console....
Des DC at 25-Feb-13 21:05pm
   
I never try. But this is work as well for other program. I was copied this query from other program. Because I was assigned to convert the program into vb.net. So I just copy it. I try to run the program that use this query,its work. But when I run in my program,then its will not work and come out those errors.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web01 | 2.8.1411022.1 | Last Updated 25 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100