FIX: Upsizing to SQL 7.0 with Currency Type Fails (221750)


The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 6.0
  • 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.
Modification Type:MajorLast Reviewed:10/15/2003
Keywords:kbBug kbDatabase kbfix kbVS600sp3fix kbwizard KB221750
©2003 Microsoft Corporation. All rights reserved.