Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server Cluster via ODBC?
Message
De
29/10/2009 17:02:48
Al Doman (En ligne)
M3 Enterprises Inc.
North Vancouver, Colombie Britannique, Canada
 
 
À
29/10/2009 09:26:05
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Divers
Thread ID:
01432193
Message ID:
01432292
Vues:
35
>Hello,
>
>we develop in .NET 3.5 Visual Studio 2008 and use MS SQL Server 2008.
>Up to now we connect to the SQL Server via a normal connection string and a native connection via TCP/IP.
>Now we have a SQL 2008 Server Cluster, with currently two machines.
>My question is now, how we should access the SQL Cluster?
>Our administrator told us to use a ODBC connection now, as the ODBC driver handles the fail over switching automatically.
>Is ODBC the way to go, or is the fail over thing also possible with a native connection?

If you're currently connecting to an IP address e.g. \\192.168.x.x\SomeInstanceName you will need to connect to the cluster's instance name, instead. To clients, the cluster appears as a single instance:

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

The SQL Native Client is newer than ODBC, I'd be surprised if it wouldn't handle failover properly (n.b. I don't have any direct experience with this). Nonetheless, if your admin tells you to use ODBC, it's probably a good idea to listen ;)
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform