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

Can I run SugarCRM on your servers? (Views: 1444)

Do you support Flash Remoting? (Views: 1553)

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

What smtp do I use for cfmail? (Views: 1591)

Why do I get a "Directory Listing Denied" or "Forbidden" error? (Views: 2627)