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.