无法初始化提供者.模式丢失或不正确 [英] Unable to initialize provider. Missing or incorrect schema

问题描述

我已将服务器计算机升级为使用MySQL Connector 6.3.4，并且在我们的网站中还添加了成员​​资格角色提供程序.

I have upgraded my server machine to use MySQL Connector 6.3.4 and in our website we also added Membership role provider.

当我运行网站时，出现此错误.

When I run the website I am getting this error.

配置错误 说明:在处理服务于此请求所需的配置文件期间发生错误.请查看下面的特定错误详细信息，并适当地修改您的配置文件.

Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

解析器错误消息:无法初始化提供程序.架构缺失或不正确.

Parser Error Message: Unable to initialize provider. Missing or incorrect schema.

我的sql服务器的版本是5.0.90 community-net.

My sql server is version 5.0.90 community-net.

在升级连接器时，是否需要在服务器端进行任何更改

Is there any setting which have to be changes on server side while upgrading connector

这是我的web.config文件中的标记.

This is tag in my web.config file.

因为当我在本地计算机上运行网站时，它将成功运行，但是在服务器上，我无法运行它并且出现错误. 连接字符串没有错误

Since when I run the website on local machine it will run successfully, but on server I am not able to run it and getting above error. There is no mistake in connection string

在升级连接器时我们需要做的服务器端设置是什么.

What are server side setting which we to do while upgrading the connector....

谢谢

推荐答案

我自己也遇到了同样的问题.我正在使用Mysql连接器6.3.0.0 到目前为止，我在网上搜索时遇到了以下建议:

I myself running into the same problem. I m using Mysql connector 6.3.0.0 So far I came across following suggestions when seaching on net:

1) Add "MySql.Data.dll" & "MySql.Web.dll" into your application  "bin" folder.
2) Add reference to above to dlls in your application .
3) Add autogenerateschema="true" in your web.config file for required sections.
4) Check your Mysql connector version - make sure that the one that is in your bin folder is mentioned in your web.config file. 
5) Check your connection string - make sure it is correct and connected successfully.
6) Check mysql membership related table structure.
7) Check schema version in "my_aspnet_schemaversion" table (e.g since you have upgraded to newer version I insist you should check this).
8) If the problem is on remote machine (e.g Production Server) you may wan to check this : http://www.reggieburnett.com/referencing-connectornet-on-a-remote-machine 

我确定您可能会通过此列表，但是自升级到较新版本以来，我希望您检查"my_aspnet_schemaversion"表中的架构版本(例如，比较本地表和远程表的"version"字段值).

I m sure you may gone through this list but I would like you to check schema version in "my_aspnet_schemaversion" table (e.g compare "version" field value of your local and remote table) since your upgrading to newer version.

顺便说一句:我已经检查了此列表中的问题，但没有帮助.希望对您有所帮助.

BTW: I have checked this list for my problem but it did not help. I hope it may be of some help to you.

修改: 你好， 我们可以通过以下方法解决此错误:

Edit: Hi, We are able to fix this error by following:

1) Deleted the tables for memberships in the db and had the mysql membership provider regenerate them
2) than set the Aministration.config file to trust the Mysql Membership Provider (e.g related to IIS admin)

此致

Gaurav

这篇关于无法初始化提供者.模式丢失或不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！