>>>I've installed SQL Server on my webserver and I need to access data from
>>>the sql server in my VFP application.
>>
>>You can create a DSN or a ConnectionString that includes the IP address of
>>the webserver instead of the network name.
>
>Can I access VFP Databases similarly??
Yes, but I wouldn't recommend it. SQL Server will do the work on the back end, and only pass back what you need: VFP will try to read the entire table.
That said, I just got this to work:
lnHandle = SQLSTRINGCONNECT("DRIVER=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=\\xxx.xxx.xxx.xxx\fox")
SQLEXEC(lnHandle, "SELECT * FROM Labels")
where I had previously set "fox" as the web directory name for the VFP home directory.
You should probably read Rick Strahl's
Internet enabling Visual FoxPro applications for more details.