General information
Title:
SQL Server Cluster via ODBC?
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only