Kbase 21029: Can't Connect to the Progress DB Using ASP Pages from SQL-89
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
SYMPTOM(s):
Error connecting to database with an ASP page:
Error in SQL.LOG (sql trace): "Optional feature not implemented".
Using 3.60 Merant ODBC Driver
Err.Number = -2147467259 Conntemp.Errors.Count = 3[MERANT]
[ODBC PROGRESS driver]PROGRESS error returned with no associated
message: RC = -1, SQLCODE = -1, SQLSTATE = "".[MERANT]
[ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed."
Test Connect works from the ODBC Data Source Administrator.
CAUSE:
The environment variables required for ODBC are not set properly.
FIX:
Since 3.60 Merant's ODBC driver is used, it is SQL-89. For SQL-89, following are required environment variables that need to be set up as system variables on the server side, are listed below:
DLC
IDLC
PROMSGS
IPROMSGS
PROOIBRK
PROOIDRV
Please set the above environment variables as system variables.