I spent several days trying to fix this problem but no success so far. I
found some solutions in the mailing list but none of them worked. I'm
using iBatis.Net (IBatis.DataMapper.1.6.2), Visual Studio 2005, and SQL
server 2005. The problem is that iBatis can't load the provider. This is
my provider in provider.config:
<provider
name="sqlServer2005"
enabled="true"
description="Microsoft SQL Server, provider V2.0.0.0 in framework
.NET V2.0"
assemblyName="System.Data, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
connectionClass="System.Data.SqlClient.SqlConnection"
commandClass="System.Data.SqlClient.SqlCommand"
parameterClass="System.Data.SqlClient.SqlParameter"
parameterDbTypeClass="System.Data.SqlDbType"
parameterDbTypeProperty="SqlDbType"
dataAdapterClass="System.Data.SqlClient.SqlDataAdapter"
commandBuilderClass="System.Data.SqlClient.SqlCommandBuilder"
usePositionalParameters ="false"
useParameterPrefixInSql ="true"
useParameterPrefixInParameter ="true"
parameterPrefix="@"
allowMARS="true"
/>
I was able to connect to Access using the provider for an Access
database but It fails with SQL Server 2005. This is the exact error:
Could not configure providers. Unable to load provider named
\"sqlServer2005"\ not found. Cause: The type initializer for
'System.data.sqlClient.SqlConnection' threw an exception.
I supect it is the version and PublicKeyToken. Have anyone encounter
this problem or know what I need to do to fix it?
Any help will be appreciated.
Thanks,
Alberto Acevedo
Computer Engineer
US Army CERDEC SED/ABSD
Fort Monmouth , New Jersey
(732) 532-6191