VB.NET用于Windows服务的Oracle客户端的Microsoft企业库 [英] VB.NET Microsoft enterprise library for Oracle client in windows service
问题描述
您好
我的要求是从Windows服务生成报告并通过电子邮件发送给一群人。
为此，我使用Microsoft Enterprise Library从数据库中获取电子邮件分发列表。然而它失败了。
我收到以下错误。
对我来说，惊喜的是同样的在WEB.CONFIG中使用相同配置从Web应用程序调用db时，配置对我有用，但在使用app.config的WIN服务中失败
@@@@@@ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@找到'e：\Builds \EntLib \Latest \Source \Blocks\Data\Src\Data\Database.cs'的源代码。校验和：MD5 {63 6f bc e4 a2 84 be 78 e1 82 68 e3 a1 db fb 18}
文件'e：\Builds\EntLib\Latest\Source \ Blocks \\ data\Src\Data\Database.cs'不存在。
在脚本文档中查找'e：\Builds\EntLib \ Latest \Source \ Blocks \\ \\ data\Src\Data\Database.cs'...
查看'e：\Builds\EntLib \ Latest \Source \ Blocks \的项目Data\Src\Data\Database.cs'。
在项目中找不到该文件。
查看目录'E：\Program Files \\ \\ Microsoft Visual Studio 10.0\VC\crt\src\'...
查看目录'E：\Program Files \ Microsoft Visual Studio 10.0\VC \ atmlmfc \ src \mfc \'...
查看目录'E：\Program Files \ Microsoft Visual Studio 10.0\VC \ atmlmfc\src\atl \ '...
查看目录'E：\Program Files \ Microsoft Visual Studio 10.0 \VC \ atmlmfc \include \'...
活动解决方案的调试源文件设置指示调试器不会要求用户找到该文件：e：\Builds\EntLib\Latest\Source \Blocks\Data\Src\Data\Database.cs。
调试器无法找到源文件'e：\Builds\EntLib \Latest \Source \Blocks \ Data \Src \ Data \Database.cs'
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ <无线电通信/>
我的应用程序配置部分定义如下：
< configsections >
< 部分 名称 = dataConfiguration type = Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings，Microsoft.Practices.EnterpriseLibrary.Data，Version = 5.0.414.0，Culture = neutral，PublicKeyToken = 31bf3856ad364e35 / >
< / configsections >
< dataconfiguration defaultdatabase = MYDB >
< / dataconfiguration >
< connectionstrings >
< add name = MYDB connectionstring = 数据源= MYDBSOURCE;用户ID = MYDBUSER;密码= MYDBPWD;集成安全性=真; providername = System.Data.OracleClient的 / >
< / connectionstrings >
有人可以提出导致问题的原因吗？我的App配置有问题吗？
我已经搜索出来但找不到解决方案。
< pre lang =" xml">在将配置文件修改为以下后问题已解决。
< pre lang =" xml" ;>
< configsections>
< section name =" dataConfiguration" type =" Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings，Microsoft.Practices.EnterpriseLibrary.Data，Version = 5.0.414.0，Culture = neutral，PublicKeyToken = 31bf3856ad364e35" requirePermission =" true" />
< / configsections>
< dataconfiguration defaultdatabase =" MYDB">
< ; / dataconfiguration>
< connectionstrings>
< add name =" MYDB" connectionstring ="数据源= MYDBSOURCE;用户ID = MYDBUSER;密码= MYDBPWD;集成安全性=真;"的providerName = QUOT; System.Data.OracleClient的" />
< / connectionstrings>
< startup>
< supportedRuntime version =" ; V4.0" sku =" .NETFramework，Version = v4.0" />
< / startup>
< / pre>< / pre>
Hi
My requirement is to generate reports from windows service and email it to the group of people.
For this I am using Microsoft Enterprise Library to get the email distribution list from database. However it is failing.
I am getting below error.
Suprising thing for me is same kind of configuration is working for me when calling db from web application with same configuration in WEB.CONFIG but failing in WIN Service using app.config
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Locating source for 'e:\Builds\EntLib\Latest\Source\Blocks\Data\Src\Data\Database.cs'. Checksum: MD5 {63 6f bc e4 a2 84 be 78 e1 82 68 e3 a1 db fb 18}
The file 'e:\Builds\EntLib\Latest\Source\Blocks\Data\Src\Data\Database.cs' does not exist.
Looking in script documents for 'e:\Builds\EntLib\Latest\Source\Blocks\Data\Src\Data\Database.cs'...
Looking in the projects for 'e:\Builds\EntLib\Latest\Source\Blocks\Data\Src\Data\Database.cs'.
The file was not found in a project.
Looking in directory 'E:\Program Files\Microsoft Visual Studio 10.0\VC\crt\src\'...
Looking in directory 'E:\Program Files\Microsoft Visual Studio 10.0\VC\atlmfc\src\mfc\'...
Looking in directory 'E:\Program Files\Microsoft Visual Studio 10.0\VC\atlmfc\src\atl\'...
Looking in directory 'E:\Program Files\Microsoft Visual Studio 10.0\VC\atlmfc\include\'...
The debug source files settings for the active solution indicate that the debugger will not ask the user to find the file: e:\Builds\EntLib\Latest\Source\Blocks\Data\Src\Data\Database.cs.
The debugger could not locate the source file 'e:\Builds\EntLib\Latest\Source\Blocks\Data\Src\Data\Database.cs'
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
My App config section is defined as in below:
<configsections>
<section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=5.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
</configsections>
<dataconfiguration defaultdatabase="MYDB">
</dataconfiguration>
<connectionstrings>
<add name="MYDB" connectionstring="Data source=MYDBSOURCE;User Id=MYDBUSER;Password=MYDBPWD;Integrated Security=true;" providername="System.Data.OracleClient" />
</connectionstrings>
Can anybody suggest what is causing the problem? Is some thing wrong with my App config?
I have googled out but could not find the solution.
<pre lang="xml">Issue has been resolved after modifying the config file to below.
<pre lang="xml">
<configsections>
<section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=5.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="true"/>
</configsections>
<dataconfiguration defaultdatabase="MYDB">
</dataconfiguration>
<connectionstrings>
<add name="MYDB" connectionstring="Data source=MYDBSOURCE;User Id=MYDBUSER;Password=MYDBPWD;Integrated Security=true;" providername="System.Data.OracleClient" />
</connectionstrings>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
</startup>
</pre></pre>
这篇关于VB.NET用于Windows服务的Oracle客户端的Microsoft企业库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
