MySQL and ASP .NET membership (site admin) Problem
i'm including my webconfig file for this question. when i try to test my provider (any of them) from the provider tab in the website administration tool i get the following error:
Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
i'm using a MySql database (trying to anyway) i'm wondering if i don't have something correct in my config file.
on the security tab i get this error:
The following message may help in diagnosing the problem: Unable to initialize provider. Missing or incorrect schema. (C:\src\StudyTimeTracker\web.config line 23).
i'm using .NET 3.5 or higher, MySQL connector 5.2.7 (have also tried with 6.3), MySQL Workbench 5.2. I found a script that I ran to auto generate the tables in my MySQL db, although when I follow instructions on the various popular links out there, they all tell me that the schema should be autogenerated via the inclusion of the ' autogenerateschema="true" ' property that i add in my web config to the membership and other providers. i'll post the links to the various places that i've already been in a follow up to this one. this is a repost of a similar question but with a few more details