Deploy SQL Express so my app still works on other machines

Hi all,


I have an app which uses an SQL Express database. The problem I'm
encountering is that when I deploy the app (including installing SQL
Express) my app cannot connect to the database. What is it I have to do to
get this working? Is it the format of my connection string within my app.

I was under the impression developing using SQL Express was straight-forward
(which it was on my dev box) but deploying it and still having the app
working seems a nightmare.

My connection string dev-side is the following:
"Data Source=.\SQLEXPRESS;AttachDbFileName=|DataDirectory|PM.mdf;Integrated
Security=True;User Instance=True"


Regards
John.


.

Relevant Pages

  • Re: Just say no to threads [Was: Software architecture]
    ... they knew there was going to be a database in the app. ... Now my colleague just spent a couple/three weeks designing an SQL ... Turns out they have a flat file of sample information, ...
    (comp.object)
  • Re: Question about forms and data storage
    ... app that synchs the data from SQL to a list, ... or look at moving the core data into the sharepoint ... list over the database... ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Deploy SQL Express so my app still works on other machines
    ... This all assumes that SQL Express is installed on the user's ... I have an app which uses an SQL Express database. ... Is it the format of my connection string within my app. ...
    (microsoft.public.sqlserver.msde)
  • Re: Realbasic 2008 and MS SQL
    ... The database to be used is MS SQL. ... shorlisted proposals was for the client app to be in Realbasic. ...
    (comp.lang.basic.realbasic)
  • SQL Connection problem - Help!
    ... I have an app using VB/ADO to connect to SQL databases. ... I was attempting to install our database into a default ...
    (microsoft.public.vb.database.ado)
Loading