Dear Garrett,
Thanks for your reply,
I tried what you suggested, it does connect to ODBC VFP database, but somehow it is not able to connect to table. When i tried SQLTABLES(), it returned an empty cursor.
Can you please guide!!
Regards
Shaishav
>>>>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.
Regards
Shaishav