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 Database Connectivity, version 2.5


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 : WINDOWS:2.5; winnt:6.0
Platform : WINDOWS winnt
Issue type :


Last Reviewed: December 14, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.