Unanswered: Linking an Informix DB with SQL Server 2000
I've been trying for several hours to link an Informix database to a Windows 2000 machine running SQL Server 2000. I installed the latest IBM Client SDK for Informix as well as SP3 for SQL Server 2000.
I created a system DSN, let's name is myDSN, which I tested and connects properly to the database. Then from SQL Server Enterprise Manager, I created a linked table with the following parameters:
Provider Name: IBM Informix OLE DB Provider
Data source name: myDSN
Provider string: "User ID=username;Password=password"
I tried various provider strings like
"User ID=username;Password=password;Data Source=myDSN"
"User ID=username;Password=password;Data Source=mydb@myserver"
"Provider=Ifxoledbc.2;User ID=username;Password=password;Data Source=mydb@myserver"
None seem to work. Everytime I want to list the tables from the Informix DB, (by clicking on Tables in the Enterprise Manager), I get the following error:
Had the same issue at my shop and never resolved it. In fact, we scrapped the IBM provider altogether and use a third party driver called Sequelink.
It works fine and is a whole lot simpler to configure, just have to live in constant fear that IBM will come along with a patch or upgrade someday that will break it. I have a really old version thats been working for years, but you can check it out at:
I hope its okay to post the link here...I have no relationship with the company what so ever and in fact we jsut bought a bunch of licenses and didnt even purchase support for the product and have not had a reason to talk to them since!
Its always in the back of my mind though that we should try and use IBM's version since it seems logical that it would be better or at least safer, but it is such a chore to configure and then theres the issue we run into when using it with SQL server I just hate to fool with it.