Hi,

I'm trying to connect NHibernate to a MySQL database, following the lead of the NHibernate Quick Start Guide.
It works fine using a user provided connection like this:
ISession session = factory.OpenSession(myConnection);

However when using a NHibernate provided connection ( ISession session = factory.OpenSession();) I get an error "cannot open connection" when starting a transaction or simply accessing the database.
I get the same error when trying to access the session.Connection property (so I can't check it either).

The session.IsOpen and session.IsConnected properties are both true.
A correct connectionstring is provided through the app.config file and it is verified to be present in the Configuration object.

NHibernate newbie, using Visual Studio 2005, C#, MySQL 4.1.1.13a-nt, MySQL connector/NET 1.0.07, NHibernate 1.0.2.
I tried different connection strings, moving/copying/reinstalling assemblies, several other tutorials but the problem remains.

What am I missing?

Your help is much appreciated.
Regards Tonn.

Please post the entire exception information, including stack trace and inner exceptions.

Thanks, Sergey. Good tip!

Hadn't gone deep enough.
FYI: "cannot open connection" > "Could not create connection from Driver" > #42000Unknown character set: 'Win1250'

MySQL doesn't support this character set. Nor does id support Win1252 or iso-8859-1. There is an impressive amount of NHibernate / MySQL examples around that can't work.

Solution: do not specify a CharSet (which is using the default) or specify 'latin1' if you want to use codepage 1252 like I do.
Find character sets supported by MySQL here: http://dev.mysql.com/doc/refman/5.1/en/charset-charsets.html