Cold Fusion Datasource Help

[SusieG]

My website is cold fusion and I would like to install a new script with an access database.

I need to set the datasource but don't know how to go about this.

Can anyone help?

[fmtroute]

The datasource is simply a name that you use to refer to your database. On a local machine you set it up thru the control panel|ODBC. Your provider (host) should have a link in their control panel which would be something like "Create DSN." You provide the datasource name "mydatabase" and the physical path "C:\inetpub\wwwroot\mydatabase.mdb."

In Coldfusion you refer to the datasource as follows:
<cfquery datasource="mydatabase" name="getinfo">

</cfquery>