SA-FileUp Samples
Uploading to a Database on the Server
Setup Instructions
We supply a sample Access Database as well as SQL Server Scripts that
will create tables that you can use for file uploading.
Note: We highly recommend using Microsoft MDAC 2.0 or later
if you intend to perform significant database BLOB (Binary Large OBject -
i.e. a file) manipulations. MDAC is available for free download from
http://www.microsoft.com/data
for IIS 3 and IIS 4. MDAC encompasses all previous Microsoft data
components such as ADO, OLE-DB, and the latest ODBC drivers. In our
experience it is much reliable for BLOB manipulations than earlier versions
of ADO.
Setup Instructions for Access:
- Find the UPLOAD.MDB file contained in the same directory as this file.
- Using the Control Panel, Open the ODBC Data Source Administrator
- Click on the "System DSN" tab.
- Select "Add..."
- Select "Microsoft Access Driver (*.MDB)"
- Click on "Finish"
- Enter a Data Source name of "AccessUpload"
- Click on "Select..." and navigate to the location of the
UPLOAD.MDB file.
- Click on "OK" and your database is ready to use.
Setup Instructions for SQL-Server:
- Find the UPLOAD.SQL file contained in the same directory as this file.
- 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.
- From a command window, create the necessary tables in your database.
For example:
C> isql -d <mydatabase> -i upload.sql -Usa -P
- 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".
- Comment out the Access-based rsBlob.open
- Un-comment the SQL Server-based rsBlob.open
Back to the samples page
Copyright © 1997, 1998, 1999 Software
Artisans, Inc.