I'm using mysql connector -net version 1.0.4 and i can't connect MySQL DB. i got the following message.



How i m doing : i have install the connector and i added refernece to mysqldata.dll and i put local copie to true moreover i tried that with many version of connector (1.0.3 , 1.0.1) and i got the same problem.

Does any one have any suggestion ???

Regards.

That first error is harmless, ignore it for now.
The second error actually comes from MySQL connector, so it works, but there is some problem. It's hard to say what the problem is, try to configure logging (see http://wiki.nhibernate.org/display/NH/Configuring+log4net+Logging), maybe you'll find something.

Hello,

Thanks u for your reply, it could help to resolve the first problem, so i ve no more the following error message :



But i still have the second problem, so no connection to database.



I just want to know which MySQL Connector is used generaly ?? because when i can connect the database using odbc but i get another problem.

regards

NB : I don't think that mysql connector is working because i get the same problem when i take it off (i delete the refernce).

It doesn't depend on having a reference or not, NHibernate loads the provider dlls using LoadAssembly call or something like that, so as long as the connector dll is in the same directory as your application, NH will pick it up. Or you can have the connector in the GAC and that one gets picked up always.

By the way, look at this bug: http://bugs.mysql.com/bug.php?id=7528. Maybe it's related to your problem. Ensure you have at least version 1.0.3 of the connector.

Hello ,

I ve alredy been there!! and i effectively have 1.0.3. I ve droped connector.dll from the project folder ( No trace of the connector) and i got the same error message. Another thing i reput the connect and i stopped the database server and i got the same error message. And what i noticed is that the problem appear when i try to begin transaction



once i put it into comment the message disapear but it's impossible to work without transaction.

Has that given u any ideas ???

Thank u very much for the helps;

Regards

Now i could connect the database using the following code



But when i try to insert an object into the database i get the followinf error message.

[/code]

It's hard to tell what the error is from the error message. It would be best if you could provide the stack trace and the inner exceptions.

Thanks u Sergey for your replies.

I finnaly found the problem and i resolve it. It was due to the value of CharSet in the configuration file and the program worked.
I think it will be interesting to add a topic about this variable in the documentation.I spent more than week trying to resolve the problem.

Regards