| Database connections / Connection parameters | |
In database connection parameters, the source parameter identifies the data source name.
If the source parameter is defined with an empty value (""), the database interface connects to the default database server, which is usually the local server.
If the source entry is not present in FGLPROFILE, direct database specification method takes place.
| Database Type | Value of "source" entry | Description |
|---|---|---|
| Generic ODBC | datasource | ODBC Data Source |
| IBM® Informix® | dbname[@dbserver] | IBM Informix database specification |
| IBM DB2® | dsname | DB2 Catalogued Database |
| Oracle MySQL / MariaDB | dbname[@host[:port]] or dbname[@localhost~socket] |
Database Name @ Host
Name: TCP Port or Database Name @ Local host ~ UNIX™ socket file |
| Oracle Database | tnsname | Oracle TNS Service name |
| PostgreSQL | dbname[@host[:port]][?options] | Database Name @ Host Name : TCP Port ? PostgreSQL URI-style query string options |
| SQL Server | datasource | ODBC Data Source |
| SQLite | filename or :memory: |
Database file path, or simple file name to be found with DBPATH, or :memory: to create a database in memory. |
| Sybase Adaptive Server Enterprise (ASE) | dbname[@engine] | Database Name @ Engine Name |