I just need something cleared up.
In web pages can connect to a sqlserver database, i do this all the time and have now problem with that.
you can also connect to the .mdf file. This is where i am confused. can you connect to the mdf file in the same way you would connect to a access(mdb) file or do you still need sql server running on the machine where the mdf is.
I am not really looking for a connection string, I'm looking for a clear explaination of what is going on and the reasons or different uses for this.
<add name="SqlExpressConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\data.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"