Creating a database
Here we make an example database using Microsoft Access.
The database contains:
Person First Name
and
Person Last Name
We set the field Person_ID as Primary Key.
| Field Name | Data Type |
| Person_ID | AutoNumber |
| Person_First_Name | Text |
| Person_Last_Name | Text |
Name the table "person" and save the database as "person_db.mdb".
Open Coldfusion Server Administrator.
Select Data Sources
Type persondb in the Data Source Name field
Select Microsoft Access as Driver
and click on Add button.
Select Browse Server and find the person_db.mdb.
Click on Apply, on the next screen click Submit.
If you have done everything correct you get the message datasource updated successfully.
Close ColdFusion Server Administrator.
Follow this link to see an animated tutorial how to add and manage your data source connections and Data Source Names (DSNs).
We are going to use this database to:
-
Insert data
-
Delete data
-
Update data
-
List data
-
Sort data
-
Search data
Advertisement
No User Comments.
No User Comments, be the first one to write your comments?
