22.1.4.6. Connecting Without a Predefined DSN

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 3.51:

ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};\                   SERVER=localhost;\                   DATABASE=test;\                   USER=venu;\                   PASSWORD=venu;\                   OPTION=3;"

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 3.51 Driver};"                   "SERVER=localhost;"                   "DATABASE=test;"                   "USER=venu;"                   "PASSWORD=venu;"                   "OPTION=3;"

Note. On Mac OS X, you might need to specify the full path to the Connector/ODBC driver library.

Refer to Section 22.1.4.2, "Connector/ODBC Connection Parameters" for the list of connection parameters that can be supplied.