Hi Borislav. Thanks for replying.
I had a look at the site and it gave connction string as:
Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=myPath\myData.sdf;
Do you know if this is the string used in a VFP app..
i.e.
Sqstr = "Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=myPath\myData.sdf" ?
Regards,
Gerard
>>Hi.
>>I want to access a Sql Server Compact Database(.SDF) within a VFP app
>>Anybody know what Connection String to use
>>
>>The following works for a Sql express table but i PRESUME its different for Compact Sql Table Database ?
>>strConn = "Driver=SQL Server;Server=GERARDXP\SQLEXPRESS;" +;
>> "Database=C:\MYFOLD\APP_DATA\DOCMAN.MDF;Trusted_connection=yes"
>>
>>Regards,
>>Gerard
>
>Check
http://www.connectionstrings.com/?carrier=sqlserver2005ce