Knowledgebase

Portal Home > Knowledgebase > Coldfusion > How can I establish a database connection using Coldfusion in Dreamweaver?

How can I establish a database connection using Coldfusion in Dreamweaver?

If using MS Access:
-------------------
You'll want to create a local DSN on your machine and connect with your database locally in your development environment using the DataSource.

Then you'll want to create a DSN (through the control panel) on the server so your Coldfusion pages can interact with the database on the server.


If using MySQL:
---------------
You will want to create a local DataSource (DSN) and also create one on the server through the Control Panel.

That way, you can set your local DSN to use 'remote ip address' as the "MySQL server host", and on the server it will be set to use the 'local ip address'

Add to Favourites    Print this Article

Example for ColdFusion 8/9 error handling within application.cfc (Views: 20964)

Do you support the tag CFCONTENT? (Views: 1769)

Can I use J2EE Session Variables? (Views: 1547)

Do your ColdFusion servers support Verity? (Views: 1541)

Do you support Scheduled Tasks for Coldfusion? (Views: 1735)