[mdavies1983]

I am currently working on a project to convert an old Excel tool into a more stable C# application. In the existing Excel tool it connects to a sql database via ODBC with the following connection string:

Set conn = New ADODB.Connection
conn.Open DRIVER={MySQL ODBC 5.1 Driver};SERVER=test.server.com;DATABASE=dbname;USER=username;PASSWORD=password;Option=3"

I'm now trying (unsuccessfully) to connect to the sql database via C# with the following connection string:

System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
conn.ConnectionString = "integrated security=SSPI;data source=test.server.com;persist security info=False;initial catalog=dbname;user id=username;password=password;"
conn.Open();

The error message I receive says that it failed to connect to data source. The server was not found or was not accessible. I've been pulling my hair out with this for a good few hours now and can't see what I'm missing.

[Skydiver]

The SqlConnection class is meant to connect to the Microsoft SQL Server.

You may want to use the MySQL Connecter/Net, and use the MySqlConnection class.

Alternately, you can try using the
OdbcConnection class since you were using the ODBC driver previously.

[mdavies1983]

I opted for the ODBC approach and have it working now. Thank you!

string myConnString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=test.server.com;DATABASE=dbname;USER=username; PASSWORD=password;OPTION=3;";
OdbcConnection myConnection = new OdbcConnection(myConnString);
myConnection.Open();