a) using connection method
- 1,2 only ODBC
- 3 ODBC and OLE-DB

b) VFP ways
1) SQLEXEC()
-Support only mapping field type to Varchar and Varbinary

2) Remote View
- Support full remapping source datatype to VFP datatype
- You need DBC container

3) Cursor Adopter
- Support full remapping source datatype to VFP datatype
- Support events for automatic refresh fields after inserting or updating


effective - no winner
reliable - no winner
faster than others - SQLEXEC()

MartinaJ

>Hi Experts
>
>As I know there are 3 Options to connect VFP to MySql Database. 1. SQLEXEC(), 2. Remote View and 3. Cursor Adopter.
>Could any one help me that which one is more effective, reliable and faster than others
>
>Thnx in advance
>
>Rgds:
>Ahsan Rana