User Guide

Table of Contents

i!-Database Plus and DBWizard

Table of Contents

Introduction ...............................................................................................................1

i!-DatabasePlus ................................................................................................................. 1

DBWizard .......................................................................................................................... 1

Supported Operating Systems .......................................................................................... 1

Minimum PC Requirements .............................................................................................. 2

Installing i!-Database Plus................................................................................................. 2

Installing DBWizard ........................................................................................................... 2

Setup ................................................................................................................................. 3

Programming i!-Database Plus ...............................................................................5

Data Source Name............................................................................................................ 5

Structure Query Language (SQL) ..................................................................................... 5

HTTP, CGI and XML ......................................................................................................... 6

HTTP (Hyper-Text Transfer Protocol) ...................................................................................... 6

CGI (Common Gateway Interface)........................................................................................... 6

XML (Extensible Markup Language)........................................................................................ 7

Creating an ASP file .......................................................................................................... 9

Creating an AXI file ........................................................................................................... 9

Creating an AXS file ........................................................................................................ 15

NetlinxDBInclude.asp ...................................................................................................... 18

Functions................................................................................................................................ 18

NetlinxDBInclude.axi ....................................................................................................... 20

Constants ............................................................................................................................... 20

Variables ................................................................................................................................ 20

Structures .............................................................................................................................. 21

Functions................................................................................................................................ 22

Putting It All Together...................................................................................................... 28

Running DBWizard .................................................................................................29

File Menu......................................................................................................................... 29

Database Tab.................................................................................................................. 29

Queries Tab..................................................................................................................... 30

Sorting ............................................................................................................................. 30

File Tab ........................................................................................................................... 31

ASP file .................................................................................................................................. 31

Webserver host name or IP address...................................................................................... 31

Webserver IP port .................................................................................................................. 31