Q135838 - FIX: ODBC Driver Cannot Execute sp

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,

use msdb

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