Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

The linked server "lives" in the clustered SQL Server instance, so whichever node the SQL Server happens to be running on, the linked server should run fine....as long as you've installed the required ODBC/OLEDB driver(s) on each node.

Looking at that error, I'm assuming the linked server doesn't work at all on any node. I suspect you'd have the same problem on a standalone SQL Server too - it seems to me to be a driver issue. Whose OLEDB driver are you using?

I'm sure you've read the following IBM KB: http://www-01.ibm.com/support/docview.wss?uid=swg21195578

share|improve this answer
    
Thanks for your reply. I've followed that guide with the same result. I ran this on a test server that is the same OS/SQL versions without any sort of issue. I had to install the MSDASQL 64 bit provider on both. The dev server went just fine, the prod server --- error. –  swasheck Mar 8 '12 at 21:00
    
Sorry. I'm using IBM's Informix CSDK (clientsdk.3.50.FC6DE.WIN) –  swasheck Mar 8 '12 at 21:15
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.