IIS7 + ColdFusion 9 connection to MySQL database

Maria,

did you ever figure out how to resolve this issue.  I am having the same issue and cannot fix it except to start a new project and copy all my files.  I then must also update the service.

roddyda

Go the ColdFusion Administrator page. Find the left menu option for

Datasources. On that page create a new datasource using the form, select

the appropriate driver on the form (MySQL). This takes you to a larger form

with more details for host, database name, username, password, etc. See

this for what each form field means:

http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fe4.html

After entering the information submit that form to create a new datasource.

You can then use that datasource name in your ColdFusion code like <cfquery

datasource="myDatasourceName"...