I wanted to create a mysql connection checker for my program and as always i used my usual advisor SO and i landed on this Question and the answer was not exactly right.
The Question is: How to check for a valid mysql connection at c#?
Add a comment
|
1 Answer
Here is my own version to check mysql connection.
public static bool checkDB_Conn()
{
var conn_info = "Server=address;Port=3306;Database=dbhere;Uid=admin;Pwd=123";
bool isConn = false;
MySqlConnection conn = null;
try
{
conn = new MySqlConnection(conn_info);
conn.Open();
isConn = true;
}
catch (ArgumentException a_ex)
{
/*
Console.WriteLine("Check the Connection String.");
Console.WriteLine(a_ex.Message);
Console.WriteLine(a_ex.ToString());
*/
}
catch (MySqlException ex)
{
/*string sqlErrorMessage = "Message: " + ex.Message + "\n" +
"Source: " + ex.Source + "\n" +
"Number: " + ex.Number;
Console.WriteLine(sqlErrorMessage);
*/
isConn = false;
switch (ex.Number)
{
//http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html
case 1042: // Unable to connect to any of the specified MySQL hosts (Check Server,Port)
break;
case 0: // Access denied (Check DB name,username,password)
break;
default:
break;
}
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return isConn;
}
4 Comments
SLaks
You should use
using instead of finally.
Incognito
Yes i didnt know that "using" was closing the connection. Thanks
EKanadily
compying this code to my project error says : The name 'ConnectionState' does not exist in the current context. both using MySql.Data; using MySql.Data.MySqlClient; are present...
aland
System.Data.ConnectionState.Open is the full path