How To Use Replication Considerations for the VFP ODBC Driver

Last reviewed: May 31, 1996
Article ID: Q151749

The information in this article applies to:

Microsoft Visual FoxPro ODBC Driver, version 1.0

SUMMARY

This article describes how to use the Replication feature in SQL Server 6.50 to set several configuration options that allow SQL Server to work correctly with the Visual FoxPro ODBC driver.

MORE INFORMATION

To configure the ODBC driver data source, the Visual FoxPro ODBC driver needs to be set up as a DSN, a system data source.
To specify the publication for SQL Server, the "Bulk Data Copy - Character Format" method in the Syncronization tab of the Edit Publications dialog should be selected.
To specify the table to be replicated in SQL Server, the Cluster Index should be disabled because this option issues an CREATE INDEX command that is unsupported by the Visual FoxPro ODBC driver. To disable the Cluster Index, use the following steps:
1. Select each table that has been included for replication in the Edit
```
      Publications dialog, and select Edit.
```
2. Select the Scripts tab in the Manage Articles dialog, and select
```
      GENERATE.
```
3. Deselect the "Transfer Cluster Index" checkbox, and select
```
      AUTO-GENERATE.
```

The following table lists how data types are mapped from SQL Server to a Visual FoxPro table during replication. Known issues are listed under the Comments heading:

SQL Server   Visual FoxPro     Comments
==========   =============     ========

Smallint        I

Tinyint         I

Int             I

Bit             L

Datetime        C               This is due to precision limitations
                                between SQL Server and the Visual FoxPro
                                ODBC driver.

Text            M               If you have embedded CR/LF, identify new
                                line termination characters for the
                                replication. See SQL documentation for
                                more information.

Char            C

Varchar         M

Numeric         C               This is due to precision limitations
                                between SQL Server and the Visual FoxPro
                                ODBC driver.

Binary          Not Supported   The replication task incorrectly
                                specifies precision that generates
                                a syntax error in the driver.
Smalldatetime   T

Decimal         C               This is due to precision limitations
                                between SQL Server and the driver.
Real            B

Float           B

Smallmoney      C

Sysname         C

Varbinary       Not Supported   The replication task incorrectly
                                specifies precision that generates
                                a syntax error in the driver.

Timestamp       Not Supported   The replication task incorrectly specifies
                                precision that generates a syntax error
                                in the driver.

Additional reference words: 1.00
KBCategory: kbinterop kbhowto
KBSubcategory: FxinteropOdbc

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 31, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.