Alberto,
You might check your SQLMap.config (or DAO.config if your using the Data
Access interfaces) and make sure your <database><provider> is set
"sqlServer2005".
Also make sure the providers.config file that you edited is in fact the
one in you bin / debug or / release directory i.e. the file can be loaded
by the assembly.
Also do you have the SQL Server 2005 provider installed on your client?
Dumb question probably but never hurts to ask... :))
I believe you can also use the "sqlServer2.0" entry as that entry and the
one for 2005 looks to be identical.
I might suggest if you can
Best regards,
Mark Gillen
Assurant Corporate Technology (ACT)
Business & Enterprise Application Services
Miami -T-2, Technology Bldg.
(305) 253-2244 Ext. 32013
mark.gil...@assurant.com
"Acevedo, Alberto Mr CIV USA AMC" <alberto.acev...@us.army.mil>
02/12/2009 10:40 AM
Please respond to
user-cs@ibatis.apache.org
To
<user-cs@ibatis.apache.org>
cc
Subject
ibatis.net & sqlserver2005 & provider not loading
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
**************************************************************************************
This e-mail message and all attachments transmitted with it may contain legally
privileged and/or confidential information intended solely for the use of the
addressee(s). If the reader of this message is not the intended recipient, you
are hereby notified that any reading, dissemination, distribution, copying,
forwarding or other use of this message or its attachments is strictly
prohibited. If you have received this message in error, please notify the
sender immediately and delete this message and all copies and backups thereof.
Thank you.
**************************************************************************************
