Microsoft KB Archive/70861

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 19:29, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q70861 to Microsoft KB Archive/70861 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.