Microsoft KB Archive/151749

= How To Use Replication Considerations for the VFP ODBC Driver =

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

Keywords :

Issue type :

Technology :

Last Reviewed: July 30, 2001

-

[mailto:MSDN@MICROSOFT.COM Send feedback to Microsoft]

© 2002 Microsoft Corporation. All rights reserved.