今天在网上看了一下IBatisNet for .net,和java中的ibatis同出Apache,基本原理与配置类似。自己晚上写了一个Sample,用的是DataMapper 1.3,开发工具是 vs2005, 运行环境是.net2.0。 运行,倒!报错:
[SqlException (0x80131904): 用户 'sa' 登录失败。] System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString) +87 [DataMapperException: Unable to open connection to "Microsoft SQL Server 7.0/2000, provider V1.0.5000.0 in framework .NET V1.1".] IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString) +319 IBatisNet.DataMapper.SqlMapSession.OpenConnection() +21 IBatisNet.DataMapper.SqlMapper.QueryForList(String statementName, Object parameterObject) +86
就搞不大明白了,我在“善友”的blog上看他写到:
“ IBatisNet 1.3也将直接支持DotNet 2.0的数据方面两大特性:Nullable和泛型,IBatisNet 1.3也直接支持Sql server 2005。”
为什么运行时,报告Unable to open connection to "Microsoft SQL Server 7.0/2000, provider V1.0.5000.0 in framework .NET V1.1"., 我明明配置的provider是sqlServer2.0?
查了下Apache的官方网站,目前已经测试过的数据库驱动 for.NET DataMapper (IBatisNet)如下表,居然没有支持.net2.0的??
如果哪位大峡做过相关开发,望告知小弟!
database name | database version | provider | version | notes |
---|---|---|---|---|
DB2 | DB2 iSeries | IBM DB2 iSeries | 10.0 | not fully tested |
Firebird | 1.5 | Firebird SQL .NET provider | 1.7 | not fully tested |
MS Access | 2000 | Microsoft | .NET Framework 1.1 OLEDB | |
MS SQL Server | 2000 | Microsoft | .NET Framework 1.0 System.Data.SqlClient | |
MS SQL Server | 2000 | Microsoft | .NET Framework 1.1 System.Data.SqlClient | |
MS SQL Server | 2000 | Microsoft | .NET Framework 1.1 OLEDB | |
MS SQL Server | 2000 | Microsoft | .NET Framework 1.1 ODBC | |
MySQL | 4.1 | ByteFx | 0.7.6 | |
MySQL | 4.1 | MySQL Connector/Net | 1.0.5 | |
Oracle | 10g | Microsoft | .NET Framework 1.1 System.Data.OracleClient | currently easier to use with the DataMapper vs ODP.NET |
Oracle | 10g | Oracle | ODP.NET 10g | |
Oracle | 9i | Microsoft | .NET Framework 1.1 System.Data.OracleClient | |
Oracle | 9i | Oracle | ODP.NET 10g | |
PostgreSQL | 8 | Npgsql | 0.7 | |
PostgreSQL | 7.5 | Npgsql | 0.7 | |
SQLite | 3.2 | SQLite | SQLite.NET provider V0.21 | not fully tested |