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)