Back to navigation bar    Setup and Introduction

Setup ASPdbDesigner

ASP-dbDesigner will work with all versions of Classic ASP-db. You'll need a valid ID file (_ASPDB2001.ID) to eliminate the restrictions. Contact your agent to update your 2001 ID file and purchase a maintenance contact if needed.

Create a desktop shortcut for ASP-dbDesginer and fill in the command line parameters as follows (optional) -

Desginer2001.exe  CodeBase, HelpURL, httpDir, PhysicalDir, DesignerFileDir, TemplateDir, ImageDir, ASPDB.IncDir

CodeBase - Java CodeBase directory - A virtual directory pointing to the the directory just above the Jars directory. This directory is usually the ASPDB directory. Defaults to "http://localhost".

HelpURL - Path to local the ASP-db2000 help files. These files are only available to the paid users. The free and eaval users will be linked to the aspdb web site to access the help files.

httpVirtualPath - In order to execute the asp file, it must be in a virtual directory. This parameter is the virtual directory corresponding to the httpPhysicalPath. Default is the system's IIS virtual root.

httpPhysicalPath - ASP-dbDesigner generates an asp file when the "code" or "preview" buttons are clicked. This asp file will be deposited into this physical directory.  Default is %systen32%\scripts\temp.asp.

DesignerFileDir - Path to locate the .des file. ".des" files holds the parameters of the Designer session. Defaults to CurDir().

TemplateDir - Physical Path of ASP-db2000 Template files. Defaults to CurDir().

ImageDir - HTTP path of ASP-db image directory (dbImageDir). Defaults to CurDir().

ASPdb.Inc - ASPdb.Inc include file (Virtual or File) path. Defaults to "/ASPDB/"

Note that the command line parameters are separated by (commas) and the sequence corresponds to the System Paths box. 

Example: Designer2001,,,,d:\inetpub\wwwroot\aspdb\datafile,,,/ASPDB/

Property type - Single Repeated action

There are two types of properties - Single action and repeated action.

A single action is a property that is stand alone like the Title of a chart, dbUnit, dbType etc. This type of data is usually entered via selection of various listboxes, buttons, checkboxes or input to a textbox. Once the data is entered, no further actions are required.

The repeated action type properties are those composed of repeated sets of data. An example is the MagicCell, DropFields, EditFields[Defaults] etc. Besides entering the individual data, you need to build up the property via an "Add" button. The Build Panel usually displays the properties in an easy to understand format. Upon hitting the "Code" or "Preview" button, the display will be converted to the "Packed" ASP-db code. Users have the option to modify the Build Panel directly.

Introduction - Easy Start

The following are the easy steps to publish your first database -

  1. Make sure your IIS and ASP is running properly. Run an ASP file to check it out.
  2. Install the ASPDB.DLL, ID File and the Designer. See ASPDB Installation.
  3. Fire up Designer and click Menu Help/Support. You'll see all the metrics.
  4. Click the button and read the message. Click OK to perform the test. If you see the ADO version in the IE control then everyting should be ready to roll.
  5. Define an ODBC data source for Northwind.
  6. Click the Connection Tab and choose Access database, ODBC DSN.
  7. Click the "Build dbDSM" button and then pick a table. All the fields will show.
  8. Select some fields and click the "Right Arrow".
  9. Click and the Northwind database will be published.