OPEN DATA YourDBC CREATE CONNECTION MyConnection ; CONNSTRING 'DRIVER=sql server;SERVER=(local);UID=sa;PWD=;DATABASE=northwind'2. Create your remote view to use this connection.
CREATE SQL VIEW MyView REMOTE CONNECTION MyConnection SHARE AS ; select EmployeeID, LastName, FirstName from employees3. Use your remote view as a regular VFP table.
OPEN DATA YourDBC USE MyView BROWSEor, you could use SQL pass-through with something like:
nConn = SQLStringConnect('DRIVER=sql server;SERVER=(local);UID=sa;PWD=;DATABASE=northwind') sqlexec(nConn, 'select * from employees', 'curEmployees') select curEmployees browse>Hi friends!