IIS7 + ColdFusion 9 connection to MySQL database

[Mary Pieroszkiewicz]

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.

[StevenErat]

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 Pieroszkiewicz]

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?

[Charlie Arehart]

No sure what you're saying: are you saying if you set it to standalone, it does not remain checked?

/charlie

[Mary Pieroszkiewicz]

I show the video.

[Dave Watts]

Why did you uncheck the "default location" checkbox? The default location for CF on Windows is C:\ColdFusion9.

In any case, as long as your project validates, you don't have to worry about this.

Dave Watts, CTO, Fig Leaf Software

http://www.figleaf.com/

http://training.figleaf.com/

[Mary Pieroszkiewicz]

As I don't uncheck "Use default location for local ColdFusion server" is not conducting the validation configuration...

So I don't have to worry as I jump from Standalone to Deployed to J2EE server...?

[Charlie Arehart]

What do you mean, "as I jump from Standalone to Deployed to J2EE server"? Are you changing from running CF in Server or Multiserver mode to running CF as an EAR/WAR file deployed on a JEE server like Tomcat, JBoss, Glassfish, etc.?

It may help for you to restate your situation: what you have, what you want, and what you don't feel you are getting.

/charlie

[Dave Watts]

You're saying that if you leave the box checked, it won't validate?

In any case, it doesn't matter as long as your project compiles properly.

Dave Watts, CTO, Fig Leaf Software

http://www.figleaf.com/

http://training.figleaf.com/

[Mary Pieroszkiewicz]

I configured IIS7. I installed ColdFusion 9 with the option Server configuration.

Now when I connect to the ColdFusion 9 with Flex, is checked option Standalone and when I enter in the project properties is checked Deployed to J2EE server. Why is this happening?

Dave, yes it does not uncheck the "default location" is a CF fails validation.

I showed it on video.

[droddy]

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