+1-888-365-2779
Try Now
More in this section

Forums / Set-up & Installation / SOLVED: Exception of type 'Telerik.DataAccess.ProviderDatabaseUpgradeException' was thrown.

SOLVED: Exception of type 'Telerik.DataAccess.ProviderDatabaseUpgradeException' was thrown.

5 posts, 0 answered
  1. Mike Bentzen
    Mike Bentzen avatar
    11 posts
    Registered:
    10 May 2010
    02 Sep 2010
    Link to this post
    Hi,

    I just thought I might put up our experiences with this error. We had taken an exact copy of our installation, and put it on our webhost. No upgrade, no other changes.

    We were scratching our heads for ages, as only two other people on these forums received this error, and the suggestions were about upgrading the database in a full trust environment. We didn't upgrade the database, we had already created one content item per module, and we still received this error message.

    It turned out to be a database user permissions error. When copying the database from an SQL 2005 instance to Sql server 2000 instance, we didn't take a note of which user was logged in. The tables and stored procedures were not able to be accessed by the specified SQL connection string and this was the resulting error when we visited the website. If you get this error, check the permissions and make sure that the user can access the appropriate tables/stored procs.

    Kind Regards,

    Mike

  2. Nabanita
    Nabanita avatar
    22 posts
    Registered:
    18 Oct 2010
    02 Jun 2011
    Link to this post
    Hello,

    I have got the same problem. I want to host my site with sitefinity in a shared server with medium trust level. I check the connection string in a very simple way with a default page. The connection string is working. My Databse is in 2008 sql server.

    Error:

    Exception of type 'Telerik.DataAccess.ProviderDatabaseUpgradeException' was thrown.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: Telerik.DataAccess.ProviderDatabaseUpgradeException: Exception of type 'Telerik.DataAccess.ProviderDatabaseUpgradeException' was thrown.


    Version Information: Microsoft .NET Framework Version:2.0.50727.4211; ASP.NET Version:2.0.50727.4209

    Please help.
    Nabanita
  3. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    02 Jun 2011
    Link to this post
    Hello Nabanita,

    The Upgrade method is called when  you are trying to upgrade the database or the schema version. You are trying to upgrade the database( for instance you have two websites or single website which uses different version from this one that was initially connected to the website) and since you are not running in Full Trust level and PermissionState.Unrestricted is false an error of type ProviderDatabaseUpgradeException is thrown. Please run the website locally in Full Trust so that the database will be upgraded properly. Then reupload the website and the local database to your host.


    Regards,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  4. Nabanita
    Nabanita avatar
    22 posts
    Registered:
    18 Oct 2010
    02 Jun 2011
    Link to this post
    Hello,

    I have done what you suggested.
    Now I have done with sql server 2008 but the site was created with sql server 2005.
     But in local it is showing me an error:

    Can't load driver Telerik.DataAccess.Providers.ExtendedSqlServer2008Provider, Telerik.DataAccess from assembly .  Check driver and driverAttribute values from application config file.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: Nolics.ORMapper.Base.NolnetException: Can't load driver Telerik.DataAccess.Providers.ExtendedSqlServer2008Provider, Telerik.DataAccess from assembly .  Check driver and driverAttribute values from application config file.

    Please help on this.
    Eagerly waiting for your feedback.
    Nabanita
  5. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    07 Jun 2011
    Link to this post
    Hi,

    The driver is the same for SQL 2005 and 2008

    <add name="DefaultConnection" driver="Telerik.DataAccess.Providers.ExtendedSqlServer2005Provider, Telerik.DataAccess"
                      connectionStringName="Sitefinity" />


    Regards,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Register for webinar
5 posts, 0 answered