IIS7 + ColdFusion 9 connection to MySQL database

Forum|Forum|15 years ago
January 12, 2011
2 replies
2378 views

Hi,

I have set ColdFusion 9 and IIS7 now, it needs to connect MySQL database from ColdFusion 9.

What I still need to make it all work.

Please tell me how do I connect to my MySQL database from ColdFusion

Thank you.

This topic has been closed for replies.

D

droddy

Participant

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

S

StevenErat

Inspiring

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"...

Mary PieroszkiewiczAuthor

Known Participant

When I configure Flex. The combination of ColdFusion server when setting location, set on a standalone and there is automatically selected Deployed to J2EE server. Why is this happening?