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

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
http://www.merant.com/datadirect

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