Login Skip Navigation LinksWilsonORMapper > Forums Search
Demo Version Demo Version
Download and try for yourself a fully working demo version, including sample apps and documentation.  The only limitation is that the demo version only works inside the debugger.

PayPal Subscribe
Get It All for $50 USD:
WebPortal, ORMapper,
Source Code, All Updates
PayPal

User Login User Login
Log In
 
 
Reset Password

Wilson ORMapper Forums Wilson ORMapper Forums : Templates & More : ORHelper with MySQL

Date Post
10/27/2005 10:09:43 AM Is there a way to use a custom provider with ORHelper without modifying the source? I am using 4.2.0.1.

I'm trying to use MySQL with "Provider=MySql.Data;Other=MySql.Data.MySqlClient.MySqlConnection;Database=mydb;host=localhost;port=3306;uid=id;pwd=password;" but I get "mysql.data provider is not registered on the machine".

I added mysql.data.dll to the GAC but it doesn't help.

Thanks,

Francis
10/29/2005 6:03:12 AM The ORHelper uses OleDb and only OleDb -- even the MS Sql and Oracle cases use OleDb (note that this is not the case for the ORMapper). So if you can setup an OleDb driver for MySql then you should be able to get it to work that way.

Thanks, Paul Wilson
4/22/2006 2:43:41 AM

What does that mean "setup an OleDb driver for MySql"? How would you do this?

-Ian
4/22/2006 2:52:30 AM Hi Ian:

Find and download an OleDb driver for MySql (I found several pretty quickly on Google, but I'm not in a position to recommend any one in particular), install it and read the docs to determine what your connection string should be, and then select the OleDb option and the ORHelper and specify your connection string.

Thanks, Paul Wilson