ODBC users log into the CMS server with password protection. Users have SQL access to Informix tables, as limited by the table permissions.
All historical and dictionary database tables have read-only access permission. The customer-created tables (any table name that begins with “c_”) on the host have read and write permissions. No other tables are accessible through ODBC.The ports will be defined on the CMS server in the /opt/Informix/etc/sqlhosts file.
If you want to limit the CMS logins which have ODBC access, that procedure is described in detail in Providing secure access to the CMS database.
Important:
If your network uses a firewall, it is common for unused ports to be locked. ODBC uses network ports 50000 and 50001. If these ports are locked, you will not be able to connect to the CMS database with ODBC.
