ODBC Data Source On Clustered SQL Server

Giganews Newsgroups
Subject: ODBC Data Source On Clustered SQL Server
Posted by:  Bob C (Bo…@discussions.microsoft.com)
Date: Thu, 8 Feb 2007

We created an ODBC datasource on a SQL Server in the cluster. Then there was
a hardware failover and subsequently unrelated DTS processes failed because
the data source wasn't defined on the failover machine. Even though those
processes did not use the ODBC source, in fact nothing used the ODBC source,
it was just created to be used in testing.

So, how do you create an ODBC datasouce that will be cluster-wide and not
just machine specific? Do you have to do it through the Cluster Management
console?

Thanks,

Bob

Replies