Microsoft KB Archive/135838

{|
 * width="100%"|

FIX: ODBC Driver Cannot Execute sp_helpalert Without Params

 * }

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 : kbprogramming

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600 kbODBCSearch kbODBC250