SQLExpress, Visual Web Developer, Vista
Finally getting around to asking about hitting a SQLExpress DB from a Visual Web Developer App on Vista.
Typical sample connection strings are like:
<add name="AppConnectionString1" connectionString="Data Source=".\SQLEXPRESS";AttachDbFilename=& quot;C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorksLT_Data.md f";Integrated Security=True"
Moved the AdventureWorksLT_Data.mdf file to C:\Users\Public, attached it to my SQLExpress instance through Management Studio and tried to hit it with:
<add name="AppConnectionString1" connectionString="Data Source=".\SQLEXPRESS";Initial Catalog="AdventureWorks_Data.mdf";Integr ated Security=True"
Aslo tried leaving AdventureWorks_Data.mdf in C:\Users\Public without attching it to SQLExpress and using AttachDbFilename="C:\Users\Public\AdventureWo rksLT_Data.mdf
Anybody have the secret. I don't want to use the App_Data file (as in AttachDBFilename=|DataDirectory|), but hit the DB after it has been attached to SQLExpress. I suspect UAC is mucking things up again, just don't know how to get around it.