The ColdFusion Server

In order for ColdFusion to able to use the database that you have just created, you must first register it as an ODBC (Open DataBase Connectivity) source. This means that any ODBC application (including ColdFusion) can access the database using standard windows libraries.

Registering the database is a simple procedure, and is done using the ColdFusion Administrator.

1. Open the ColdFusion Administrator. This can normally be found on start menu under 'ColdFusion Server 4.0'

2. Select ODBC under datasources.

3. The ODBC driver for Access should be displayed as a default driver. Click on 'add'.

4. Type MyDataSource for the Data Source Name and type in or type the directory structure.

5. Make sure there is no 'default login'.

6. Select 'Create'