Database Mirroiring support

Thread is closed for posting
4 posts, 0 answers
  1. Rafael
    Rafael avatar
    5 posts
    Member since:
    Sep 2008

    Posted 15 Jun 2010 Link to this post

    Hi,

    We're using last version of OpenAccess and i have a Sql Server 2008 database that is mirroired for failover support.
    I search on the site be found nothing about this feature support in OpenAccess.

    Is it only related to the connection string?
    Where do i specify the "Failover Partner=failoverDB" ? in the Connection/connectionParams section?

    Thanks!

    Rafael Amaral
  2. Jan Blessenohl
    Admin
    Jan Blessenohl avatar
    707 posts

    Posted 16 Jun 2010 Link to this post

    Hello Rafael,

    There are two ways; with the new connection string support you can specify the sql server dependent connection string directly:

    <connection id="DatabaseConnection1">
        <connectionString>Data Source=TNSORA10;Unicode=True</connectionString>

    or you use the old mechanism and add a

    <connection id="DatabaseConnection1">
        <connectionParams>Failover Partner=failoverDB</connectionParams>

    to your existing connection node.

    Best wishes,
    Jan Blessenohl
    the Telerik team


    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  3. Rafael
    Rafael avatar
    5 posts
    Member since:
    Sep 2008

    Posted 22 Jun 2010 Link to this post

    Thanks for your awnser!

    One last question regarding the drivers ntds/genericADO2.
    • Do they both support a faillover partner?

    I changed from ntds to genericADO2 and on our preproduction environment (without a db mirroir) i'm getting the error:

    Unable to connect to Backend=mssql;Driver=genericADO2;Server=Bdd_primary_bitume_commerce;Port=1433;Database=Bitume_commerce;Integrated Security=false;User=sarenzaFO;Failover Partner=Bdd_partner_bitume_commerce;: Telerik.OpenAccess.RT.sql.SQLException: Please check, that the genericADO2 driver is not used with SQL Server 2000 as it does not support MARS; please use instead in the backendconfiguration element: backend="mssql" driver="ntds"   ---> System.InvalidOperationException: Server Bdd_partner_bitume_commerce, database Bitume_commerce is not configured for database mirroring.

    In our production environment it works.
    • So should i remove the failover partner declaration on my web.config on our pre production environment so i can use genericADO2 driver?
    • Does this means that IF a failover partner is specified, OpenAccess tries to connect to it and if it doesn't exists it fails even if the primary is responding?

    Rafael
  4. Jan Blessenohl
    Admin
    Jan Blessenohl avatar
    707 posts

    Posted 23 Jun 2010 Link to this post

    Hello Rafael,
    You should not use the ntds driver. The genericADO driver should work in all cases.

    We do notthing with the failover partner. All checks are done by the Microsoft ado driver. The error that you are getting from us might hide the real cause. If you catch the exception and print out exception.ToString() you should see the real exception somewhere inside the InnerExceptions.

    All the best,
    Jan Blessenohl
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Back to Top