Timeout Exception - Error

Question

0.00/5 (No votes)

See more:

When I try retrive a data from a MySQL database using the ExecuteReader() command i receive a timeout error like this :

TimeoutException was unhandled : A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

Can any one state a possible reason for this exception.

The troublesome fragment of code is as under :

VB

Dim connectionst As String = connectionstring   'String concealed 
 Dim querystring As String = "SELECT dat1 FROM mydb WHERE dat2 = '" + txtbox.Text + "';"
Dim commandgive As New MySqlCommand(querystring)
         Dim commandgive As New MySqlCommand(querystring)
        commandgive.Connection = connection
        connection.Open()
        Dim dataread As MySqlDataReader
        dataread = commandgive.ExecuteReader() 'Problematic code.
        MsgBox(dataread.GetInt32(0))

        dataread.Close()
        connection.Close()
connection.Close()

The line commented a problematic code is where vb shows me a timeout exception.

Why is this so ?

Posted 18-Apr-13 15:10pm

compuknow

Updated 18-Apr-13 15:13pm

v2

Add a Solution

Comments

Bernhard Hiller 19-Apr-13 2:52am

Where does the MySQL sever run - on the same machine as your code, or on a different machine?

compuknow 19-Apr-13 3:59am

The application runs on the same machine where the MySQL server runs. In my connection string , i have mentioned localhost.

1 solution

Add a Solution

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)

Dave Kreskowiak · Answer 1 · 2013-04-18T15:51:00

Solution 1

Well, either your connection string is wrong (great job keeping an important piece of information hidden!) and you're not really connecting to the box you think you are or your MySQL server didn't respond with the query results in the default time allowed to execute the command (usually 30 seconds).

That's about all anyone can tell you given the lack of information provided.

Posted 18-Apr-13 15:51pm

Dave Kreskowiak

Comments

compuknow 18-Apr-13 22:10pm

sir , what information is lacking ? I could have provided.

It would not be right to reveal a connection string in a Public domain as it contains security information.

The connection string is right , because it worked when i was inserting data into this same database , the connection string used for insertion is being used here for extraction.

The query string must be right because , i know there exists those columns which are being reffered in that query string.

Could you suggest any other method for receiving data other than ExecuteReader() ?

Dave Kreskowiak 19-Apr-13 8:22am

It has nothing to do with the syntax of your query. I already told you what the two possibilites are for this error. Have a nice day.

compuknow 19-Apr-13 10:55am

The query string executes when executed through the MySQL Command Line Client.

ExecuteReader() must return perfectly because the query hits well through the dedicated command line client of MySQL.

The connection string works well with ExecuteNonQuery() Command , but not with ExecuteReader() command.