This is my first post, I’m new to programming, but I’m trying�/span>
I have a small program developed with VB 2005 with a database on SQL Express 2005. I need to deploy it using a “Setup Project� but when I install it on another computer the Data Source becomes “read only� I have tried following a number of threads, but I can’t understand whether to pursue this as a “settings� “configuration� or permission issue. The connection string is as follows
Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\testdata.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True
This string works but, as I said, it attaches the database as read-only. I've since tried installing the database directly on the target computer, and I was able to prove that my installed program could then read and write to it -- therby eliminating a number of possible problems -- but I want to be able to install my database file as part of my setup project from a CD or FlashDrive. Please advise.