You can use the ColdFusion Administrator to specify connection string arguments for data sources that use the Microsoft Access, ODBC Socket, MySQL, or DB2 drivers.
Open the Advanced Settings page for a Microsoft Access, ODBC Socket, MySQL, or DB2 driver.
Enter name=value pairs in the Connection String field. Separate pairs with a semicolon (;), except for MySQL, in which case you use an ampersand (&) as the separator.
For example, you can specify the application name and workstation ID for an ODBC Socket connection to SQL Server. If you enter:
APP=RaiseGenerator;WSID=TWriter01
the Administrator configures the following ODBC connection string:
DSN=odbcdsnname;APP=RaiseGenerator;WSID=TWriter01
In the preceding string, odbcdsnname is the name of the ODBC DSN. This is the string that the Microsoft Access or ODBC Socket driver uses to connect to the data source at run-time.
Note: The connectstring tag attribute is not supported in ColdFusion.