Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

FIX: Upsizing to SQL 7.0 with Currency Type Fails


View products that this article applies to.

This article was previously published under Q221750

↑ Back to the top


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.

↑ Back to the top


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

↑ Back to the top


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.

↑ Back to the top


Keywords: KB221750, kbwizard, kbvs600sp3fix, kbfix, kbdatabase, kbbug

↑ Back to the top

Article Info
Article ID : 221750
Revision : 3
Created on : 10/15/2003
Published on : 10/15/2003
Exists online : False
Views : 441