>I am trying to connect to a VFP database on our webserver thru ODBC - using connectstring. I have problems in referring the webfolder/database. I am using VFP 6.0.
>
>Pls guide me, given below is the connection string,:
>
>mycon=sqlstringconnect("Driver={Microsoft FoxPro VFP Driver (*.dbf)};"+;
> "SOURCETYPE=DBC;"+"SOURCEDB=\\myserver.com\www\pages\data\mydata.dbc;"+;
>"Exclusive=No;"+"Deleted=Yes;"+"Collate=Machine;"+ "BackgroundFetch=No")
>
>When I try this string to connect to a local database it works fine.
>
>Pls help.
>
>Thanks in advance
Raja,
In order to access that DBC you have to have access to the share where it's located. Essentialy, if you cannot open database with OPEN DATABASE \\myserver.com\www\pages\data\mydata.dbc command, you cannot access it through ODBC.
--sb--