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 |
---|---|---|
Genero db | datasource | ODBC Data Source |
Generic ODBC | datasource | ODBC Data Source |
IBM® Informix® | dbname[@dbserver] | IBM Informix database specification |
IBM DB2® | dsname | DB2 Catalogued Database |
MySQL | dbname[@host[:port]] or dbname[@localhost~socket] |
Database Name @ Host
Name: TCP Port or Database Name @ Local host ~ UNIX™ socket file |
ORACLE | tnsname | Oracle TNS Service name |
PostgreSQL | dbname[@host[:port]] | Database Name @ Host Name: TCP Port |
SQL Server | datasource | ODBC Data Source |
SQLite | filename | Database file path |
Sybase Adaptive Server Enterprise (ASE) | dbname[@engine] | Database Name @ Engine Name |