Microsoft KB Archive/102783

FIX: VBSQL.VBX SQLBCP_INIT Causes Fault in W3DBLIB.DLL

PSS ID Number: Q102783 Article last modified on 08-31-1995

4.20

WINDOWS

BUG# 8925 (4.2)

= SYMPTOMS =

Calling SQLBCP_INIT in VBSQL.VBX causes Microsoft Visual Basic versions 2.0 and 3.0 for Windows to “Exceed Segment Bounds (Read)” fault in W3DBLIB.DLL when referencing a table with defaults bound to it.

When you call SQLBCP_INIT in Visual Basic’s VBSQL.VBX, you get the following message if the table referenced has defaults bound to it:

An error has occurred in your application. If you choose ignore, you should save your work in a new file. If you choose Close, Your application will terminate. Close Ignore

If you press Ignore, SQLBCP_INIT will continue and succeed.

= WORKAROUND =

Do not Bulk Copy Program (BCP) to or from tables with defaults bound to them.

= STATUS =

Microsoft has confirmed this to be a problem in the Microsoft Visual Basic Programmer’s Toolkit (PTK) for Microsoft SQL Server version 4.2. This problem was corrected in the PTK version 4.21. For more information, contact your primary support provider.

Additional reference words: 4.20 4.21 KBCategory: kbinterop kbbug4.20 kbfix4.21 KBSubCategory: SSrvBCP SSrvProg SSrvVisB

=
================================================================

Copyright Microsoft Corporation 1995.