PRSQL9103041: Do Not Use Embedded Go's with dbcmd

ID Number: Q70861

1.10

OS/2

buglist1.10 fixlist1.16

Summary:

PROBLEM ID: PRSQL9103041

SYMPTOMS

SQL Server logs OS/2 error 232: "No data on nonblocking pipe read,"

or results in a ring 0 trap error at the server, when submitting a

SQL batch via dbcmd() or dbsqlexec().

CAUSE

This error occurs if you submit a SQL batch to SQL Server via

dbcmd() or dbsqlexec() that has 10 or more embedded go's. Embedded

go's are specific to SAF and ISQL; therefore, if a batch containing

9 or fewer embedded go's is submitted, SQL Server logs the

following error message via the dblib message handler:

SQL Server message 101: SQL syntax error

RESOLUTION

Upgrade to LAN Manager version 2.0b to resolve the ring 0 trap

error.

Microsoft has confirmed this to be a problem in DB-LIBRARY (dblib)

version 1.1. This problem has been corrected in DB-LIBRARY version

1.16, which is available from Microsoft Product Support Services.

For more information, please contact your primary support provider.