ASPRunner Professional is an Active Server Pages (ASP) code generator that creates a set of ASP pages to access and modify Oracle, SQL Server, DB2, MySQL and MS Access databases, or any other ODBC database.

This is step-by-step tutorial that will help you to build your first set of ASP pages quickly. Hit Help button if you need more information during process. Run ASPRunner application (after you installed in on your box it can be found at  Start -> Programs -> ASPRunner Professional -> ASPRunner Professional)
Skip welcome message and go to the database connection screen.

Choose your database type and click Next. If you cannot find your database in the list, choose ODBC driver dialog (make sure that you installed ODBC drivers for your database in this case).

If you connect to file-based database (Access, Excel, DBF) you can use Use Server.MapPath option (recommended). If you choose this option relative path to be used in the ADO Connection and you don't need to setup ODBC DSN pointing to your database on the Web server. Please also specify the path name if the database is located at a subfolder from the root.

On the next screen select datasource table from the list of available tables and click Next. On the next screen you can modify SQL query and make some settings.

Note: Key column is the datasource column which lets you query each table row individually and modify each row without altering other rows in the same table. The values that compose a key column a unique; no two values are the same.

After you chose key field you will be able to choose fields to appear on each page.
On the next pages you can customize your data appearance and set fields order on each page. Security screen allows you to protect an access to your database with ASPRunner.

You are almost finished! Select output directory where you like to put generated ASP pages and image files.

Press Finish on the last page to generate files. You are done!

What to do now? To test generated pages locally you need to run Internet Information Server (Windows NT, 2000, XP) or Personal Web Server (Windows 98). Open Internet Services Manager and create virtual directory named ASPRunner. Point this directory to that output directory that you choosed in ASPRunner. Now open you Internet browser and point it to: http://localhost/ASPRunner/TABLE_NAME_list.asp (replace with your actual datasource table name).
Here is the sample generated page preview:

 Back to top