MSSQL accessing other database (Informix)

Hi,

I have this scenario where I am required to retrieved data from MSSQL and Informix database. I believe this integration can be done using the linked server in MSSQL.

I have managed to perform the linked server but I am facing some other problem at the moment. The following are the settings done

1. Downloaded the IBM Informix Client-SDK 2.81. Did the Setnet32 settings

2. Create ODBC using the IBM INFORMIX 3.82 32 BIT driver. Tested the connection, was successful. Did a DBPing to test the connection all was successful.

3. At the SQL Query Analyzer. ran the sp_addlinkedserver below
EXEC sp addlinkedserver
@server='elot_srv', --IBM Informix Server
@provider='MSDASQL',
@datasrc = 'CS3', --ODBC name
@srvproduct = '',
@provstr = 'DSN=CS3;Database=jnj;UID=xxx;PWD=xxx

4. After that, went to the SQL Server Enterprise Manager, under linked servers, found that the linked has been established. Click on the Tables icon and the list of tables in the database was displayed.

5. At the SQL Query Analyzer, tried to execute the following SQL
Select * from openquery (elot_srv, 'select order_no from
optdetm')
It gave me the following error

OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed] [OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed] [OLE/DB provider returned message: [Informix][Informix ODBC Driver][-11302] Insufficient Connection information was supplied] OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize
returned 0x80004005: ].

Please advise how do I go about solving this problem. Please help

Thanks and Regards,
Julie