Visual Studio Just-In-Time Debugger and "Error code 2003" in MySQL when execute query

1.00/5 (1 vote)

See more:

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 16:34pm

Des DC

Updated 25-Feb-13 13:53pm

Add a Solution

Comments

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

Last 24hrs

This month

Pete O'Hanlon	185
Graeme_Grant	120
Andre Oosthuizen	85
Dave Kreskowiak	60
Ravi Bhavnani	50

Pete O'Hanlon	1,770
OriginalGriff	1,270
Graeme_Grant	810
Richard Deeming	743
Dave Kreskowiak	599

Visual Studio Just-In-Time Debugger and "Error code 2003" in MySQL when execute query

Add your solution here

Preview 0

Visual Studio Just-In-Time Debugger and "Error code 2003" in MySQL when execute query

Add your solution here

Preview 0

Existing Members

...or Join us