================(Build #2088 - Engineering Case #799815)================
The 17.0 SQL Anywhere database server has made PROCEDURE_OWNER a reserved
word. For 17.0.0, the ODBC driver was changed to adapt to this new feature.
As of build 2000, the query used by the driver for the ODBC 2.0 version of
SQLProcedures did not quote the column name PROCEDURE_OWNER resulting in
a syntax error. Any ODBC application that used SQLProcedures and runs in
ODBC 2.0 mode will fail.
For example, this problem will cause ADO applications that use MSDASQL (the
ODBC driver interface) which operates in ODBC 2.0 mode to fail. The following
sample VBScript code illustrates the problem:
command.CommandText = “sp_proc”
command.CommandType = adCmdStoredProc
command.Prepared = True
WScript.Echo "Parameters Count: " & command.Parameters.Count
If the stored procedure sp_proc has 3 parameters, the Parameters.Count value
returned was 0, not 3 as it should. ADO did not indicate that an error has
occurred.
This problem has been fixed.
A work-around until the corrected version can be installed is to use a 17.0
ODBC driver prior to build 2000.
|
Thank you very much for providing this information. That is the exact version that I have so I will try to upgrade.
Thanks,