The Advanced Form Handling can use a database
to store the response and allow you to view, edit and
otherwise manipulate the responses. Advanced Form Handler uses
an ASP file called config_database.asp to tell AFH these
things:
- The name of your database
- The location of the
database
- The type of database
- For SQL Server and MYSQL it also requires: userid,
password and server location
AFH supports three types
of databases. Access database which is supplied and called
afh300.mdb. SQL Server database and a MYSQL database.
For
more details download the User's Guide.
Database Configuration
Edit file config_database.asp with a plain text editor
such as notepad and change the values depending on the
database you are planning to use.
Setting up Access
Database
An Access database is the simplest type of
database to use but it is recommended only for small volumes.
Sample settings in config_database.asp are shown but form more
information see Database
Help
| config_databasename="afh300.mdb" |
This is the name of the
database. It is supplied as afh300.mdb but it can be
called anything you choose. |
| config_databaseType="Access" |
The type of database. Use
"Access" for any Access database. |
| config_databaselocation="c:\mywebserverfolder" |
This is the location where
the database is located. Most web hosting companies will
provide a separate folder. Place afh300.mdb into that
folder and put the path to the folder. |
Setting up SQL Server Database - Step 1
SQL Server
database is Microsoft's high volume database server. The
set-up for SQL Server involves three steps. First contact your
web hosting company and verify that you can use SQL Server and
get the following details:
- SQL Server database name
-
SQL Server Server Name such as xxxhost.com
-
SQL Server userid
-
SQL Server Password
Edit file config_database.asp and put those values
| config_databasename="nameofdatabase" |
This is the name of the
database. Your web host will provide this. |
| config_atabaseType="SqlServer" |
The type of database. Use
"SQLServer" for any Sql Server database. |
| config_databaseuserid="uuuu" |
The userid allows to
read/write this database. |
| config_databasepassword="ppppp" |
Password |
| config_databaseserver="xxxhost.com" |
The location of the actual
SQL Server. This is provided by web host. |
Setting up SQL Server Database - Step 2
The next
step is to have Advanced Form Handler actually create the
necessary tables in your database. From your browser start the
utility createdatabasetables.asp. It will build the necessary
tables in your SQL Server Database.
Setting up MYSQL
Database - Step 1
MYSQL Server database is database
supplied by some web hosting companies. The set-up for MYSQL
involves three steps. First contact your web hosting company
and verify that you can use SQL Server and get the following
details:
- MYSQL database name
-
MYSQL Server Name such as xxxhost.com
-
MYSQL userid
-
MYSQL Password
Edit file config_database.asp and put those values
| config_databasename="nameofdatabase"
|
This is the name of the
database. Your web host will provide this. Some web
hosts provide tools to create the MYSQL database. In
that case you can select your own name |
| config_databaseType="MYSQL"
|
The type of database. Use
"MYSQL" for any MYSQL database. |
| config_databaseuserid="uuuu"
|
The userid allows to
read/write this database. |
| config_databasepassword="ppppp" |
Password |
| config_databaseserver="xxxhost.com" |
The location of the actual
MYSQL Server. This is provided by web host. In many
casess it is "Localhost" |
Setting up MYSQL Database - Step 2
The next
step is to have Advanced Form Handler actually create the
necessary tables in your database. From your browser start the
utility createdatabasetables.asp. It will build the necessary
tables in your SQL Server Database.
Database Administration
After configuring your database, you can
login to the administration.
To login to the database administration use file:
afhadlogon.asp.
The Userid is admin
The Password is admin
