First step in a long process of creating a Linked Server to an Informix database on a Sql 2008 (Win 2003 x64) cluster.
I was wondering how to go about creating an ODBC connection as a clustered resource, or if I even have to do that.
The OLE DB provider "MSDASQL" for linked server "__server__" reported an error. The provider reported an unexpected catastrophic failure. Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "__server__". (Microsoft SQL Server, Error: 7399)
More info: Using IBM's OLEDB and ODBC drivers. It worked on a dev instance but not on a nearly identically-configured prod instance.