You can choose either a local or remote database to connect and build your pages!
NOTE: Access will only show up for the ASP version and for the FULL version
Access Database (DSNless): Click on the "LOAD DB FILE" button and then just select your Microsoft Access database from your local hard drive. If you have a local copy of your Access database (very common), locate it now, the same way you locate a project file (see Loading Projects). Choose the drive letter and folder name that contain the database file and then click on the database file to select it. You will be connected to your database.
If your database will not be in the same folder that you will be generating your files in, you must supply the database path. The database path will represent where the database is going to be in relation to your generated files on the server. Example if you propose to create a folder called data and store the database there on the server but you propose to store your project files in a folder called myproject then you would type the following in the database path box (../data). The two dots tell the server to move up one folder and then the /data tells the server which folder to move down into.
Access Database (DSN): If you are using a DSN then you will still have to load a local copy of the Access database so that ASaP can connect and build your project. Once you have loaded the local file then simply click on the "USE DSN" button, enter the DSN name along with the user name and password. Your Internet Service Provider will need to setup this DSN on the server so that the generated pages can connect to the database once they have been uploaded.
MySQL: If you are working with a MySQL database use the following steps:
NOTE: MySQL will only show up for the PHP version and for the FULL version
SQL Server: There are two different ways to configure your generated pages in a SQL Server environment. The first scenario you would be using a DSN connection on the server. The second scenario is where you be using a DSNless connection on the server. In both scenarios you will need to create a local DSN so that ASaP can connect to the SQL Server in order to build the pages. New in version 3.1.20 we have added the ability to open the DSN Manager within ASaP so that you can configure your local DSN. Simply click on the DSN Manager button and then configure your DSN as you would do normally. For more information see the DSN section. See below for details involving both methods.
NOTE: SQL Server will only show up for the ASP version and for the FULL version
SQL Server using DSN connection
This method is used when you Internet Service Provider has setup a DSN for you on the server which refers to your SQL Server database. In this scenario enter the following:
SQL Server using DSNless connection
This method is used when you Internet Service Provider has not setup a DSN for you on the server but instead has given you just a username and password. In this scenario you would check the DSN-less Connection box and then supply the additional information:
For more information regarding specifying fields see the Quick Start section.