Kbase P102393: VB 6 program using ODBC gets error when run under COM+
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/03/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
DataDirect 4.1 32-Bit Progress SQL92 9.1D
DataDirect 4.10 32-Bit Progress SQL92 9.1E
SYMPTOM(s):
Visual Basic 6 program uses ODBC to talk to Progress Database
When run from a command prompt the program works properly
When run as a COM+ program the program fails
DIAG [SC100] [DataDirect][ODBC PROGRESS driver]Optional feature not implemented. (0)
DIAG [IM006] [DataDirect][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed. (0)
CAUSE:
When run under the COM+ environment extra ODBC calls are made by ADO to implement things which are optional in ODBC (i.e. login timeout) and this results in the optional feature not implemented error
FIX:
Do not run under the COM+ environment