It may not be your connection string: it may well be where you deployed the file to.
If you put it in the application folder, then it will owrk fine on your development system, but it will fail in production because normal users don't have write access to folders under the Program Files directory for security reasons.
Have a look at this:
Where should I store my data?[
^] - it suggests some better options.