Kbase 18933: How to Set Progress ODBC Environments For Microsoft IIS
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/22/2003 |
|
Status: Unverified
GOAL:
How to Set Progress ODBC Environments For Microsoft IIS
GOAL:
Setting environment variables to enable Progress database access via ODBC
from the Web
FIX:
The recommended approach to access data from a Progress database via the web is with WebSpeed or Apptivity. However, there are other methods available. One such method is to write a CGI program that accesses a Progress Database via ODBC.
In order to connect via ODBC to Progress, it is necessary to set some environment variables. This is covered in other solutions specific to the ODBC driver being used.
When using IIS, and running the ODBC program from CGI, the necessary environment variables are not always set. When IIS creates the environment to run the CGI command, it sets up the necessary CGI variables, plus a few more variables. Even if the Progress ODBC environment variables are set up in the system environment on NT, these will not necessarily be copied to the CGI environment created by IIS. This will result in Progress error messages, indicating the environment is not properly set for the ODBC connection.
The way to set these environment variables is to create STRING KEYS in the registry under:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\W3SVC\Parameters.
Create DLC with the value "<Progress install directory>".