app_data folder question!

[Artificer]

Why by simply having a .mdf file in the app_data folder it is made
accessible? Does placing a .mdf in the app_data folder does some kind
of attachment? Do this pseudo attachment works only with the express
version of SQL Server? Do this feature works for access databases?

 

[bruce barker \(sqlwork.com\)]

its doesn't. the connect string contains the path to the mdf.

-- bruce (sqlwork.com)

 

[Juan T. Llibre]

re;

Why by simply having a .mdf file in the app_data folder it is made accessible?

Only if it's the Membership database registered into ASP.NET with the aspnet_regsql tool.
Any other database placed there *must* be explicitly made accessible.

re:

Do this pseudo attachment works only with the express version of SQL Server?

Yes, but only for the Membership DB.

re:

Do this feature works for access databases?

No, and it doesn't work for *any* other DB.





Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================