CMS R21 ODBC - Cant Connect

[Stinney]

Anyone on CMS R21 and can connect with ODBC?

We were told we have to install new ODBC drivers HCL Informix, which we did and got the files from our vendor.

Using all the standard installation and configurations in the ODBC setup are just not working.

This is the error we get.


There should be nothing wrong with connecting to the server on the IP and port needed there is no firewall. Can access the server on TCP 22 as well.

Also, checked and informix is running on the CMS and the port is listening.


This is the sqlhosts output:


For the environment settings we set it so many different ways, using the standard in the CMS ODBC (en_US.UTF8) document and as it's configured and working for R20 CMS.

 

[murpr]

Following this guide worked for me on CMS 19

 

[Stinney]

Those are good videos, but unfortunately I've done all the things they talk about with no luck.

 

[phoneguy55]

On your connection, Use Server Name cms_net and port 50000

From my notes.

1. Obtain the hostname of the CMS server by running the following command:
hostname

This will respond with the hostname of the system, for example:
cardinal


2. Save a copy of the /opt/informix/etc/onconfig.cms and the /opt/informix/etc/sqlhosts files.
This will allow you to revert to the original files if necessary. For example, you can use the following commands to make copies of these files:

cd /opt/informix/etc
cp onconfig.cms onconfig.cms.bak
cp sqlhosts sqlhosts.bak

3. On the CMS server, add the following two lines to the /opt/informix/etc/sqlhosts file. Note that in both cases, you must substitute the actual hostname of the CMS server. If these lines already exist, do not add them again.

a. For Solaris systems, add the following lines:
cms_net ontlitcp <hostname> 50000
cms_<hostname> ontlitcp <hostname> 50001

b. For Linux systems, add the following lines:
cms_net onsoctcp <hostname> 50000
cms_<hostname> onsoctcp <hostname> 50001
The 50000 and the 50001 values are for the network port and if you prefer, you can administer them in the /etc/services file and then add the name here instead.

4. Modify the /opt/informix/etc/onconfig.cms file and add the cms_net and cms_<hostname> entries to the DBSERVERALIASES line separated with commas. Remember to substitute the output found in step 1 from your system for the example <hostname> used here.
DBSERVERALIASES oacms_ol,cms_net,cms_<hostname># List of alternate dbservernames

5. After you have modified the files, make backup copies of the files using the current date. For example, use the following commands to make backup copies for the date January 25,2009:

cd /opt/informix/etc
cp onconfig.cms onconfig.cms.01252009
cp sqlhosts sqlhosts.01252009

6. Stop and start CMS and IDS. I do this by rebooting the server.

cat sqlhosts
cat onconfig.cms | grep DBSERVER