where [] indicates optional parameters
and name is a valid data source name (DSN)
and uid is an identifier for the user accessing the database
and password is the password of the user accessing the database
For example DSN=test;UID=sa;PWD=
When the connection string is in the first form then it is passed, without further processing, to
SQLDriverConnect to open the connection. When the connection string is in the second form then the
name, id, and password parameters are extracted from the connection string, if present, and passed to
SQLConnect to open the connection. NOTE: The first form of the connection string is the recommended
form, support for the second form is provided for completeness only.
See the Irie Pascal Programmer's Reference Manual (in "progref.html") for more information.
The authoritative source of information about ODBC is the Microsoft Developers Network (MSDN). You
can access the MSDN on the Microsoft website at msdn.microsoft.com.
3.11.1.2 Connecting to MySQL databases
What is MySQL?
MySQL is a popular open source database management system (DBMS). MySQL is particular popular
for computers running Linux and FreeBSD. You can go to www.MySQL.com for more information about
MySQL.
Connecting to MySQL databases
In order to connect to a MySQL database, you need to:
1. Declare a variable of the built-in type connection
2. Use new on the variable to create a connection object
3. Invoke the open method of the connection object
The open method of the connection object takes one argument, the connection string. MySQL connection
strings take the following form:
mysql-connection-string = 'MYSQL' ';' mysql-parameter-list
mysql-parameter-list = mysql-parameter ';' mysql-parameter-list | empty
mysql-parameter = mysql-host-parameter | mysql-user-parameter | mysql-password-parameter | mysql-
database-parameter | mysql-port-parameter | mysql-socket-parameter | mysql-compress-parameter
mysql-host-parameter = 'host' '=' '"' host-name '"'
mysql-user-parameter = 'user' '=' '"' user-name '"'
