Kwisatz78 (2/18/2013)
I just did a quick read of this:http://msdn.microsoft.com/en-gb/library/hh213080.aspx#CreateAddiitListener
However if using 2 static IPs of different subnets and you use the listener name in your connection string, then the client you use should resolve the listener name to the correct IP for that subnet and hence you should be connected to your current primary.
Thats how I read it although I could be wrong.
Yes but this depends on the client right? If the client does not support multi-subnet failover then I don't think its safe to use the listener name because it does not know that the server could be listening on more than one address. This is what I have found from testing but I just wanted to confirm that this is the expected behavior.