Microsoft KB Archive/70861

From BetaArchive Wiki

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.