PRB: Error 10001: NULL DBPROCESS Pointer Encountered

ID Number: Q78028

1.10

OS/2

Summary:

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.

RESOLUTION

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.