How To Use Replication Considerations for the VFP ODBC Driver

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:

Select each table that has been included for replication in the Edit Publications dialog, and select Edit.

Select the Scripts tab in the Manage Articles dialog, and select GENERATE.

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 query words: 1.00

Keywords : FxinteropOdbc
Version : 1.00
Platform : WINDOWS
Issue type :