Kbase P133644: SQL: The OpenEdge ODBC driver does not return version in a format according to ODBC standards.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/25/2008 |
|
Status: Unverified
SYMPTOM(s):
SQL: The OpenEdge ODBC driver does not return version in a format according to ODBC standards.
The ODBC SQLGetInfo function returns the SQL_DBMS_VER information type as ''10.1B03'', ''10.1C01'', etc.
The ODBC standard specifies the value returned by the ODBC SQLGetInfo function for the SQL_DBMS_VER ODBC information type should be in the form ##.##.####, where the first two digits are the major version, the next two digits are the minor version, and the last four digits are the release version
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
The Progress version naming convention uses letters instead of numbers. Thus, the ODBC driver provides the application with a version that is a meaningful Progress version and the ODBC SQLGetInfo function returns the SQL_DBMS_VER information type as ''10.1B03'', ''10.1C01'', etc.
FIX:
The OpenEdge ODBC driver works as designed. The ODBC SQLGetInfo function returns the SQL_DBMS_VER information type, that is the database version, using the OpenEdge version naming convention.