This project is a basic web application that demonstrates the integration of VBScript with SQL. It includes ASP pages for CRUD operations and a SQLite database.
- add.asp: Handles adding new entries to the database.
- company.db: SQLite database file.
- default.asp: Main page displaying the data.
- delete.asp: Handles deletion of entries.
- edit.asp: Handles editing existing entries.
- init.sql: SQL script to initialize the database schema.
- README.md: Basic readme file.
- styles.css: Stylesheet for the web application.
- web.config: Configuration file for the web application.
-
Setup Environment:
- Ensure you have a web server supporting ASP (e.g., IIS).
- SQLite should be installed if not included in your environment.
-
Database Initialization:
- Run
init.sqlto set up the initial database schema. This script creates the necessary tables.
- Run
-
Deploy Application:
- Place the files in the web root directory of your server.
- Ensure the database file
company.dbis writable by the web server process.
- Add (add.asp): Form to input new data. Submits to
add.aspfor processing. - Edit (edit.asp): Form pre-filled with existing data. Submits to
edit.aspfor updating the entry. - Delete (delete.asp): Processes deletion of entries.
- Display (default.asp): Lists all data entries from the database.
- web.config: Contains necessary configurations for running the ASP application. Ensure this file is correctly set up to handle your environment specifics.
- styles.css: Customize the appearance of the web application. Modify this file to change the look and feel.
-
ODBC Driver Installation:
- http://www.ch-werner.de/sqliteodbc/sqliteodbc_w64.exe
- Working DSN connection string:
conn.Open "DSN=SQLite3 Datasource;Database=C:/path/to/vb-script-sql/company.db;"
-
Check System DSN:
run | control admintools- ODBC Data Sources (64-bit)
- System DSN