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?