Kbase P90229: ODBC error "Optional feature not implemented" when connecting to Progress database via ASP/Visual Ba
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/6/2009 |
|
Status: Verified
SYMPTOM(s):
ASP/Visual Basic using ODBC to connect to Progress database
ODBC error is returned when trying make connection
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[DataDirect-Technologies][ODBC PROGRESS driver]Optional feature not implemented.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[DataDirect][ODBC OPENEDGE driver]Optional feature not implemented.
ODBC Trace files contains the following messages:
DIAG [S1C00] [DataDirect-Technologies][ODBC PROGRESS driver]Optional feature not implemented. (0)
DIAG [S1000] [DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Access denied(Authorisation failed) (-20228)
DIAG [IM006] [DataDirect-Technologies][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed. (0)
Runtime error code -2147467259 is reported by ASP/VB
Test Connect from Data Source Administrator succeeds
SQL-92 user has been created
SQL-92 user has been granted appropriate permissions to access the database
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
Windows
MERANT 3.60 32-BIT Progress SQL-92
DataDirect 4.20 32-Bit OpenEdge SQL92 10.0A
CAUSE:
Incorrect user credentials are being passed to the database via the ODBC connection. In ASP/VB, username and password used for the connection are contained within the code itself and must therefore be checked in addition to the ODBC DSN. The problem is highlighted by the "Access denied(Authorisation failed)" error message in the ODBC Trace log.
FIX:
Check code to ensure that the correct username and password are being used