Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

MySQL and ASP .NET membership (site admin) Problem

Avatar of Michael Sterling
Michael SterlingFlag for United States of America asked on
Web Development.NET ProgrammingASP.NET
6 Comments1 Solution1217 ViewsLast Modified:
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:

Provider Management
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

what am i doing wrong? webconfig.txt
ASKER CERTIFIED SOLUTION
Avatar of Michael Sterling
Michael SterlingFlag of United States of America imageWeb Applications Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answers