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