If you already used vfp cursoradapter, use it again. If the class is new to you, invest 2H of reading and reserve 2H of learning:
afterwards any remote data is much easier to handle than with remote views or SPT calls.
IIRC there were some version oddities with specific drivers and specific MS-SQL release versions concerning the returned data type. Before beating your head to the keyboard, google specifics. Goes for any technique [cusoradapter, SPT, RV] to access via vfp...

HTH

thomas

Hank pointed you already

>My parent company is requiring that I do some database work and they have given me VPN access through the Dell SonicWall / Nextextender application.
>
>I need to access their SQL database with my VFP and use the data accordingly for our uses here.
>
>They have given me the following, I just need a boost in the right direction as I am used to dealing with just the native foxpro data...
>
>SQL Server: ECD-SVR-SQL
>
>
>Database: ECNC Interface
>
>View: ECNC_CO_View (Read Access)
>
>Tables: ECNC_invoice_info (Read/Write Access)
> ECNC_shipping.info (Read/Write Access)