question

I have a problem with establishing a linked server between SQL Server 2008 64 bit on Windows 7 to Informix database on CentOS(linux). I was struggling a bit with first part of configuration on Windows machine and setting it up in ODBC but finally it was successful, I was able to make test connection via ConnectTestDemo application provided with Informix CSDK 4.10 64bit package. So, just to mention what I did: • IBM Informix CSDK 4.10 was installed • Setnet32 was configured with IBM Informix Server name ix_dbserver • ODBC user data source was configured and I was able to performed successful test connection • With ConnectTest Demo application I was able to fetch rows from the database - let’s call dbname - which I am interested to linked in SQL Server • As IBM site says ( http://www-01.ibm.com/support/docview.wss?uid=swg21195578) I registered ifxoledbc provider, I didn’t execute the coledb.sql query yet since I guess I would get the error message which is mentioned on the site whereas I am still getting different one. • I set up linked server with following command: EXEC master.dbo.sp_addlinkedserver @server = N'TEST', @srvproduct=N'Ifxoledbc', @provider=N'Ifxoledbc', @datasrc=N'dbname@ix_dbserver' Go EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'TEST', @useself=N'False', @locallogin=null, @rmtuser=N'root', @rmtpassword='password' GO After execution of simple test query I got following error message(the same message when I was creating linked server from GUI): Cannot initialize the data source object of OLE DB provider "Ifxoledbc" for linked server "TEST". (Microsoft SQL Server, Error: 7303) I browsed hundreds of pages and cannot find any answer which help me to properly create linked server to Informix database, I appreciate any help which move me step forward in this task. Best regards, Bartek