ibatis连接Oracle 11g，是用asp.net开发的，我用oracleClient1.0连接Oracle 10g可以但11g不行，总是报Unable

Question

<provider 
name="oracleClient1.0" 
description="Oracle, Microsoft provider V1.0.5000.0" 
enabled="true" 
assemblyName="System.Data.OracleClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" connectionClass="System.Data.OracleClient.OracleConnection" 
commandClass="System.Data.OracleClient.OracleCommand" 
parameterClass="System.Data.OracleClient.OracleParameter" 
parameterDbTypeClass="System.Data.OracleClient.OracleType" 
parameterDbTypeProperty="OracleType" 
dataAdapterClass="System.Data.OracleClient.OracleDataAdapter" 
commandBuilderClass="System.Data.OracleClient.OracleCommandBuilder" 
usePositionalParameters="false" 
useParameterPrefixInSql="true" 
useParameterPrefixInParameter="false" 
parameterPrefix=":"/>电脑上安装的是.NET 2.0

Answer 1

用它，保證你問題能解決my blog
http://ufo-crackerx.blog.163.com/

Answer 2

<provider   
name="oracle11.1g"    
description="Oracle, oracle provider V11.1g"    
enabled="true"    
assemblyName="Oracle.DataAccess, Version=2.112.1.2, Culture=neutral, PublicKeyToken=89b483f429c47342"
connectionClass="Oracle.DataAccess.Client.OracleConnection"    
commandClass="Oracle.DataAccess.Client.OracleCommand"    
parameterClass="Oracle.DataAccess.Client.OracleParameter"    
parameterDbTypeClass="Oracle.DataAccess.Client.OracleDbType"    
parameterDbTypeProperty="OracleDbType"    
dataAdapterClass="Oracle.DataAccess.Client.OracleDataAdapter"    
commandBuilderClass="Oracle.DataAccess.Client.OracleCommandBuilder"    
usePositionalParameters="true"    
useParameterPrefixInSql="true"    
useParameterPrefixInParameter="true"    
parameterPrefix=":"    
useDeriveParameters="false"    
allowMARS="false"  />

Answer 3

新增Provider。。你帖出来的Provider还是1.0的

Answer 4

name="oracleClient1.0"  参考

Answer 5

推荐使用PDF.NET，它是从iBatis精简过来的，绝对好用！