| Title: | WinNT-Clusters |
| Notice: | Info directories moved to DECWET::SHARE1$:[NT_CLSTR] |
| Moderator: | DECWET::CAPPELLOF |
| Created: | Thu Oct 19 1995 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 863 |
| Total number of notes: | 3478 |
Hi,
I have a customer just installed NT Cluster 1.1 and SQL Server 6.5.
The cluster software seems to work correctly, the share disks can be
failover. After we create the SQL Server failover group and object,
the SQL can failover correctly. Then the customer tried connecting his
client (SQL Server) to the Cluster thru the alias, he then tried select
some data from his database, and forced the failover. His client
does not detect the failover happens on the server side i.e. no
message, etc. After the client finished, he checked the output and
found that not all rows were retrieved from the SQL Server on the
Cluster. This situation will absolutely give him a big error when
his application is summarizing the data from database and the failover
occur in between.
The customer would like us to explain why this happened. How can
he trust the cluster? Or what should they do? Did we set anything
incorrectly?
Do we need the cluster-aware client so that it knows that the
failure occurs and pause for a little while until the cluster gets
back? And how can we make the cluster-aware application? (I heard
that we don't have the cluster API, is it true?)
Regards,
akkamon srihiran
Technical Support (WNT)
Digital Thailand
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 799.1 | What client program? | DECWET::CAPPELLOF | My other brain is a polymer | Tue May 13 1997 12:03 | 4 |
Did the customer use his own client program? I have noticed that I
don't always get errors from ISQL/W when a failover occurs.
He SHOULD see some error.
| |||||
| 799.2 | Customer use his own client | TLAV01::AKKAMON | Land of Smail :) | Thu May 15 1997 09:15 | 14 |
Hi,
The customer wrote his own program and compile it as .EXE. After
he execture the program and the failover occured, his client terminated
without any error messages (that's what he told me). His client
program connects to the server database, select rows and do the summary
of all data.
Any suggestions would be appreciated. I used to configure the
cluster with Oracle database, when I use the oracle SQL on windows
client, when the failover occurs it just disconnects and I have to
reconnect again.
regards,
akkamon
| |||||