	Documentation
	Getting Started
	New Features
	Component Guide
	Programming

	User Guide
	Supported Platforms
	Windows 95
	Windows 98
	Windows NT
	PWS
	IIS2.0/3.0
	IIS4.0
	ISAPI
	Website
	FastTrack
	Other Web server
	ODBC
	MS Access
	MS SQL Server
	dBase
	Paradox
	InterBase
	Linux
	FreeBSD
	Solaris
	BSDI
	Apache
	Postgres
	MySQL
	ADABAS
	Generic
	Trademarks
	Installation
	Configuration
	RADpage
	Debugging
	Migrating heitml 1
	Maintenance

	Registration


	Frame

Supported Platforms

ODBC

General

heitml accesses the database using the 32-bit ODBC drivers. Many database systems are actually delivered together with 32-bit ODBC drivers, e.g. Microsoft Access^TM version 95, 97 or 2000.

Downloading of ODBC 32-bit drivers

If you do not have these drivers you may find them either

shipped with the latest Microsoft OfficeTM distribution,
shipped with the latest Microsoft Data Access Components (MDAC) distribution,
or shipped with the latest MERANT DataDirect distribution.

Creating Data Sources

To access a database from heitml you must create a data source. The data source must have a unique name. This name has to be specified in the heitml.ini file as the datasource parameter. The data source for the demo application is named "heitml2.0". To create it and to link it to the file \htdocs\heitml2.0\tutor\heitml.mdb in the heitml installation directory perform the following steps:

Click on Start, then Settings, then Control Panel.
In the Control Panel, find the '32-bit ODBC' icon and double-click on it.
In the 'ODBC Data Source Administrator' window, click the 'System DSN' tab.
Now click on the 'Add' button.
Click on the entry 'Microsoft Access Driver (*.mdb)' or the entry with the driver of your favorite database system to highlight it and then click 'Finish'.
In the window coming up, enter "heitml2.0" as the Data Source Name and provide further database specific information. In the case you selected the MS Access^TM ODBC Driver:
1. Click the 'Select' button
2. In the Select Database window, first select the Drive where you installed heitml and then select the 'heitml2.0' directory folder (If you installed heitml under a folder other than the default name 'heitml2.0', choose that folder instead.) Look for the file in the \htdocs\heitml2.0\tutor directory called heitml.mdb and click on it to highlight it. Then click OK, which closes the 'Select Database' window.
3. In the 'ODBC Microsoft Access Setup' window click OK to close it.
In the 'ODBC Data Source Administrator' window click OK to close it.

Note that this is the setup procedure for creating an ODBC system data source with the ODBC 3.5 administrator. The setup procedure for creating an ODBC System data source with the ODBC 2.5 or 3.0 administrator is nearly the same.

If your database system requires user authentication (like MS SQL Server^TM), setup a user 'heitml' with password 'heitml' for the database you are going to access through the ODBC data source "heitml2.0" and grant appropriate permissions.

Thread-safe ODBC 32-bit drivers

In a multi-threaded application like an ISAPI compliant Web server, the ODBC driver must be thread-safe. At the time of this writing, all ODBC drivers based on the Microsoft Jet database engine like the Microsoft Access^TM driver are not thread-safe, the Microsoft SQL Server^TM, Oracle and Visual FoxPro ODBC drivers are thread-safe. For more information, see the dbserialize configuration option.