Mark, I just found the problem. It was a bad configuration in the app.config. I removed the bad configuration and iBatis was able to connect to SQL Server 2005.
Thanks very much for your help, Alberto Acevedo Computer Engineer US Army CERDEC SED/ABSD Fort Monmouth , New Jersey (732) 532-6191 -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Thursday, February 12, 2009 10:56 AM To: [email protected] Subject: Re: ibatis.net & sqlserver2005 & provider not loading 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 [email protected] "Acevedo, Alberto Mr CIV USA AMC" <[email protected]> 02/12/2009 10:40 AM Please respond to [email protected] To <[email protected]> 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. ________________________________
