C# Query: 'System.InvalidOperationException' | Additional information: Connection must be valid and open

Question

connectionString = @"server=localhost;database=" + lbDatabase.SelectedItem.ToString() + ";userid=root;password=;";

        string query = "SELECT order_id FROM orders WHERE id = 1";

        MySqlConnection connect = new MySqlConnection(connectionString);

        MySqlCommand cmd = new MySqlCommand(query, connect);

        reader = cmd.ExecuteReader();

Hello,

I have this problem when I run the following code. I get this not so very specific error:

An unhandled exception of type 'System.InvalidOperationException' occurred in MySql.Data.dll

Additional information: Connection must be valid and open.

If anyone could help me out I would really appreciate it,

Thank you.

Well the exception seems pretty clear. You don't have a valid, open connection. Look at your code - where do you think you're opening the connection? Try connect.Open()... — Jon Skeet
– Jon Skeet, Commented Feb 23, 2015 at 10:56
The connection is already opened by another methode. When I add connect.Open() it says the connection is already open. — Quartermain
– Quartermain, Commented Feb 23, 2015 at 11:00
Then there's code you haven't shown us, which makes it hard to help you... — Jon Skeet
– Jon Skeet, Commented Feb 23, 2015 at 11:00

user2930590 · Accepted Answer · 2015-02-23 12:21:03Z

0

The syntax for MySql Connectionstring is as follows:

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Note that you are using 'userid' and 'password' instead of 'uid' and 'pwd'.

answered Feb 23, 2015 at 12:21

user2930590

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:32:47Z

0

Assuming that your Connection String is Right .. Try This

connectionString = @"server=localhost;database=" + lbDatabase.SelectedItem.ToString() + ";userid=root;password=;";

    string query = "SELECT order_id FROM orders WHERE id = 1";

    MySqlConnection connect = new MySqlConnection(connectionString);


    MySqlCommand cmd = new MySqlCommand(query, connect);

    connect.Open();

    reader = cmd.ExecuteReader();

 /*Do Whatever You Want To Do Here */

connect.Close();

You Can Refer this Link for Reference. Exception: System.InvalidOperationException Trying to validate a login information

Hope This Helps :)

edited May 23, 2017 at 12:32

CommunityBot

11 silver badge

answered Apr 14, 2015 at 13:26

Gaurav Modi

801 silver badge10 bronze badges

Collectives™ on Stack Overflow

C# Query: 'System.InvalidOperationException' | Additional information: Connection must be valid and open

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related