PRB: "Out of Memory" Error When Using VBQUERY Sample App

Last reviewed: April 28, 1997
Article ID: Q78982

The information in this article applies to:

  - Microsoft SQL Server Programmer's Toolkit, version 4.2

SYMPTOMS

When executing a query with the VBQUERY sample application, which is included with the Visual Basic Library for SQL Server, the following error message is returned:

   Out of memory.

CAUSE

When VBQUERY processes result rows from SQL Server, it formats and displays the columns by padding them with spaces and adding them to a list box. Because the maximum allowable number of characters to insert into a Visual Basic list box control is 64,000 bytes, large queries may exceed this limit and result in the "Out of memory" error.

WORKAROUND

This is a limitation of the VBQUERY sample application included with the Visual Basic Library for SQL Server.

Additional query words:
Keywords : kbinterop SSrvVisB
Version : 4.2
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.