用Enterprise Library 5,如何连接AS/400 DB2?

[miaomiaoga]

我用了EL5,然后连接AS/400，错误提示是：老是失败。是不是我的Web.config文件写得不对呢？

<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="MM">
</dataConfiguration>
<connectionStrings>
<add name="MM"
providerName="IBM.Data.DB2"
connectionString="database=asiadb;uid=xxxx;pwd=yyyy;Persist Security Info=false;"/>
<add name="asiadb_400"
providerName="IBMDA400.DataSource.1"
connectionString="Provider=IBMDA400.DataSource.1;Persist Security Info=False;User ID=xxxx;PASSWORD=yyyy;Data Source=asiadb;"/>
</connectionStrings>

错误提示是：

The type Database cannot be constructed. You must configure the container to supply this value.

Line 50: SbOC.Append("WHERE 1=1 ");
Line 51:
Line 52: Database db = DatabaseFactory.CreateDatabase();
Line 53:

但如果我采下面这种传统的sqladaptor+sqlcommand连接是成功的.
<appSettings>
<add key="Connection_Asia_Odbc" value="Driver={Client Access ODBC Driver (32-bit)};System=asiadb;Uid=xxxx;Pwd=yyyy;DBQ=MAPSPLIBPR,MAPSFLIBPR,INFLIBPRH1,INPLIBPRH1,MAPSCOMF,MAPSUTIL,MAPSQGPL,QTEMP,ACCTCOMM,ACCTDATA,INFLIBPRA,INPLIBPRA,UTILITIES,QGPL;"/>
</appSettings>

[keepfool]

EntLib自带配置文件编辑工具，你用这个工具编辑DataBase节点试试。

[miaomiaoga]

ProviderName改过很多了,都不行,

但如果我采下面这种传统的sqladaptor+sqlcommand连接是成功的.
<appSettings>
<add key="Connection_Asia_Odbc" value="Driver={Client Access ODBC Driver (32-bit)};System=asiadb;Uid=xxxx;Pwd=yyyy;DBQ=MAPSPLIBPR,MAPSFLIBPR,INFLIBPRH1,INPLIBPRH1,MAPSCOMF,MAPSUTIL,MAPSQGPL,QTEMP,ACCTCOMM,ACCTDATA,INFLIBPRA,INPLIBPRA,UTILITIES,QGPL;"/>
</appSettings>

我的目的就是想用Enterprise Library 5去访问,保持整个项目的编程规范.:(

[miaomiaoga]

试了一下,成功了! 谢谢大家!

<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="Asiadb_OdbcDb">
<providerMappings>
</providerMappings>
</dataConfiguration>
<connectionStrings>
<add name="Asiadb_OdbcDb"
providerName="System.Data.Odbc"
connectionString="Driver={Client Access ODBC Driver (32-bit)};System=asiadb;Uid=XXXX;Pwd=YYYY;DBQ=MAPSPLIBPR,MAPSFLIBPR,INFLIBPRH1,INPLIBPRH1,MAPSCOMF,MAPSUTIL,MAPSQGPL,QTEMP,ACCTCOMM,ACCTDATA,INFLIBPRA,INPLIBPRA,UTILITIES,QGPL;"/>
</connectionStrings>

[miaomiaoga]

编辑器里是没有AS400 UDB和IBM DB2的配置的。

所以才要自己来写那一段。但试了还是不行。

[keepfool]

直接设置ConnectionString不行吗？ProviderName改一下？