I am trying to connect mysql from nhibernate. I am using Visual Stido 2003.

I am getting the below error.
Additional information: Could not create the driver from NHibernate.Driver.MySqlDataDriver.

My hibernate.cfg.xml is as follows.

<?xml version="1.0" encoding="UTF-8"?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.0" >
<session-factory>
<property name="dialect">NHibernate.Dialect.MySQLDialect</property>
<property name="connection.provider">NHibernate.Connection.DriverConnection
Provider</property>
<property name="connection.driver_class">NHibernate.Driver.MySqlDataDriver
</property>
<property name="connection.connection_string">Server=xxxxx;initial catalog=test;Integrated Security=false;UID=root;PWD=xxxx</property>
<mapping file="C:\Vijay\tryOr\Customer\Cust.hbm.xml" />
<mapping assembly="Customer" />
</session-factory>
</hibernate-configuration>

can some one help me to resolve this?

Thanks in advance.

Hello.

I think your connection string isn't right.

I use something like this (in web.config):

I am trying with a console application to connect to the mysql server.
I tried changing the config to the one given but didn't work.

Can some one let me know how the hibernate.cfg.xml config should be for connecting the mysql server?

Thanks

the NHibernate.Driver.MySqlDataDriver uses mysql.data.dll, copy mysql.data.dll to your executable directory. As far as i can recall it uses version 1.04 of mysql.data.dll. u can download the mysql connector from mysql website, if u dont have it