Click here to Skip to main content
Search within:



Next

Visual Studio Just-In-Time Debugger and "Error code 2003" in MySQL when execute query
Sign Up to vote bad
good
See more: Visual-StudioMySQLVB.NET
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:34
Des DC468
Edited 25 Feb '13 - 13:53
v2
Add a Solution

Comments
Mohibur Rashid - 25 Feb '13 - 20:33
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:39
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:44
how about executing this query on mysql-client console....
Des DC - 25 Feb '13 - 21:05
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)

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 483
1 Arun Vasu 315
2 OriginalGriff 250
3 Maciej Los 218
4 Aarti Meswania 170
0 Sergey Alexandrovich Kryukov 9,670
1 OriginalGriff 7,409
2 CPallini 3,968
3 Rohan Leuva 3,352
4 Maciej Los 2,861


Advertise | Privacy | Mobile
Web04 | 2.6.130523.1 | Last Updated 25 Feb 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid