Using PHP with Datadirect Connect ODBC Drivers - Windows

Download the PDF

A common PHP configuration in Windows environments uses IIS 5.1, PHP 5.1, and Microsoft SQL Server 2005. The following table lists sources for acquiring the necessary software:

PHP 5.1

http://www.php.net/downloads.php

IIS 5.1

Included in Windows distributions

Microsoft SQL Server 2005

http://www.microsoft.com/sql

DataDirect Connect for ODBC

http://forms.progress.com/forms/driverdownload

Install DataDirect Connect for ODBC

Install the DataDirect Connect for ODBC drivers. Fifteen-day evaluation copies are available at http://www.progress.com/products/datadirect-connect/odbc-drivers/odbc-developer-center/odbc-product-documentation.

Follow the instructions in the DataDirect Connect and Connect XE for ODBC User's Guide for configuring a data source through the ODBC Administrator.

Install IIS 5.1 and Microsoft SQL Server 2005

Install IIS 5.1 and Microsoft SQL Server 2005 on your system. Consult www.microsoft.com for IIS and Microsoft SQL Server 2005 installation instructions. No modifications are necessary to work with PHP and DataDirect Connect for ODBC.

Install PHP 5.1

Install PHP 5.1 on your system. When you install PHP 5.1 with IIS, we strongly recommend that you use the ISAPI module method described at http://www.php.net/manual/en/install.windows.iis.php. After PHP 5.1 has been installed and configured, the next step is to verify that ODBC support is included by examining the output of a phpinfo() function inside of a PHP script:

<?php phpinfo(); ?>

If ODBC support is included, the output of the phpinfo() function will include an ODBC section with the following settings:

ODBC Support

Enabled

Active Persistent Links

0

Active Links

0

ODBC Library

Win32

Note that ODBC support is included by default in the binary distributions of PHP.