The UserInstance problem

microsoft.public.dotnet.framework.adonet

23 Mar 2006 9:48 PM

There is an article :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sqlexpuserinst.asp

It introduce the UserInstance

There are some problems after I read this article, but I can't find
solution:
1: There writer say in the Common Issues, the IDE will detaches the
database, so that the asp.net can open the database file. But if I previewed
a dataset in IDE, the asp.net can't open the database file.

2. I can not Auto Close option in UserInstance, when I add AutoClose=true to
the connection string, it result in an error.

3. When I use sp_detach_db my.mdf in asp.net, it failed with message: the
file is used.