ok SOLVED!!!
the solution is change official version of providers.config
so, to use MySql.Data with .NET 2.x framework the file must be like this:
--------------------------------------------------------------------------------------------------------------
<provider
name="MySql"
description="MySQL, MySQL provider 5.0.8.1" <---- change
enabled="true"
assemblyName="MySql.Data, Version=5.0.8.1, Culture=neutral,
PublicKeyToken=c5687fc88969c44d" <----- change connectionClass="
MySql.Data.MySqlClient.MySqlConnection"
commandClass="MySql.Data.MySqlClient.MySqlCommand"
parameterClass="MySql.Data.MySqlClient.MySqlParameter"
parameterDbTypeClass="MySql.Data.MySqlClient.MySqlDbType"
parameterDbTypeProperty="MySqlDbType"
dataAdapterClass="MySql.Data.MySqlClient.MySqlDataAdapter"
commandBuilderClass="MySql.Data.MySqlClient.MySqlCommandBuilder"
usePositionalParameters="false"
useParameterPrefixInSql="true"
useParameterPrefixInParameter="true"
parameterPrefix="?"
allowMARS="false"
/>
But now i've this error (simpler i hope :) ):
------------------------------
IBatisNet.DataMapper.Exceptions.DataMapperException: This SQL map does not
contain a MappedStatement named Select
in IBatisNet.DataMapper.SqlMapper.GetMappedStatement(String id)
in IBatisNet.DataMapper.SqlMapper.QueryForObject[T](String statementName,
Object parameterObject)
in HelloIbatis.Form1.button1_Click(Object sender, EventArgs e) in
C:\Documents and Settings\Serlab05\Documenti\Visual Studio
2005\Projects\HelloIbatis\HelloIbatis\Form1.cs:riga 32
2007/12/11, Giovanni D'Addabbo <[EMAIL PROTECTED]>:
>
> i've modified my providers.config and is this:
> ----------------------------
> <provider
> name="MySql"
> description="MySQL, MySQL provider 1.0.7.30072"
> enabled="true"
> assemblyName="MySql.Data, Version=1.0.7.30072, Culture=neutral,
> PublicKeyToken=c5687fc88969c44d" connectionClass="
> MySql.Data.MySqlClient.MySqlConnection"
> commandClass="MySql.Data.MySqlClient.MySqlCommand "
> parameterClass="MySql.Data.MySqlClient.MySqlParameter"
> parameterDbTypeClass="MySql.Data.MySqlClient.MySqlDbType"
> parameterDbTypeProperty="MySqlDbType"
> dataAdapterClass=" MySql.Data.MySqlClient.MySqlDataAdapter"
> commandBuilderClass="MySql.Data.MySqlClient.MySqlCommandBuilder"
> usePositionalParameters="false"
> useParameterPrefixInSql="true"
> useParameterPrefixInParameter="true"
> parameterPrefix="?"
> allowMARS="false"
> />
>
> and is installed, but i've this error:
> ----------------------------------------------------
> Check the MySql. ---> IBatisNet.Common.Exceptions.ConfigurationException:
> Could not configure providers. Unable to load provider named "MySql" not
> found, failed. Cause: Impossibile caricare il file o l'assembly '
> MySql.Data, Version=1.0.7.30072, Culture=neutral,
> PublicKeyToken=c5687fc88969c44d' o una delle relative dipendenze. La
> definizione di manifesto dell'assembly specificato non corrisponde al
> riferimento all'assembly. (Eccezione da HRESULT: 0x80131040) --->
> System.IO.FileLoadException: Impossibile caricare il file o l'assembly '
> MySql.Data, Version=1.0.7.30072, Culture=neutral,
> PublicKeyToken=c5687fc88969c44d' o una delle relative dipendenze. La
> definizione di manifesto dell'assembly specificato non corrisponde al
> riferimento all'assembly. (Eccezione da HRESULT: 0x80131040)
>
> it doesn't find the MySql.Data...but i've also added it to the
> references...
> but i think that the error i think in because it uses 1.0.7.30072 ... so
> go to mysql.com and download this version, but this version is for .NET
> framework 1.xxx and so i can't use it...
> so, exist some mothod to work with ibatis + .NET 2 + mysql?
> byeezzzzzzzzz
>
> 2007/12/11, Clough, Samuel (USPC.PRG.Atlanta) <[EMAIL PROTECTED]
> >:
> >
> > Just modify your providers.config to match whatever provider you have
> > installed and want to use…
> >
> >
> >
> > *From:* Giovanni D'Addabbo [mailto:[EMAIL PROTECTED]
> > *Sent:* Tuesday, December 11, 2007 9:54 AM
> > *To:* [email protected]
> > *Subject:* Re: Ibatis + .NET framework 2.0 = errors?
> >
> >
> >
> > yes but if i enable ByteFx it require me...and i've a byteFx version for
> > .Net 1.xx.xx and not for 2.xx.xx
> > so i've enabled MySql (because i've the exact connector, i've tried to
> > do a manual connection and work...) but the error is that i've attached to
> > this mail...
> > so my question is: what are the connector providers for .NET framework
> > 2.xxx ?
> > or... how can i use .NET 2.xx + ibatis + mysql?
> > byeeeezzzzzz
> >
> > 2007/12/11, Clyde Coolidge < [EMAIL PROTECTED]>:
> >
> > In your providers.config, have you tried setting the enabled property of
> > the "BytePx" provider to true?
> >
> > ---------- Forwarded message ----------
> > From: "Giovanni D'Addabbo" < [EMAIL PROTECTED]>
> > To: [email protected]
> > Date: Tue, 11 Dec 2007 15:27:56 +0100
> > Subject: Re: Ibatis + .NET framework 2.0 = errors?
> > ok i've MySql Connector (from www.mysql.com )
> > i've installed and imported it
> > but it doesn't work...
> > ideas?
> > byeeeeeeeezzzzzzzz
> >
> > 2007/12/11, Giovanni D'Addabbo < [EMAIL PROTECTED]>:
> >
> > ok is possibile...where can i find a mysql provider compatible with .NET
> > 2.0 framework?
> > i've see bytefx but it require 1.x .NET framework...
> > tnx 10000
> >
> >
> >
> > 2007/12/11, Clough, Samuel ( USPC.PRG.Atlanta) <
> > [EMAIL PROTECTED]>:
> >
> > Well, based on that message I would make sure you have the MySQL
> > Provider installed and that the installed version matches what's defined in
> > your provider file. My guess is that it doesn't.
> >
> >
> >
> > .......
> >
> >
> >
> >
> >
> >
> > --
> > Giovanni D'Addabbo
> > UIN: 22490534
> > ------------------------------
> > *
> >
> > Princeton Retirement Group, Inc - Important Terms
> > *
> >
> > This E-mail is not intended for distribution to, or use by, any person
> > or entity in any location where such distribution or use would be contrary
> > to law or regulation, or which would subject Princeton Retirement Group,
> > Inc. or any affiliate to any registration requirement within such location.
> >
> > This E-mail may contain privileged or confidential information or may
> > otherwise be protected by work product immunity or other legal rules. No
> > confidentiality or privilege is waived or lost by any mistransmission.
> > Access, copying or re-use of information by non-intended or non-authorized
> > recipients is prohibited. If you are not an intended recipient of this
> > E-mail, please notify the sender, delete it and do not read, act upon,
> > print, disclose, copy, retain or redistribute any portion of this E-mail.
> >
> > The transmission and content of this E-mail cannot be guaranteed to be
> > secure or error-free. Therefore, we cannot represent that the information in
> > this E-mail is complete, accurate, uncorrupted, timely or free of viruses,
> > and Princeton Retirement Group, Inc. cannot accept any liability for E-mails
> > that have been altered in the course of delivery. Princeton Retirement
> > Group, Inc. reserves the right to monitor, review and retain all electronic
> > communications, including E-mail, traveling through its networks and systems
> > (subject to and in accordance with local laws). If any of your details are
> > incorrect or if you no longer wish to receive mailings such as this by
> > E-mail please contact the sender by reply E-mail.
> > ------------------------------
> >
>
>
>
> --
> Giovanni D'Addabbo
> UIN: 22490534
>
--
Giovanni D'Addabbo
UIN: 22490534
