"试图附加自动命名的数据库"错误 [英] "An attempt to attach an auto-named database" error

问题描述

我正在在Windows XP SP2专业版在C＃中的桌面应用程序，Visual Studio 2010中。

如果我直接运行在公布的文件夹中的应用程序，而无需运行安装程序或从调试文件夹中运行，或干脆调试应用程序，它并没有给这个错误。但是，如果我运行发布的文件夹的设置，然后从开始菜单中运行它，它给这个错误：

这是试图附加一个自动文件名为​​C数据库：\Documents和Settings\Desi\Local Settings\Apps\2.0\Data\K9KMBYK5.881\EKOOHKP2.0Y1\smas..tion_ddac366ea7cca062_0001.0000_c8a0800c5798ef15\Data\ SmasDb.mdf失败。具有相同名称的数据库不存在，或者指定的文件无法打开，或它位于UNC共享。

我发布的应用程序。在我的文档文件夹

C：\Documents和Settings\Desi\Local Settings\Apps\ 2.0\Data\K9KMBYK5.881\EKOOHKP2.0Y1\smas..tion_ddac366ea7cca062_0001.0000_c8a0800c5798ef15\Data\1.0.0.0（这的数据的目录仅具有user.config文件。）

C：\Documents和Settings\Desi\Local Settings\Apps\2.0\LWGCKB30.QZJ\E81QYJON.ZX9\manifests（含smas..tion_ddac366ea7cca062_0001.0000_none_a42d8ca7a940cae4.cdf毫秒smas..tion_ddac366ea7cca062_0001.0000_none_a42d8ca7a940cae4.manifest smas.exe_ddac366ea7cca062_0001.0000_none_3d144d2ce016963b.cdf毫秒smas.exe_ddac366ea7cca062_0001.0000_none_3d144d2ce016963b.manifest）

C：\Documents和Settings\Desi\Local Settings\Apps\2.0\LWGCKB30.QZJ\E81QYJON.ZX9\smas.exe_ddac366ea7cca062_0001.0000_none_3d144d2ce016963b（包含
SMAS.exe.config，SmasDb密度纤维板，SmasDb_log.ldf）

C：\Documents和Settings\Desi\Local Settings\Apps\2.0\LWGCKB30.QZJ\E81QYJON .ZX9\smas..tion_ddac366ea7cca062_0001.0000_c8a0800c5798ef15（这个目录有包括所有的DLL，SmasDb.mdf和SmasDb_log.ldf，SMAS.exe.config，一些.CDF-MS和.manifest文件不如上述.cdf-相同的所有文件MS和名为.manifest）

解决方案

你验证长路径（C：\文档和Settings\USER\Local Settings\Apps\2.0\Data\MP63M1NA.ZG5\BCOVJJWN.C53\smas..tion_ddac366ea7cca062_0001.0000_9c79a710d42895b6\Data\SmasDb.mdf），看看是否有实际上是一个数据库有

这是在错误信息的三种选择，我会去的：<？EM>或指定的文件无法打开的

您得考虑一下，你希望数据库是（非开发人员的计算机上），并确保它被复制那里。

请参阅的 一起工作的岗位数据库中的Visual Web Developer 2005 Express Edition的 的有关| DataDirectory目录|语法。​​

I am making a desktop application in C#, Visual Studio 2010 on Windows XP SP2 Professional.

If I run that application directly from the published folder without running setup OR run it from debug folder OR simply debug the application, it does not give this error. But if I run setup from published folder and then run it from start menu, it gives this error:

An attempt to attach an auto-named database for file C:\Documents and Settings\Desi\Local Settings\Apps\2.0\Data\K9KMBYK5.881\EKOOHKP2.0Y1\smas..tion_ddac366ea7cca062_0001.0000_c8a0800c5798ef15\Data\SmasDb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

I am publishing application to a folder in 'my documents'.

C:\Documents and Settings\Desi\Local Settings\Apps\2.0\Data\K9KMBYK5.881\EKOOHKP2.0Y1\smas..tion_ddac366ea7cca062_0001.0000_c8a0800c5798ef15\Data\1.0.0.0 (this Data directory has only the user.config file.)

C:\Documents and Settings\Desi\Local Settings\Apps\2.0\LWGCKB30.QZJ\E81QYJON.ZX9\manifests (contains smas..tion_ddac366ea7cca062_0001.0000_none_a42d8ca7a940cae4.cdf-ms smas..tion_ddac366ea7cca062_0001.0000_none_a42d8ca7a940cae4.manifest smas.exe_ddac366ea7cca062_0001.0000_none_3d144d2ce016963b.cdf-ms smas.exe_ddac366ea7cca062_0001.0000_none_3d144d2ce016963b.manifest)

C:\Documents and Settings\Desi\Local Settings\Apps\2.0\LWGCKB30.QZJ\E81QYJON.ZX9\smas.exe_ddac366ea7cca062_0001.0000_none_3d144d2ce016963b (contains SMAS.exe.config, SmasDb.mdf, SmasDb_log.ldf)

C:\Documents and Settings\Desi\Local Settings\Apps\2.0\LWGCKB30.QZJ\E81QYJON.ZX9\smas..tion_ddac366ea7cca062_0001.0000_c8a0800c5798ef15 (this directory has all files including all dlls, SmasDb.mdf and SmasDb_log.ldf, SMAS.exe.config, some .cdf-ms and .manifest files NOT same as above .cdf-ms and .manifest)

解决方案

Did you verify that the long path (C:\Documents and Settings\USER\Local Settings\Apps\2.0\Data\MP63M1NA.ZG5\BCOVJJWN.C53\smas..tion_ddac366ea7cca062_0001.0000_9c79a710d42895b6\Data\SmasDb.mdf) to see if there actually is a database there?

From the three options in the error message, I would go for: or specified file cannot be opened

You'll have to think about where you want the database to be (on a non-developer computer), and make sure it is copied there.

See the post Working with Databases in Visual Web Developer 2005 Express Edition about the |DataDirectory| syntax.

这篇关于&QUOT;试图附加自动命名的数据库&QUOT;错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！