SQL Server Wire Protocol driver does not return error message if one among multiple statements fail to execute.

When Multiple Statements are run together. If one of the statement had failed with error, the driver does not return any error, Rather says that the query succeeded.

Aug 21, 2018
Knowledge

Title

URL Name

sql-server-wire-protocol-driver-does-not-return-error-message-if-one-among-multiple-statements-fail-to-execute

Article Number

000189352

Environment

Product: DataDirect Version: 07.16.0330 (B0337, U0221) OS: Windows 2012 R2 Database: SQL Server 2012 Application: Custom Application

Question/Problem Description

When Multiple Statements are run together in a batch, if the second statement fails, the driver does not return an error. Instead, SQL_SUCCESS is returned.

Steps to Reproduce

(1)create table target_table1(pk_col1 int ,col2 int) (2)create table target_table2(pk_col1 int ,col2 int) (3)create table target_table(pk_col1 int ,col2 int) (4)drop table target_table1 (5)TRUNCATE TABLE target_table2;select * from target_table2;select * from target_table1;Insert into target_table2 (pk_col1,col2)select pk_col1,col2 from target_table;ALTER INDEX ALL ON Target_Table2 REBUILD NOTE : target_table1 was dropped in (4) Steps To Reproduce Execute 1,2,3,4&5 in odbctest Observed Output : SQLExecDirect: In: hstmt = 0x000000000096C620, szSqlStr = "", cbSqlStr = -3 Return: SQL_SUCCESS=0 Expected Output : Return: SQL_ERROR=-1 stmt: szSqlState = "42S02", *pfNativeError = 208, *pcbErrorMsg = 108, *ColumnNumber = -1, *RowNumber = -1 MessageText = "[DataDirect][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Invalid object name 'target_table1'."

Clarifying Information

Error Message

Defect Number

Enhancement Number

Cause

This is expected behavior. After executing the batch; the application is positioned on the first result set, which was a successful query.

Resolution

Call SQLMoreResults() to iterate to the next result set. SQLMoreResults() should be called until it returns SQL_NO_DATA.

Workaround

Notes

References to other documentation:
SQLMoreResults() function: https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/sqlmoreresults-function

Keyword Phrase

Last Modified Date

8/21/2018 9:12 PM

SQL Server Wire Protocol driver does not return error message if one among multiple statements fail to execute.

Files(0)

Was this article helpful?

Was this article helpful?

SQL Server Wire Protocol driver does not return error message if one among multiple statements fail to execute.

Information

Related Articles