Microsoft KB Archive/221750

Knowledge Base

FIX: Upsizing to SQL 7.0 with Currency Type Fails

Article ID: 221750

Article Last Modified on 10/15/2003

---

APPLIES TO

• Microsoft Visual FoxPro 6.0 Professional Edition
• Microsoft Data Access Components 2.5

---

This article was previously published under Q221750

SYMPTOMS

When upsizing a table containing a currency field to SQL Server 7.0, it could return the error:

Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Implicit conversion from data type char to money is not allowed. Use the CONVERT function to run this query.

STATUS

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

This bug was corrected in Visual Studio 6.0 Service Pack 3.

For more information about Visual Studio service packs, please see the following articles in the Microsoft Knowledge Base:

194022 INFO: Visual Studio 6.0 Service Packs, What, Where, Why

194295 HOWTO: Tell That Visual Studio 6.0 Service Packs Are Installed

MORE INFORMATION

Steps to Reproduce Behavior

1. Upsize a table that contains a currency field.
2. Once upsizing is complete, a project created by the Upsizing process appears.
3. Run the reports in the project and look for the error listed in the SYMPTOMS section above.

Keywords: kbbug kbfix kbdatabase kbwizard kbvs600sp3fix KB221750

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.