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