You can connect to the MySQL server using
SQLDriverConnect
, by specifying the
DRIVER
name field. Here are the connection
strings for Connector/ODBC using DSN-less connections:
For Connector/ODBC 9.0:
ConnectionString = "DRIVER={MySQL ODBC 9.0 Unicode Driver};\
SERVER=localhost;\
DATABASE=test;\
USER=venu;\
PASSWORD=venu;\
FOUND_ROWS=1;"
Substitute “MySQL ODBC 9.0 Driver” with the name by which you have registered your Connector/ODBC driver with the ODBC driver manager, if it is different. If your programming language converts backslash followed by whitespace to a space, it is preferable to specify the connection string as a single long string, or to use a concatenation of multiple strings that does not add spaces in between. For example:
ConnectionString = "DRIVER={MySQL ODBC 9.0 Unicode Driver};"
"SERVER=localhost;"
"DATABASE=test;"
"USER=venu;"
"PASSWORD=venu;"
"FOUND_ROWS=1;"
Note. On macOS, you might need to specify the full path to the Connector/ODBC driver library.
Refer to Section 5.5.2, “Connector/ODBC Connection Parameters” for the list of connection parameters that can be supplied.