Latest revision as of 11:06, 21 July 2020

Knowledge Base

PRB: International Number Settings Cause Upsizing Wizard Failure

Article ID: 172395

Article Last Modified on 2/24/2005

APPLIES TO

Microsoft Visual FoxPro 5.0a
Microsoft Data Access Components 2.5

This article was previously published under Q172395

SYMPTOMS

International settings in SET POINT TO and SET SEPARATOR TO cause the following error to occur in the SQL Server Upsizing Wizard:

To upsize to SQL Server 6.x, please install a SQL Server ODBC driver version 2.05 or later

This error does not occur with the Upsizing wizard that shipped with Visual FoxPro 5.0.

RESOLUTION

Before running the SQL Server Upsizing Wizard, change the number settings using the following commands:

   SET POINT TO "."
   SET SEPARATOR TO ","

-Or-

If the Regional Settings of Microsoft Visual FoxPro are set to "Use System Settings," change the settings in the Number tab of the Microsoft Windows 95 or Windows NT Regional Settings Control Panel to match (without the quotes) the following:

   Decimal symbol: "."
   Digit grouping symbol: ","

STATUS

Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Behavior

Run the following program from a program file or the Command window:

      OPEN DATABASE HOME() + "SAMPLES\DATA\TESTDATA"
      SET POINT TO ","
      SET SEPARATOR TO "."
      DO HOME() + "Wizards\WZUpsize.app"

The Upsizing Wizard for SQL Server appears.

Click the database to upsize, then click Next.
Click the appropriate data source and click Next. The SQL Server Login \ dialog box appears.
Enter the appropriate User ID and Password then click OK. The following error appears:

To upsize to SQL Server 6.x, please install a SQL Server ODBC driver version 2.05 or later

This also happens if the Regional Settings in the Control Panel have the same settings for Point and Separator as listed above in Step 1.

If using the system Regional Settings, as in the second part of the Resolution Section above, the [Tools][Options][Regional] settings of Microsoft Visual FoxPro should have the "Use System Settings" option checked.

REFERENCES

Microsoft Visual FoxPro Developer's Guide, Chapter 20, "Upsizing Visual FoxPro Databases"

Additional query words: ODBC SQL upsize wizard

Keywords: kberrmsg kbprb KB172395

@@ Line 59: / Line 59: @@
 Before running the SQL Server Upsizing Wizard, change the number settings using the following commands: <span class="kbd userinput"> </span>
-<pre class="codesample">   SET POINT TO &quot;.&quot;
+<pre class="codesample">   SET POINT TO "."
-    SET SEPARATOR TO &quot;,&quot;
+    SET SEPARATOR TO ","
                      </pre>
 -Or-<br />
 <br />
-If the Regional Settings of Microsoft Visual FoxPro are set to &quot;Use System Settings,&quot; change the settings in the Number tab of the Microsoft Windows 95 or Windows NT Regional Settings Control Panel to match (without the quotes) the following: <span class="kbd userinput"> </span>
+If the Regional Settings of Microsoft Visual FoxPro are set to "Use System Settings," change the settings in the Number tab of the Microsoft Windows 95 or Windows NT Regional Settings Control Panel to match (without the quotes) the following: <span class="kbd userinput"> </span>
-<pre class="codesample">   Decimal symbol: &quot;.&quot;
+<pre class="codesample">   Decimal symbol: "."
-    Digit grouping symbol: &quot;,&quot;
+    Digit grouping symbol: ","
                      </pre>
@@ Line 85: / Line 85: @@
 <ol>
 <li><p>Run the following program from a program file or the Command window: <span class="kbd userinput"> </span></p>
-<pre class="codesample">      OPEN DATABASE HOME() + &quot;SAMPLES\DATA\TESTDATA&quot;
+<pre class="codesample">      OPEN DATABASE HOME() + "SAMPLES\DATA\TESTDATA"
-       SET POINT TO &quot;,&quot;
+       SET POINT TO ","
-       SET SEPARATOR TO &quot;.&quot;
+       SET SEPARATOR TO "."
-       DO HOME() + &quot;Wizards\WZUpsize.app&quot;
+       DO HOME() + "Wizards\WZUpsize.app"
                              </pre>
 <p>The Upsizing Wizard for SQL Server appears.</p></li>
@@ Line 102: / Line 102: @@
 This also happens if the Regional Settings in the Control Panel have the same settings for Point and Separator as listed above in Step 1.<br />
 <br />
-If using the system Regional Settings, as in the second part of the Resolution Section above, the [Tools][Options][Regional] settings of Microsoft Visual FoxPro should have the &quot;Use System Settings&quot; option checked.
+If using the system Regional Settings, as in the second part of the Resolution Section above, the [Tools][Options][Regional] settings of Microsoft Visual FoxPro should have the "Use System Settings" option checked.
 </div>
@@ Line 109: / Line 109: @@
 == REFERENCES ==
-Microsoft Visual FoxPro Developer's Guide, Chapter 20, &quot;Upsizing Visual FoxPro Databases&quot;
+Microsoft Visual FoxPro Developer's Guide, Chapter 20, "Upsizing Visual FoxPro Databases"
 </div>

Microsoft KB Archive/172395: Difference between revisions