I am getting a Mysql Exception.What is the reason?

Question

1.00/5 (1 vote)

See more:

.NET2.0

MySql.Data.MySqlClient.ExceptionInterceptor.Throw(Exception exception) at MySql.Data.MySqlClient.MySqlConnection.Throw(Exception ex) at MySql.Data.MySqlClient.MySqlCommand.Throw(Exception ex) at MySql.Data.MySqlClient.MySqlCommand.CheckState() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()

I am getting above exception. I am not able to figure out the reason for it.
The problem arised when I decided to switch to MySql 5.2.7.
earlier I was working with 3.5.1.
Now I have a MySql 64bit connection with 32bit .Net Driver

I have MySql 64bit installed at one server and my website is on another server which is 32bit hence requires 32bit driver

Posted 27-Aug-15 20:42pm

VipinKumar Maurya

Updated 28-Aug-15 19:05pm

v2

Add a Solution

Comments

Richard MacCutchan 28-Aug-15 3:42am

You cannot mix 64 and 32 bit in the same application.

Herman<T>.Instance 28-Aug-15 4:43am

MySql is not in his application (I hope) ;)
I do not have the feeling that this is the complete exception. What type of exception is given?

Richard MacCutchan 28-Aug-15 5:14am

So how does it connect to the database, and how does it throw an exception, if it's not in the application?

Herman<T>.Instance 28-Aug-15 5:17am

Than wha does this mean:
MySql 64bit connection with 32bit .Net Driver?

Richard MacCutchan 28-Aug-15 5:22am

I assume it means he has a 64 bit application trying to connect through the 32 bit .NET driver. However, as with so many questions, the OP fails to provide proper details, so your guess is as good as mine.

Actually, on second thoughts OP's statement does not mean anything.

[no name] 28-Aug-15 10:34am

1) Add catch (Win32Exception ewin32Exception)
{ //Code to handle the exception and cause of error }
2) You should not be catching ' exception ' until you think you have covered all other possible exceptions first. Calling ' exception ex ' will ignore all other exceptions caught after it has executed.

What you are doing is what I call lazy coding.

Richard MacCutchan 28-Aug-15 10:49am

Really? What you are doing is replying to the wrong person.

[no name] 28-Aug-15 10:52am

It's a threaded discussion, OP will still see it. Who cares

Richard MacCutchan 28-Aug-15 11:04am

Well I guess a lazy person won't care. BTW the OP will not see this as he will get no notification of the message. Please learn how to use the forums properly.

[no name] 28-Aug-15 11:10am

Please don't tell me what to do or how to use the website. I'm on here long enough to know how things work. If you don't like my content, then go past it. If the OP is not lazy, they will check the comments. Are you obliged to reply to me?

Richard MacCutchan 28-Aug-15 11:11am

Man, stop being such a jerk.

[no name] 28-Aug-15 11:15am

Then don't try and spoil for an argument with me with comments like " Really? What you are doing is replying to the wrong person. "

Richard MacCutchan 28-Aug-15 11:21am

I was not spoiling for an argument, I was merely pointing out the the message you posted was not for me but for the OP. That is what the "Have a Question or Comment" button is for: please use it.

Richard MacCutchan 29-Aug-15 4:02am

You have edited the question, but there is no new information. Please respond to some of the questions that have already been posted.

VipinKumar Maurya 31-Aug-15 2:17am

I have two server system one with 64 bit on which MySql is configured and another server system on which website is configured in IIS server.
I am using MySql.Data namespace to communicate with my database. Since web application is on 32bit sytem. I have installed 32bit driver.

Richard MacCutchan 31-Aug-15 2:36am

Did you check that the 32 bit driver can work with a 64 bit server? Have you collected the full details of your exception, including the line of code where it occurs?

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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