| Database connections / Connection parameters | |
In database connection parameters, the driver parameter identifies the type of database driver to be loaded. Specify the name of the shared library or DLL, without the .so or .DLL extension.
For example, in FGLPROFILE:
dbi.database.stores.driver = "dbmifx9x"
The selected driver must correspond to the database client and server, in terms of type and version. Using the appropriate version is very important. For example, you should not use an Oracle 9.2 driver (dbmora92x) with an Oracle 10g server: Drivers may implement IBM® Informix® features in a different way according to the target server version. For example, starting with Oracle 10.1, the Oracle drivers use the native binary floating point data types for FLOAT and SMALLFLOAT, while drivers for older versions of Oracle use the NUMBER type.
A default driver can be specified with the dbi.default.driver FGLPROFILE entry:
dbi.default.driver = "dbmifx9x"
If this entry is not defined, and if no driver parameter is specified for the data source, the driver name defaults to dbmdefault. The default driver with the name dbmdefault is a copy of the database driver that was chosen during installation.
The shared libraries implementing database drivers are located in the FGLDIR/dbdrivers directory, on both UNIX™ and Windows™ platforms. Some drivers may not be available on a specific platform if the target database client software does not exist on that platform.
Contact your support if you do not find the database driver you are looking for.
| Driver names | Type | Database client software version | UNIX shared libraries | Microsoft™ Windows DLLs |
|---|---|---|---|---|
| dbmads3x | ads | Genero db Client 3.x | libaodbc.so | aodbc.dll |
| dbmads380 | ads | Genero db Client 3.80 and higher | libaodbc.so | aodbc.dll |
| dbmads381 | ads | Genero db Client 3.81 and higher | libaodbc.so | aodbc.dll |
| dbmase0Fx | ase | Sybase ASE Open Client Library 15.x | libsybct.so, libsybcs.so | libsybct.dll, libsybcs.dll |
| dbmdb28x | db2 | IBM DB2® UDB Client 8.x | libdb2.so.1 | db2cli.dll |
| dbmdb29x | db2 | IBM DB2 UDB Client 9.x | libdb2.so.1 | db2cli.dll |
| dbmdb2Ax | db2 | IBM DB2 UDB Client 10.x | libdb2.so.1 | db2cli.dll |
| dbmesm90 | esm | EasySoft ODBC for SQL Server 2005 (V9) | libessqlsrv.so | N/A |
| dbmesmA0 | esm | EasySoft ODBC for SQL Server 2008 (V10) | libessqlsrv.so | N/A |
| dbmesmB0 | esm | EasySoft ODBC for SQL Server 2012 (V11) | libessqlsrv.so | N/A |
| dbmifx9x | ifx | IBM Informix CSDK 2.80 and higher | libifsql.so, libifasf.so, libifgen.so, libifos.so, libifgls.so, libifglx.so | isqlt09a.dll |
| dbmmys50x | mys | MySQL Client 5.0.x | libmysqlclient.so.15 | libmysql.dll |
| dbmmys51x | mys | MySQL Client 5.1.x | libmysqlclient.so.16 | libmysql.dll |
| dbmmys55x | mys | MySQL Client 5.5.x | libmysqlclient.so.18 | libmysql.dll |
| dbmntz6x | ntz | IBM Netezza® (1.x) | libnzodbc.so | odbc32.dll |
| dbmodc3x | odc | Generic ODBC (ODBC 3.x) | libodbc.so | odbc32.dll |
| dbmora92x | ora | Oracle OCI Client 9.2.x | libclntsh.so.9.0 | oci.dll |
| dbmoraA1x | ora | Oracle OCI Client 10.1.x | libclntsh.so.10.1 | oci.dll |
| dbmoraA2x | ora | Oracle OCI Client 10.2.x | libclntsh.so.10.1 | oci.dll |
| dbmoraB1x | ora | Oracle OCI Client 11.1.x | libclntsh.so.11.1 | oci.dll |
| dbmoraB2x | ora | Oracle OCI Client 11.2.x | libclntsh.so.11.1 | oci.dll |
| dbmpgs83x | pgs | PostgreSQL Client 8.3.x | libpq.so.5 | libpq.dll |
| dbmpgs84x | pgs | PostgreSQL Client 8.4.x | libpq.so.5 | libpq.dll |
| dbmpgs90x | pgs | PostgreSQL Client 9.0.x | libpq.so.5 | libpq.dll |
| dbmpgs91x | pgs | PostgreSQL Client 9.1.x | libpq.so.5 | libpq.dll |
| dbmpgs92x | pgs | PostgreSQL Client 9.2.x | libpq.so.5 | libpq.dll |
| dbmsnc90 | snc | SQL Server / SQL Native Client 2005 (V9) | N/A | odbc32.dll / SQLNCLI.DLL |
| dbmsncA0 | snc | SQL Server / SQL Native client 2008 (V10) | N/A | odbc32.dll / SQLNCLI10.DLL |
| dbmsncB0 | snc | SQL Server / SQL Native Client 2012 (V11) | N/A | odbc32.dll / SQLNCLI11.DLL |
| dbmftm90 | ftm | FreeTDS ODBC for SQL Server 2005 (V9) | libtdsodbc.so.0 | N/A |
| dbmsqt3xx | sqt | SQLite 3.x | libsqlite3.so.0 | N/A (statically linked) |