Click here to Skip to main content
13,409,239 members (41,412 online)
Rate this:
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
Updated 25-Feb-13 14:53pm
Mohibur Rashid 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 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 25-Feb-13 20:44pm
how about executing this query on mysql-client console....
Des DC 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 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)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web03 | 2.8.180221.1 | Last Updated 25 Feb 2013
Copyright © CodeProject, 1999-2018
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