|
Data Source Setup
Start with the Data Source Setup
by clicking the 
Database tab.
1. Microsoft Access Setup
- Check "Microsoft Access
Database"
- Load the Microsoft Access Database
File Name by clicking the button
to select the desired database file
- Check "Use Server.MapPath"
if you want relative path to be used in the ADO Connection. Please also specify
the path name if the database is located at a subfolder from the root.
- Enter the ColdFusion data source name you setup in ColdFusion Administrator for the database.
- Click the
Connect button to load the database information.
2. ODBC Data Source information
- Check "ODBC Data Source"
- Load the ODBC Data Source Information
by selecting from the list of ODBC Data Source available. You may need to
create the necessary dsn if it does not exist by clicking the button
 .
You may also need to set up the "User ID" and "Password"
fields if necessary.
- Enter the ColdFusion data source name you setup in ColdFusion Administrator for the database.
- Click the
Connect button to load the database information.
3. Connection String
- Check "Connection String"
- Enter your connection string or click the "..." button to
build the connection string using the Microsoft Data Link Properties form. Remember to check "Save password" or your password will not be inlcuded in the connection string.
- Enter the ColdFusion data source name you setup in ColdFusion Administrator for the database.
- Click the
Connect button to load the database information.
4. Load from CMP Project
File
Click the
open button on the tool bar (or select "Project", "Open"
from the menu bar) to load from an old CMP File
saved previously. Alternatively, you can simply double click your CMP file to open it with CFMMaker.
5. At completion, the tables
and fields information will be loaded and displayed on the left hand side.
| 
