:“Failed to access IIS metabase”解决方法
原因:IIS没有注册
解决办法:
在CMD中进入目录C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727,运行aspnet_regiis
1、aspnet_regiis -ga administrator(administrator为当前用户)
2、aspnet_regiis -i (注册IIS)
3、iisreset /noforce (重启IIS)
操作详细:
C:\Documents and Settings\Administrator>cd c:\\windows\\microsoft.net\\framework\\v2.0.50727
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis -ga administrator
Start granting administrator access to the IIS metabase and other directories us
ed by ASP.NET.
Finished granting administrator access to the IIS metabase and other directories
used by ASP.NET.
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis -lv
2.0.50727.0 Valid C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\as
pnet_isapi.dll
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis -i
Start installing ASP.NET (2.0.50727).
..............
Finished installing ASP.NET (2.0.50727).
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis -lv
2.0.50727.0 Valid (Root) C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\as
pnet_isapi.dll
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>iisreset /noforce
Attempting stop...
Internet services successfully stopped
Attempting start...
Internet services successfully restarted
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>
问题详情:
Failed to access IIS metabase.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.Hosting.HostingEnvironmentException: Failed to access IIS metabase.
The process account used to run ASP.NET must have read access to the IIS metabase (e.g. IIS://servername/W3SVC). For information on modifying metabase permissions, please see htt
相关文档:
<connectionStrings>
<add name="qxConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Web/App_Data/db2.mdb;" providerName="System.Data.OleDb"/>
</connectionStrings> ......
Access中数据库转义字符规则:
插入、更新、=匹配 数据时,文本类型如用''括起来,中间可以有 ",*,%,[,],\,/,?,(,),{,}的任意组合,如要插入一个',需写''并在整个表达式外套一对''
如,插入 '张''三',数据库里就是 张'三,用方括号是不可以的
插入、更新、=匹配 数据时,文本类型如用""括起来,中间可以 ......
昨天弄了一个比较棘手的问题。从网上下载了一个软件,他的数据库是access的,打开看了一下,感觉不错,适合我现在项目的需求,大部分能够满足我的项目需要,就想拿来主义。可是我们项目的数据库一直都是用的sqlserver,于是,就在网上疯狂的,找关于access转换为sqlserver的资料在这里我想说一下有关的注意事项:
数据库升 ......
熟悉SQL SERVER 2000的数据库管理员都知道,其DTS可以进行数据的导入导出,其实,我们也可以使用Transact-SQL语句进行导入导出操作。在Transact-SQL语句中,我们主要使用OpenDataSource函数、OPENROWSET 函数,关于函数的详细说明,请参考SQL联机帮助。利用下述方法,可以十分容易地实现SQL SERVER、ACCESS、EXC ......