SQL Server Mirroring and Failover Partner

Posts   
 
    
gabrielk avatar
gabrielk
User
Posts: 231
Joined: 01-Feb-2005
# Posted on: 01-Dec-2009 21:39:01   

Hi,

We're using LLBLGen 2.6, Selfservicing.

We want to use the integrated fail-over logic of the ADO/SQL Client in .NET.

It's described here:

http://msdn.microsoft.com/en-us/library/ms366348.aspx

http://msdn.microsoft.com/en-us/library/5h52hef8.aspx.

Does this work with the LLBLGen Selfservicing logic? We tried it, but it failed. Since we don't know if this is a LLBLGen issue or misconfiguration (we use this for the first time) I hope someone can tell me if this is possible using LLBLGen. And maybe share some knowledge/experiences.

Thanks, Gab

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 01-Dec-2009 21:50:51   

This is discussed here http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=16765&HighLight=1 and here http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=2129&HighLight=1 .

My suspicion is that you would be better off with Adapter rather than SelfServicing but that is only a guess.

When you say it fails, what exactly is the issue...?

Matt

gabrielk avatar
gabrielk
User
Posts: 231
Joined: 01-Feb-2005
# Posted on: 01-Dec-2009 23:43:17   

Hi,

I did see those threads, but they didn't answer my question.

But, after some playing around I found out that this fail-over mechanism does work!

When you also want to do this, make sure you check the Event viewer / SQL Logs, that are the real errors. The errors .NET will give you are not descriptive and not always right.

Also, make sure you have the SAME user on each database. Not just the same username/password but also the same SSID:

http://support.microsoft.com/kb/918992/

Works like a charm!

Cheers, Gab