Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server Cluster via ODBC?
Message
From
29/10/2009 09:26:05
 
 
To
All
General information
Forum:
ASP.NET
Category:
Databases
Title:
SQL Server Cluster via ODBC?
Miscellaneous
Thread ID:
01432193
Message ID:
01432193
Views:
93
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?

Thanks
Thomas
Next
Reply
Map
View

Click here to load this message in the networking platform