Mark,
AError() tells me that file 'myfile' does not exist. But the other servers do have that directory and table.
Also, if I run this from my PC and query the table on my PC, it works. But if I go to another PC and query my PC, I get the file does not exist error.
What does it look for on the other PC to make this work?
Thanks,
Jerry
>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