Re: communication error when test fail over

When the user closes the app adn then re-opens it, it effectively reconnects.
Doesn't that in a way show the need for teh client to reconnect?

Linchi

"anoni" wrote:

I got those errors pop up while I was testing and our app would not
re-connect. Users can close app then re-open it.
How do I prove it is client app issue not sql cluster issue? I know the sql
cluster works fine.

Thanks

"anoni" wrote:



"Geoff N. Hiten" wrote:

A cluster failover is exactly the same as a shutdown and a restart. Users
will be disconnected. A cluster-friendly client application should
reconnect with minimum user intervention.

I got those errors pop up while I was testing and our app would not re-connect. Users can close app then re-open it.
How do I prove it is client app issue not sql cluster issue? I know the sql
cluster works fine.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP



"anoni" <anoni@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:316C153A-BA62-437C-A9B2-AA4F36CB4AA9@xxxxxxxxxxxxxxxx
I like the sql cluster to failover without disconnect the users or the
users
would not even notice the failover. Yes. users are able to reconnect to
it.
But users would lose data if they disconnected and need reconnect while
the
server1 failover server2.
Is sql cluster server suppose to failover flawless?

Thanks.

"Linchi Shea" wrote:

Do you have retry logic built into your client app? You need to
re-connect to
the instance.

Linchi

"anoni" wrote:

I get microsoft odbc sql server driver tcp/ip sockets general network
error
and microsoft odbc sql server driver communication link faillure errors
when
I open our client app and while I did a cluster failover.

Any reasons.

Thanks.






.

Relevant Pages

  • Re: Home Folders becoming unavailable
    ... Reconnecting is not a function of the cluster, but of the client software. ... The shares will come back online via the cluster. ... its up to the the clientto reconnect. ...
    (microsoft.public.windows.server.clustering)
  • Re: Are ASP.NET user interfaces essentially dead now?
    ... interactive interface work -- they are fundamentally not suited to get the ... (or whatever client you choose). ... based app interface, or I can spend 2 months for the same windowsforms based ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Using kerberosSecurity Throws Security Exception
    ... I am experiencing this error while trying to use a Windows XP client ... application to access a web service located on a W2k3 server. ... client app on the server, ... > Account with a Custom Principal Name using SetSPN.exe utility. ...
    (microsoft.public.dotnet.framework.webservices.enhancements)
  • Re: HTML vs Swing for U.I application architecture
    ... >> the latest web technologies. ... >> Swing to web any day of the week and twice on Sunday. ... but that is not an option for a cross platform app. ... When I wanted a thick client, ...
    (comp.lang.java.programmer)
  • Re: Architectural feedback
    ... Most functionality will be accessed from our ... > with WinForms-based apps (assume all client machines are Windows running ... > unified under a single app. ... > core app must reside on the client or may be run from the server. ...
    (microsoft.public.dotnet.general)