ODBC for failover -- sql server odbc

Sue Hoegemeier
8/18/2003 12:06:27 PM

If you have a failover server defined, there is an option to
configure the ODBC data source to use a failover server.
Otherwise, I think you need to handle it yourself
programmatically.

-Sue

On Wed, 13 Aug 2003 08:21:29 -0700, "sergei"
[quoted text, click to view]

Susan
8/19/2003 2:46:38 PM

How do you define the failover server or where do you do
it? The option to use a failover server is grayed out on
my ODBC setup screens.

Susan

[quoted text, click to view]

Sue Hoegemeier
8/19/2003 5:08:38 PM

I think it may only be enabled when on a cluster box itself.
But it shouldn't really matter for an initial connection to
a cluster server anyway when I think about it. You only
connect to the virtual node which will go to whichever node
is active. If it fails while an app is running, you would
just reconnect and the same process happens. During
failover, client applications will lose their connection and
have to reconnect.

-Sue

On Tue, 19 Aug 2003 14:46:38 -0700, "Susan"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server odbc

sql server odbc : ODBC for failover