天天看點

已經測試過的資料庫驅動for .NET DataMapper (IBatisNet),為什麼不支援.net2.0?

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

繼續閱讀