I am using VFP7 to try to query a VFP table on another Web Server on our Intranet. I can successfully query on one web server but not the other.

I can perform the following commands from my PC to our Web1 web server on our Intranet successfully:

lnHandle = SQLSTRINGCONNECT("driver={Microsoft Visual Foxpro Driver};server=OurIPAddress;" + ;
"uid=;pwd=;SourceType=DBF; Exclusive=No;Collate=Machine;SourceDB=\\OurIPAddress\mydir;")
=SQLEXEC(lnHandle,"SELECT * FROM temp", "mycursor")
=AERROR(laError) &&Gets errors attempting to access Web2.

But the above will not work from my PC to our Web2 web server. The directory information is correct and the table does exists, but I get the following errors from web2.

laError
[1, 1] = 1526
[1, 2] = Connectivity error: [Microsoft][ODBC Visual FoxPro Driver]File 'temp.dbf' does not exist.
[1, 3] = [Microsoft][ODBC Visual FoxPro Driver]File 'van.dbf' does not exist.
[1, 4] = S0002
[1, 5] = 173
[1, 6] = 1

Any ideas?

Thanks,

Jerry