Are you sure the other server has its tables in the same path - c:\apps? Maybe you should use a UNC path. After you get the -1 return value, issue an AERROR(laError) from the command window, then check the contents of the laError array to see what the error is.
>Using VFP7.
>
>The following works if I use my IP address in the server parameter.
>
>
>lnHandle = SQLSTRINGCONNECT("driver={Microsoft Visual Foxpro Driver};server=MyIPAddress;" + ;
> "uid=;pwd=;SourceType=DBF; Exclusive=No;Collate=Machine;SourceDB=c:\Apps;")
>
>?SQLEXEC(lnHandle,"SELECT * FROM mytable", "mycursor")
>=SQLDISCONNECT(0)
>
>
>But if I use another web servers IP address, the SQLEXEC() returns -1. But the lnHandle returns a 1.
>
>Should I be able to query a table on another web server's drive with the above code if I got a valid handle.
>
>Thanks,
>
>Jerry
Mark McCasland
Midlothian, TX USA