MySQL Connector/ODBC C# test script

Photo of author
Written By Jan Reilink

Windows Server systems administrator & enthusiast.

Whenever you need to test your ASP.NET connection to your MySQL database, using ODBC, you can use the following C# test script. Currently it uses MySQL ODBC 8.0 Unicode Driver, but you can easily change the version used. As a bonus it prints some connection information and it requires an SSL connection to your MySQL database (SslMode=REQUIRED).

<%@ Page Language="C#" Trace="False" Debug="False" EnableViewState="False" %> <%@ import Namespace="System.Data.Odbc" %> <script runat="server"> private void Page_Load(object sender, System.EventArgs e) { try { string MyConString = "DRIVER={MySQL ODBC 8.0 Unicode Driver};" + "Provider=MSDASQL;" + "SERVER=HOSTNAME;" + "DATABASE=DATABASENAME;" + "UID=USERNAME;" + "PASSWORD=PASSWORD;" + "SslMode=REQUIRED;"; OdbcConnection MyConnection = new OdbcConnection(MyConString); MyConnection.Open(); Response.Write("<br /> !!! success, connected successfully !!!<br />"); Response.Write("Connection Information:<br />"); Response.Write("Connection String:" + MyConnection.ConnectionString + "<br />"); Response.Write("Connection Timeout:" + MyConnection.ConnectionTimeout + "<br />"); Response.Write("Database:" + MyConnection.Database + "<br />"); Response.Write("DataSource:" + MyConnection.DataSource + "<br />"); Response.Write("Driver:" + MyConnection.Driver + "<br />"); Response.Write("ServerVersion:" + MyConnection.ServerVersion + "<br />"); MyConnection.Close(); } catch (OdbcException MyOdbcException) { for (int i=0; i < MyOdbcException.Errors.Count; i++) { Response.Write("ERROR #" + i + "<br />" + "Message: " + MyOdbcException.Errors[i].Message + "<br />" + "Native: " + MyOdbcException.Errors[i].NativeError.ToString() + "<br />" + "Source: " + MyOdbcException.Errors[i].Source + "<br />" + "SQL: " + MyOdbcException.Errors[i].SQLState + "<br />"); } } } </script>
Code language: C# (cs)

Set SslMode to PREFERRED or DISABLED if SSL is not available on your MySQL database server.

Use NO_SSPS=1 as a connection option when server-side prepared statements are not returning any results โ€“ for example with VARCHAR() columns larger than 1024 bytes. If you have installed Connector/ODBC side-by-side with Connector/NET, you can use this MySQL ODBC test script next to my MySql.Data.MySqlClient test script. Neat, right? :)

Did you like: MySQL Connector/ODBC C# test script

Then please, take a second to support Sysadmins of the North and donate!

Your generosity helps pay for the ongoing costs associated with running this website like coffee, hosting services, library mirrors, domain renewals, time for article research, and coffee, just to name a few.

1 thought on “MySQL Connector/ODBC C# test script”

Hi! Join the discussion, leave a reply!