|
MySQL Topic updated 6-6-2007 |
|
Requirements The GenWise provider works with both version 5.x and with version 4.x MySQL Servers. The import technique and the available datatypes are different depending on the server version. The GenWise Provider uses ODBC to retrieve metadata about database entities. If you use version 5, download and install the MySQL ODBC Connector from this location: http://dev.mysql.com/downloads/connector/odbc/5.0.html
If you use MySQL version 4, use the MySQL ODBC Connector 3.51: http://dev.mysql.com/downloads/connector/odbc/3.51.html Version 3.51.14.0 or higher is required, earlier versions cause errors.
If a MySQL Server package has been installed on your computer, you won't need to separately download and install a connector since these are also part of the server packages.
For the generated application the NHibernate Templates require the MySQL .NET Connector version 1.0.7 or higher: http://dev.mysql.com/downloads/connector/net/1.0.html The MySQL .NET Connector must be installed in the GAC (see Managing the Global Assembly Cache). The assembly to be installed in the GAC is MySql.Data.dll.
Connection The MySQL database provider connects you to a MySQL database and can synchronize your database to the datastore. The Driver dropdown list contains those MySQL ODBC Connectors which have been installed on your computer. Notice that you must manually specify the right MySQL Server version and the right driver (Connector) in the connection dialog. GenWise does not validate or detect your server version, nor which ODBC driver is appropriate.
|