Solved

MySqlException

Posted on 2004-04-28
7
361 Views
Last Modified: 2007-12-19
Hello everyone,

I have a C# application that makes use of a MySql Database by means of MySQLDirect.NET.  Is there any way to decipher between the different MySqlExceptions.  Such as lost connection, insufficient rights, etc.  I would like to handle the exceptions specifically, but I need to know to tell the difference between the different MySQLExceptions.  Any Suggestions??????????????

Thanks,
Kendal
0
Comment
Question by:gvector1
  • 3
  • 2
  • 2
7 Comments
 
LVL 37

Expert Comment

by:gregoryyoung
ID: 10941407
ifits like the other sqlexceptions there will be a Errors property that holds more specific info  ...
0
 

Author Comment

by:gvector1
ID: 10941440
I know that there is error codes.  But is there a list somewhere that tells me which error codes mean what coming from a MySQL Exception????????

Kendal
0
 
LVL 12

Expert Comment

by:dfiala13
ID: 10941603
0
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
LVL 12

Accepted Solution

by:
dfiala13 earned 500 total points
ID: 10941626
This might be a more useful resource going forward...
http://www.mysqlfreaks.com/mysql/manual_Error-handling.html
0
 
LVL 37

Expert Comment

by:gregoryyoung
ID: 10941648
they are the native error code from mysql

those two documents should have em.
0
 

Author Comment

by:gvector1
ID: 10943891
I have run into a problem.  Some of the error codes I am receiving when I step through debugger is not on the list.  Such as if I try to execute a command after a connection is lost, I get an error 2013 = Lost Connection.  Any idea where that code is coming from?????

Thanks,
Kendal
0
 
LVL 12

Expert Comment

by:dfiala13
ID: 10953439
A quick search of Google seems to indicate that is an issue with an older version of mySQL...

http://www.google.com/search?q=MYsql+2013&hl=en&lr=&ie=UTF-8&oe=UTF-8&start=10&sa=N
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Vb.net dynamic formulas in runtime 11 74
How to Decrypt in C# a string that is encrypted with Coldfusion Encrypt(string, seed) function 11 101
Server Error 11 58
Video Player 2017 5 20
Article by: Ivo
C# And Nullable Types Since 2.0 C# has Nullable(T) Generic Structure. The idea behind is to allow value type objects to have null values just like reference types have. This concerns scenarios where not all data sources have values (like a databa…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question