SA-FileUp Samples

Uploading to a Database on the Server

Setup Instructions

As part of the distribution of SA-FileUp, we provide a sample Access database. We also provide SQL Server Scripts that create tables that you can use for file uploading. You'll find the sample database and scripts in the Samples directory.

Setup Instructions for Access:

1. Find the UPLOAD.MDB file contained in the Samples directory.
2. Using the Control Panel, open the ODBC Data Source Administrator.
3. Click on the "System DSN" tab.
4. Select "Add...".
5. Select "Microsoft Access Driver (*.MDB)".
6. Click on "Finish".
7. Enter a Data Source name of "AccessUpload".
8. Click on "Select..." and navigate to the location of the UPLOAD.MDB file.
9. Click on "OK" and your database is ready to use.

Setup Instructions for SQL-Server:

1. Find the UPLOAD.SQL file contained in the Samples directory.
2. Ensure that you have a properly configured System Datasource using ODBC Data Source Administrator or ensure that you have a database that is accessible from IIS.
3. From a command window, create the necessary tables in your database. For example:

   C> isql -d <mydatabase> -i upload.sql -Usa -P
     

4. Modify the samples to use the SQL Server database rather than Access. There are two files to be modified: "UploadToDatabase\Simple\formrespdb.asp" and "UploadToDatabase\Intermediate\mformrespdb.asp". In both files, look for the string beginning "For SQL Server Users".
5. Comment out the Access-based rsBlob.open
6. Un-comment the SQL Server-based rsBlob.open

Back to the samples page