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

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

來源:互聯網  2006-05-05 04:58:15  評論

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

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