Microsoft KB Archive/238283

From BetaArchive Wiki
Knowledge Base


MacXL: "Data Truncated" Error Message Connecting to SQL Server 7.0 Database

Article ID: 238283

Article Last Modified on 6/12/2007



APPLIES TO

  • Microsoft Excel 2001 for Mac
  • Microsoft Excel 98 for Macintosh



This article was previously published under Q238283

SYMPTOMS

When you click OK in the VSI MS SQL Server dialog box, you receive one or both of the following error messages:

Data truncated

-or-


Couldn't read this file.

CAUSE

This problem occurs when you attempt to connect to a Microsoft SQL Server 7.0 database. The SQL Server ODBC driver that is included with Microsoft Excel 98 Macintosh Edition does not support connecting to a SQL Server 7.0 database. Microsoft Excel 2001 for Mac does install any ODBC drivers.

WORKAROUND

To connect to a SQL 7.0 driver, you can purchase a driver from a third-party company. The following companies are a few that may have this driver:

Attunity
Phone: (781) 221-1450
Fax: (617) 272-2531
http://www.attunity.com

Centura Software Corp.
Phone: (415) 321-9500
Fax: (415) 321-5471
http://www.centurasoft.com

MERANT plc
Phone: (800) 876-3101, (919) 461-4200
Fax: (919) 461-4526


MORE INFORMATION

Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.

For information about how to contact third-party companies, click the appropriate article number in the following list to view the article in the Microsoft Knowledge Base:

65416 Hardware and Software Third-Party Vendor Contact List, A-K

60781 Hardware and Software Third-Party Vendor Contact List, L-P

60782 Hardware and Software Third-Party Vendor Contact List, Q-Z



Additional query words: XL98 visigenic Excel XL2001 XL SQL query ODBC driver

Keywords: kbprb KB238283