>Dear Experts,
>i wantto migrate my app slowy to the SQL server.
>At this point i want to decide to using SPT (Sql Passthrough) or CA (CursorAdapter)
>
>what is Advantages and Disadvantages both of techniques ?
>which time which one is more suitable for needs ?
>
>TIA

SPT can only use ODBC while CA can both use ODBC and OLEDB. With ODBC driver VFP (or anything that use the ODBC driver) have problems accessing SQL 2005 data so I think CA is one step ahead having ability to use ADO.
Cetin