SQL Server 2005 Database in Usermode and ClickOnce

Topics: CAB & Smart Client Software Factory
May 12, 2006 at 2:47 AM
originally posted by: clausanderwald

Hello again,

I have a problem with a SQL Server 2005 Database, which is deployed with my Smart Client Programm over Click Once.
The database is connected in Usermode (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp) and is located in the application folder. Running the application from VS 2005 works without problems. When I copy the debug folder from the project into C:\Temp and runs the application it works without any problems. But when I deploy the application with Click Once, an error accours when opening the connection. The error is the same error as if the database-file doesn't exist. I suggest that the problem is the deploying with Click Once. Some days before I got the same problem with Click Once, it doesn't deploy the ProfileCatalog.xml. Changing the attribute in Click Once properties from the file to "include" solves this problem, but it does not solve the problem with the database.