Microsoft KB Archive/229170

= Errors Connecting to SQL Server 7.0 Data Source with MSQuery =

Article ID: 229170

Article Last Modified on 8/18/2005

-

APPLIES TO

 Microsoft Query 2000, when used with:  Microsoft Office 95 Standard Edition

 Microsoft Excel 95 Standard Edition 

-



This article was previously published under Q229170



SYMPTOMS
When you use Microsoft Query 2.0 to access data from a Microsoft SQL Server 7.0 database, you may experience the following symptoms:  When you attempt to connect to a SQL Server 7.0 data source, you receive the following error message:

MSQRY32 caused an invalid page fault in module MSQRY32.exe at 0137:00437df4.

</li> When you double-click a field in a table's field list in the Table pane, and the table is from a SQL Server 7.0 data source, you receive the following error message:

"Invalid Object name ' . . '"

where  is the database name,   is the owner name of the database, and   is the name of the table (for example 'pubs.dbo.authors').</li></ul>

NOTE: The first symptom does not occur if the Year 2000 Update for Microsoft Office 95 (O95y2k.exe) is installed, but the second symptom does occur.

<div class="cause_section">

CAUSE
This problem occurs because Microsoft Query 2.0 is not compatible with Microsoft SQL Server 7.0.

<div class="resolution_section">

RESOLUTION
Upgrade to Microsoft Query 8.0 or later. Microsoft Query 8.0 is included with Microsoft Office 97 or Microsoft Excel 97.

Additional query words: XL7

Keywords: kberrmsg kbfix kbinterop kbprb KB229170

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.