IBMlogo
IBM eNetwork Communications Server for Windows NT
Host Publisher Feature, Version 6.01
[Next|Previous|Contents]

Host Publisher Hints and Tips

Configuring and Testing ODBC

Using the ODBC sample requires some additional configuration.

Access Drivers

If you do not have Microsoft Access ODBC drivers installed, install them first.

The drivers are installed with some Microsoft products such as Developer's Studio, Excel, and Access. If you think you might have them installed, continue with the next section. If the Create New Data Source window does not offer Microsoft Access Driver as an option, return here to install Access drivers.

The file dataacc.exe comes with Microsoft Outlook 98, Office 97 and the Office 97 products in the Valupack folder on the CD. It installs Access drivers.

You can download Access drivers from Microsoft's Web site. When this document was written, Access drivers were available at http://www.microsoft.com/outlook/enhancements/dataacc.asp. They could also be found at http://www.microsoft.com/data/download.htm by following the link to the latest Microsoft Data Access Components release.

If access drivers are not currently available from these web sites, visit the main Microsoft Web site and search for the drivers. Search for "Access ODBC drivers" or a similar string.

Follow Microsoft's instructions for installing the Access driver.

ODBC Configuration

On Windows NT, open the Control Panel and double-click on ODBC.

Click the System DSN tab to change to the second page.
Screen shot

On the second page (System DSN), click the Add button.
Screen shot

Select the Microsoft Access Driver and click Finish.
Screen shot

In the ODBC Microsoft Access Setup panel, fill in the Data Source Name as query. Under Database, click the Select button.
Screen shot

Navigate to the Samples\ODBC directory under the Host Publisher directory, and select query.mdb. Click OK repeatedly to exit the ODBC administration windows.

Testing ODBC

Start the Integrator and open the sample WBL ODBCQry.WBL. Select the Employee Input Web page, change to the Preview mode, and fill in the employee name Kelly Allen as suggested.
Screen shot

Click on the Search button and you should see that Kelly Allen's Employee ID is 1812.
Screen shot


[Next|Previous|Contents]
IBM eNetwork Communications Server for Windows NT
Host Publisher Feature, Version 6.01