Connection options

Devart ODBC Driver for MySQL provides a direct TCP/IP connection to a MySQL server and does not require MySQL client libraries.

To establish a direct connection, specify the following required parameters in the driver configuration dialog:

  • Server – The host name or IP address of the MySQL server.

  • Port – The port number for the connection. The default port is 3306.

  • User ID – The MySQL username.

  • Password – The MySQL password.

  • Database – The default database to connect to.

The Devart ODBC Driver for MySQL Configuration window with completed fields

Sample connection string:

DRIVER={Devart ODBC Driver for MySQL};User ID=myUsername;Password=myPassword;Server=myServer;Database=myDatabase;