Home
dbPix
Download
Order
Testimonials
Support
Tutorials
Samples
KnowledgeBase
Links
Revision History
Documentation
Search
Contact
Site Map

Graph: dbPix image storage vs OLE Embedding and Linking in Microsoft Access


ASP Image Database - Browser Edit/Update/Upload with XMLHTTP

This sample builds on the functionality of the simple ASP Publishing samples by supporting in-browser web-based editing/updating of a remote image database.


Download Sample   1 MB (Requires DBPix)

Download DBPix  3.7 MB ( About DBPix )


Screenshots

sample screenshot - ASP Image Database - Browser Edit/Update/Upload with XMLHTTP
Summary
sample screenshot - click to enlarge
Detail
sample screenshot - click to enlarge
Edit
sample screenshot - click to enlarge

System Requirements

Server
IIS 5.0 or later (Windows 2000 or later). 
OLEDB 4.0 Jet drivers (MDAC 2.1 or later, 2.5 or later recommended).

The database is supplied in Access 2000 format, but Access is not required to use the sample.

Client - Viewing
Any web browser.

Client - Editing
Internet Explorer 4.0 or later (5.0 or later recommended).
DBPix Image Control version 2.0 or later (installed automatically if not already present).

Installation

Unzip the file into a new folder on your IIS web server, ensuring that the directory structure is reproduced. 

Check that the database (.mdb) file is writable by web users (for testing give 'everyone' write permissions if in doubt). 

Ensure that the IIS configuration allows script access to the top-level folder. 

Walkthrough

Connect to your web-server at the url corresponding to the installation drectory.
A list of items is displayed, with a thumbnail and some textual data for each one.
Click one of the images to display the high resolution image.
Go back to the first page and click 'Edit'. On the Edit page click 'Load' to select a new image from the filesystem, then click 'submit'. You are taken back to the first page, which shows the updated item.


Files & Code

File / module Description  

default.asp Displays a page of items with thumbnails. View Code
item_detail.asp Displays an item's 'detail' vew with large image. View Code
item_edit.asp Form for editing a record/image. View Code
item_submit.asp Submits changes to the database (from item_edit.asp). View Code
getimage.asp Returns an image from the database for display. View Code
get_item_atg.asp Fetches a record for editing (ADTG format). View Code
get_item_xml.asp Fetches a record for editing (XML format). View Code
adovbs.inc ADO constants include file for VBScript. View Code
config.inc Configuration file with connection strings. View Code
common.inc Common asp code (eg photo border). View Code
readme.htm This file.  



Revision History

Date Filename Description

24 Sep 2008   xmlasp-v2   Updated to fix a connection problem on newer versions of IIS. Simplified and improved code.


000000000000000000000000000000000000000000000000000000000000000000000