troubleshooting Question

sql connection file or database

Avatar of Eamon
EamonFlag for Ireland asked on
ASP.NETVisual Basic.NET
5 Comments1 Solution711 ViewsLast Modified:
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.

example below
        <add name="SqlExpressConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\data.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
            providerName="System.Data.SqlClient" />


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros