Question Locked

How do connect a dreamweaver page to a database using coldfusion

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a web page which I created using micomedia dreamweaver and would like to connect to the Microsoft Access databese using coldfusion on a client machine,how do I do it?

3 replies

by Former member

What version of ColdFusion does Dreamweaver 8 support?

Dreamweaver 8 supports, and integrates with, ColdFusion MX 7.0.1, 7.0 and 6.1. Certain new features in Dreamweaver 8 are only enabled if you're connecting to a ColdFusion 7 server.

Does Dreamweaver 8 support ColdFusion Components?

Dreamweaver 8 can be used to create and modify CFCs. You can also use Dreamweaver 8 to build web pages that use CFCs. New in Dreamweaver 8 is the ability to create a recordset using a CFC Query, and Dreamweaver can create the CFC for you without having to go into code view. You can use CFCs only with Macromedia ColdFusion MX version 6.0 and above.
http://kb.adobe.com/selfservice/viewContent.do?externalId=98dd5a1#cf_ver

Please post back if you have any more problems or questions.

by Former member

Here is an example, though you might have to change a few things....

First,

You need to create your database. If you are using MSAccess, put your database in your domain root, behind the www.

If you are using a SQL database, create the database in your Hsphere control panel and set a user/pass.

Send a ticket to support, stating...
----------------------------------------------------------
1.)
The name and location of your access database, along with a user/pass if you set one for the mdb.

or...

The name, user, and pass, of your SQL database. Keep in mind that the name of your database and users will be prefixed by your login name such as mike333-sqldb and mike333-sqluser

2.)
The preferred name of your datasource to be entered in Jodohost's CF Administrator.
----------------------------------------------------------

Once you have received confirmation from support that your datasource has been created, you can call the datasource in your tag. But, it is better to set your web applications datasource globally in your application.cfm file, eg. . Then in all of your cfqueries, you can just call . Using this method allows you to easily change your datasource name without updating all of your templates.

Please post back if you have any more problems or questions.

This discussion is closed to new replies.