The topic of this article is not supported by our customer support department, however for your convenience we have provided third party material to assist you in troubleshooting potential issues related to this topic.

ColdFusion MX supports MySQL by default, but a DSN (datasource name) must be created on the server side to allow you to connect to the MySQL database. Please submit a support ticket at https://my.opensourcehost.com/cm.html?stage=STSSubmitTicket and include the name of your database in addition to the DSN name that you need created. Once a DSN is created, you can connect to it inside of your ColdFusion code by specifying the DSN and the MySQL username (which is the same as your VDS username used for FTP) and password.

In your .cfm file, please use the following format to use the DSN. Replace “password” with your MySQL database password.

Important Note: Only two DSN’s are allowed per VDS account.