MySql connection

Question

Hello!

I'm using a MySql connection to fetch data from my database. On my localhost, it is able to fetch the data, but i can't connect to others databases. I don't understand why. Here's my piece of code.

string MyConString = "SERVER=localhost;DATABASE=BIM;UID=root;PASSWORD=";

MySqlConnection connection = new MySqlConnection(MyConString);

try

{

connection.Open();

}

catch

{

errorMsg("Couldn't establish SQL-connection!");

}

MySqlCommand command = connection.CreateCommand();

MySqlDataReader Reader;

command.CommandText = "SELECT * FROM matches WHERE id="+textBox1.Text;

What the hell am i doing wrong? Btw, I get

Couldn't establish SQL-connection!"); when i do this.

Answer 1

Firstly, here's my favorite website when it comes to Connection strings, 
http://www.carlprothman.net/Default.aspx?tabid=86#MySQLDirectNETDataProvider

In looking at the docs, it seems that the MySQL preferred way is Host, Database, User ID and Password rather than Server, Database, UID and Password. I bring this up because I've had situations where a particular fix or add-on product or filter or something enforces a stricter view of the world.

Next I would double check the port and whether or not you need the DIRECT flag set in your string.

Driss.

Answer 2

Take a look at here too:

how to connect to MySQL:
http://www.connectionstrings.com/?carrier=mysql

HTH