Ask a question?
  • Contact Us
  • Support Case System
  • Support Forum

I do not know the correct values for my Single-Tier DSN. What do I do?

OpenLink's Single-Tier drivers pass a name and a set of database-specific connection parameters. You may name your Data Source Name anything you want, so long as it observes length and special character considerations. However, you should consult your Database Administrator, if you need assistance with the database-specific connection parameters.

The database-specific parameters are parameters that the various database native clients use to connect to the database. OpenLink Product Support Staff is familiar with many database native clients. However, these products change frequently. Moreover, your Database Administrator and Database Vendor will have more intimate knowledge of these products as they instantiate in your environment. However, you may use the following instructions to identify these parameters:

Database Parameter Windows Location Unix Location
DB2 Node or Remote Database Alias Client Configuration Assistant ~/sqllib/db2nodes.cfg
Informix Server Name Setnet32 Server Information Tab $INFORMIXDIR/.profile, $INFORMIXDIR/etc/sqlhosts
Informix Physical Server Name or IP Address Setnet32 Server Information Tab Run hostname on the server or vi /etc/hosts
Informix Database Name
Informix Server Protocol Setnet32 Server Information Tab $INFORMIXDIR/etc/sqlhosts
Informix Client Locale Setnet32 Environment Tab
Ingres vnode VDBA Utility Netutil
Ingres database VDBA Utility Netutil
MS SQLServer ServerType
MS SQLServer SQLServer Instance Name Service Manager NA
MS SQLServer SQLServer Listening Port SQLServer Network Utility NA
MySQL Physical Server Name or IP Address Run hostname on the server or vi /etc/hosts
MySQL Listening Port vi the mysql_config file that appears in the /bin sub-directory of the MySQL installation. The default is 3306.
MySQL Database
Oracle SQL*NET Alias, Net8/9/10 Alias Oracle Net Configuration Assistant $ORACLE_HOME/network/admin/tnsnames.ora
PostgreSQL Physical Server Name or IP Address Run hostname on the server or vi /etc/hosts
PostgreSQL Listening Port vi the postgresql.conf file that appears in the /database sub-directory of the PostgreSQL installation. The default is 5432.
PostgreSQL Database
Progress Socket Service (-S) Open Procontrol. Highlight your database and click View. Look for -S in the Startup Parameters field. vi your Progress startup.pf file or /etc/services.
Progress Network Protocol (-N) Open Procontrol. Highlight your database and click View. Look for -N in the Startup Parameters field. vi your Progress startup.pf file. -N TCP is the default.
Progress Physical Server Name or IP Address (-H) Open Procontrol. Highlight your database and click View. Look for -H in the Startup Parameters field. vi your Progress startup.pf file or run hostname on the command-line.
Progress Database Open Procontrol. Highlight your database and click View. Look for the database in the Physical DB-Name field.
Sybase ServerType
Sybase Sybase Instance Name Sybase OpenClient/Open vi the $SYBASE/interfaces file.
Sybase Sybase Listening Port vi the $SYBASE/interfaces file.