MySQL ODBC for Windows DSN-Less Connection

This tutorial shows how to verify your driver installation and connect to a MySQL^® database using a DSN-less connection string at the command line. (DSN is a data source name.) The tutorial uses a MySQL ODBC 5.3 Driver to connect to the MySQL database on the Windows^® platform.

Step 1. Verify the driver installation.

The ODBC driver is typically preinstalled on your computer. For details about the driver installation or troubleshooting the installation, contact your database administrator or refer to your database documentation on ODBC drivers.

Step 2. Connect using the DSN-less connection string and command line.

1. Connect to the database using the DSN-less connection string with the odbc function. For example, this code assumes that you are connecting to the local database server, database name toystore_doc, user name username, and password pwd.

   dsnless = strcat("Driver={MySQL ODBC 5.3 Ansi Driver}; Server=localhost; ", ...
      "Database=toystore_doc; UID=username; PWD=pwd");
   conn = odbc(dsnless);

2. Close the database connection.

   close(conn)