欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

已经测试过的数据库驱动for .NET DataMapper (IBatisNet),为什么不支持.net2.0? DataMapper.netOracleSQL ServerMicrosoft 

程序员文章站 2022-05-09 19:52:45
...

今天在网上看了一下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