FIX: ODBC Driver Cannot Execute sp_helpalert Without Params

ID: Q135838

The information in this article applies to:

Microsoft SQL Server, version 6.0
Microsoft Open Data Base Connectivity, version 2.5

BUG#: 11235 (6.00)

SYMPTOMS

When you execute the following two statements with the ODBC version 2.50.0121 driver,

    1. use msdb
    2. sp_helpalert

an incorrect error message results:

   SQLExecDirect:
   In:hstmt=#1 0x00461000, szSqlStr=VALID, cbSqlStr=-3
   Return:   SQL_ERROR=-1
   stmt: szSqlState = "S0022", *pfNativeError = 207, *pcbErrorMsg = 71
   szErrorMsg="[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
   column name '%'."

WORKAROUND

Use ISQL/W to perform this task and avoid the error.

STATUS

Microsoft has confirmed this to be a problem in the ODBC SQL Server Driver version 2.50.0121. This problem has been corrected in the ODBC driver for SQL Server 6.5. For more information, contact your primary support provider.

Additional query words: sql6

Keywords          : kbprg SSrvProg kbbug2.50.0121 kbbug6.00 
Version           : 2.5.0121 6.0
Platform          : WINDOWS

Last Reviewed: May 2, 1997