MySQL Forums :: C#, Mono, .Net :: using ODBC connection with membership provider

I'm learning ASP/.NET/C# and mySQL concurrently and need some assistance with the basics. Thanks all...

I have good success on my local development using Sun's connector MySql.Data.MySqlClient

and the membership and role providers. I can locally add new users, control access to various pages, and render tables with no problems. But, my ISP hosing service does not support Sun's mySQL connector. They only allow the ODBC 3.51 driver.

providerName="System.Data.Odbc"

Using that connector I can render tables remotely on my ISPs implementation.
So, my next goal is to add membership and roles via the ODBC connector remotely. I can't seem to get the web.config set up correctly remotely to allow use of Sun's providers. Are they compatible with ODBC? I did upload the .dll files to the Bin folder.

When using the ODBC connector, do I need to create different custom role/membershop providers? Are samples available somewhere?

I found some ODBC provider samples on the MSDN site, but it used MS Access as the dB and not mySQL.

Thanks for any advice or samples of solutions.

Peace,
Kurt Angel
www.jamlab.us an Open Source Recording Project with tons of free music...