Feb 15, 2012  ODBC Informix connection creates empty rows if Service Pack 1 is loaded onto the Server. OLEDB Informix, datareader sources fail if free text fields contain control characters.
Manager
[ View Thread ][ Post Response ][ Return to Index ][ Read Prev Msg ][ Read Next Msg ]

IDS Forum

Informix connection manager

Posted By: SANJEEWA GUNASEKARA <Send E-Mail>
Date: Tuesday, 10 December 2013, at 11:11 p.m.

G'day All,
Can someone give me a clue on deriving values to be used in ODBC within the context of following connection manager example ? If so that would be a great help in a situation where training will not be avaialble to cover up such topics.
I am going through IBM Informix documentation on their web site
http://pic.dhe.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm.admin.doc%2Fids_admin_1176.htm
as some study material for a project that we are trying to do and it is very hard for me to understand how a connection manager group settings are used in following application/ODBC parameters.
Informix Server : ifx_cm
Hostname : ?????????????
Manager
Service/Port : ?????????????
rest of the values will be common for both servers (database name etc)
Is there a common hostname that can be used or it has to be either cm1_machine or cm2_machine ? When cm1_machine is used by a client and if cm1_machine goes offline, how does client connect to cm2_machine automatically ?
Thanks and Regards - Sanjeewa
Context: (using multiple instances of connection manager to avoid single point of failure)
dbservername nettype hostname servicename options
ifx_pri onsoctcp p_machine ifxsrv0pri
# ifx_cm group
ifx_cm group - - c=1
ifx_cm1 onsoctcp cm1_machine cm1_port1 g=ifx_cm
ifx_cm2 onsoctcp cm2_machine cm2_port2 g=ifx_cm
  • Informix connection manager(views: 904)
    SANJEEWA GUNASEKARA -- Tuesday, 10 December 2013, at 11:11 p.m.
    • RE: Informix connection manager(views: 644)
      Justin Killen -- Wednesday, 11 December 2013, at 7:06 p.m.
      • Re: RE: Informix connection manager(views: 433)
        SANJEEWA GUNASEKARA -- Wednesday, 11 December 2013, at 9:28 p.m.
[ View Thread ][ Post Response ][ Return to Index ][ Read Prev Msg ][ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.

I have a customer for whom I am building a data warehouse solution using SQL server 2008.
Source data comes in many forms including SQL Server 2000, SQL Server 2005, flat files (csv), Excel and Informix.
SSIS handles connections to older versions of SQL Server perfectly as expected and does a pretty good job with Excel and flat files but INFORMIX is a major pain in the backside and, as expected, neither Microsoft or IBM are particularly helpful.
The data warehouse server in question is Windows Server 64bit and my development machine is Windows 7 professional 64 bit but you cannot just install 64 bit INFORMIX ODBC drivers as Visual Studio (BIDS) is 32 bit.
If you simply install the 64 bit INFORMIX ODBC driver you will see the driver in the ODBC manager but you will not be able to use it. If you try to install the 32 bit driver from the IBM site then it will baulk stating that it is incorrect version for your system. Installation of an older 32 bit driver will work and can be administered via C:WindowsSysWOW64odbcad32.exe but you might end up with the “INFORMIX 3.32 32 BIT” driver which just does not work. What you need is the “IBM INFORMIX ODBC DRIVER” from the 32 bit SDK.
Once you have the ODBC driver you will also need to set up the connection and for this you might need to learn about SETNET32, the services file in Windows, the SQLHosts registry entries and you might be just a little confused about how to create the connection in SSIS as it is a little different to all the other types of connection.
Rather than repeat an already excellent article I suggest you follow this link to an excellent step by step installation and setup guide from Dinesh (DSP).
Connecting Informix databases through SSIS