BUG: GPF in Data Access Objects After You Install SQL Server Client

Article translations Article translations
Article ID: 293786 - View products that this article applies to.
This article was previously published under Q293786
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

On This Page

SYMPTOMS

If you install the Spanish version of the SQL Server 7.0 Client utilities on a computer that is running Microsoft Windows 95 OEM Service Release 2 (OSR2), a General Protection Fault (GPF) error occurs when you use Data Access Objects (DAO) to open a database.

This problem does not occur on computers that are running the Spanish version of Microsoft Windows NT 4.0, nor does it occur on computers that are running the English version of Windows 95.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

  1. On a test computer that is running Windows 95 OSR2 Spanish with Visual Basic 6.0 Spanish installed, install the SQL Server 7.0 Client (Spanish) and Microsoft Data Access Components (MDAC) 2.1 Service Pack 1 (SP1).
  2. Create a new Standard EXE project in Visual Basic 6.0. Form1 is created by default.
  3. From the Project menu, click References, and then click Microsoft DAO 3.0 Object Library.
  4. Add a CommandButton (Command1) to Form1.
  5. Paste the following code in the declarations section of Form1:
    Option Explicit
    
    Dim spcodbc As Workspace
    Dim mibd As Database
    Dim strSQL As String
    Dim rsCount As Recordset
    Dim rs As Recordset
    
    Private Sub Command1_Click()
    Set spcodbc = Workspaces(0)
    Set mibd = spcodbc.OpenDatabase("D:\VB5\NWind.mdb")
    strSQL = "Select * From Categories"
    
    Set rsCount = mibd.OpenRecordset(strSQL, dbOpenSnapshot)
    Text1.Text = rsCount.RecordCount
    
    Set rs = rsCount.OpenRecordset(dbOpenSnapshot)
    
    End Sub
    					
  6. Run the program, and click the CommandButton on Form1. Notice that a General Protection Fault occurs when you click the CommandButton.

Properties

Article ID: 293786 - Last Review: February 28, 2014 - Revision: 1.1
APPLIES TO
  • Microsoft Visual Basic Enterprise Edition for Windows 6.0
  • Microsoft Visual Basic 6.0 Professional Edition
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbdatabase kbjet kblocalization kbpending KB293786

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com