Connector/ODBC

You are here: Sysadmins of the North » Connector/ODBC

ASP and ASP.NET connection string examples for Microsoft SQL Server and MySQL

Code base / By Jan Reilink / 17/10/2018 23/11/2022

This article provides you with a couple of ASP.NET to SQL Server connection string examples for ODBC and OLE DB. And as a bonus for ASP to SQL Server, MySQL, and SSL encrypted connections too.

MySQL Connector/ODBC C# test script

Code base / By Jan Reilink / 03/10/2018 23/11/2022

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).