PRB: Error 10001: NULL DBPROCESS Pointer Encountered

ID: Q78028

The information in this article applies to:

Microsoft SQL Server Programmer's Toolkit, version 4.2

SYMPTOMS

When using the Visual Basic Library for SQL Server, calling the SqlInit$() function causes the following VBSQL error message to occur:

Error 10001: NULL DBPROCESS pointer encountered

CAUSE

When the SqlInit$() function is called, VBSQL creates and maintains information about the program calling it. This prevents conflicts between programs that use VBSQL concurrently. For VBSQL to release this information, the programs must call SqlWinExit just before it exits. If SqlWinExit is not called, when another VBSQL program is run, the VBSQL program will return an error message. Despite the error message, the SQL Server connection should work properly.

WORKAROUND

To eliminate this problem, make sure that SqlWinExit is called prior to calling the SqlInit$() function. This can be accomplished by making sure SqlWinExit is called whenever a VBSQL program is closed.

Keywords : kbinterop SSrvVisB
Version : 4.2
Platform : WINDOWS
Issue type :