I am trying to deploy a simple windows forms application using the standard Publish option in Visual Studio. I am using a SQL server compact file (.sdf) as my database. When I deploy the app and install it on a test computer, I get this error:
The Path is not valid. Please check the directory for the database.
and then it shows me the connection string I have configured in the app config file. But according to MSDN I have done everything correct.
http://msdn.microsoft.com/en-us/library/aa983326.aspx
I guess what I'm asking is, how do I configure the sdf file database so the application knows where to find it when I install the app on a client computer?
Please help.