deploying an sqlserverCE sdf file

  • Thread starter Thread starter W
  • Start date Start date
W

W

I am programming on a Vista machine using vb.net 2005. My connection
string to connect to sql server ce is like this
cn.ConnectionString = "data source=C:\Windows
\System32\MyDataBase.sdf;Password=" & Common.DatabasePassword

Everything works fine and the project runs perfectly, but to deploy
the project i drove myself crazy looking for the sdf file until i
found it in
C:\Users\%username%\AppData\Local\VirtualStore\Windows\System32


What path should I use to deploy that? and what if the target machine
is an XP machine
 
IMHO you should not install a database file to System32
for a database i would recomend to use a sub directory in the applications
installation directory

hth
Michel Posseth
 
Back
Top