Uploading to a Database on the Server
Setup Instructions
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 free from http://www.microsoft.com/data. 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.

Database "Upload.mdb" and "Upload.SQL" Samples - *Located on root of samples
Upload to Database: (Simple, Intermediate, Filename ) , Download From Server: (Simpledatabase),  and
File Manager Importing/Exporting Database Blobs: (Import,Export)

We supply a sample Access Database as well as SQL Server Scripts that will create tables that you can use for file uploading.

Setup Instructions for Access:

  1. Find the UPLOAD.MDB file contained in the same directory as this file.
  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 same directory as this file.
  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

Setup Instructions for Oracle:

Creating the tables

  1. Use the Oracle Schema Manager to create two new tables named "SimpleBlobTable", and "IntermediateBlobTable".
  2. In each table create a column named "ID" with a datatype of "NUMBER (7,0)", set as the primary key.
  3. In each table create a column named "FILECOL", with a datatype of "LONG RAW".
  4. In the "IntermediateBlobTable" table create columns named "Author" and "Descrip" with datatypes of VARCHAR(50).
  5. The "LONG RAW" data type was tested with Oracle 7 & 8, Oracle reccomends using the "BLOB" data type in new applications.

Use SQL*Net Easy Configuration tool to create an alias for the server you wish to access if it has not been done
already. Refer to Microsoft KB Article Q193225, for more information.

Creating the DSN

  1. Using the Control Panel, Open the ODBC Data Source Administrator
  2. Click on the "System DSN" tab.
  3. Select "Add..."
  4. Select "Microsoft ODBC for Oracle Driver "
  5. Click on "Finish"
  6. Enter a Data Source name of "OracleUpload"
  7. Enter the User name (such as SYS) to access the database
  8. Enter the SQL*Net server alias for the server you want to access
  9. Click on "OK" and your database is ready to use.

 

Database "docmgmnt.mdb" Samples - *Located within Samples\applications\Docmanager\database
Sample Application: (Advanced Document Manager)

  1. Find the UPLOAD.MDB file contained in the same directory as this file.
  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 "docmgmnt"
  8. Click on "Select..." and navigate to the location of the docmgmnt.MDB file.
  9. Click on "OK" and your database is ready to use.

Copyright © 2002 SoftArtisans, Inc. All rights reserved.