Create ODBC Informix data source

Question

Problem: I need to register a INFORMIX data source and I’m not getting it. I enter the parameters, but always error occurs. What should I do?

Answer 1

You have to use a connection DRDA to the instance, and apparently the data you’re putting up does not belong to a.

So you can confirm if there’s a connection DRDA configured you can run the following query:

SELECT
    dbsvrnm,
    hostname,
    svcname
FROM 
    sysmaster:syssqlhosts
WHERE 
    svrtype = 'dr';

Then confirms whether the dbsvrnm is part of the instance alias, you can run the following query:

SELECT  cf_effective
FROM    sysmaster:syscfgtab 
WHERE   cf_name = 'DBSERVERALIASES';

Not existing configured you have to follow the steps in manual.