Create Informix ODBC Data Source

0

Problem: I need to register a INFORMIX data source and I can not. I enter the parameters, but there is always an error. What should I do?

    
asked by anonymous 20.05.2016 / 21:19

1 answer

0

You need to use a DRDA link to the instance, and apparently the data you are putting does not belong to one.

In order to confirm that a DRDA link exists, you can run the following query:

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

After confirming that dbsvrnm is part of the instance alias, you can execute the following query:

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

Not having set up you have to follow the steps in manual .

    
31.05.2016 / 14:22