Database Interfaces

A database interface is a translator with a permanent connection to a proprietary database.

Any commands received from a client which it does not recognise are assumed to be SQL commands and passed directly for execution by the database server to which it is connected.

A database interface should have a connect string (some combination of database location, user and password) on the program command line. The option is –c=<connect string>. Alternatively the connect string can be specified via a connect command in a startup script. Without one of these two methods a database interface will not start.

For security purposes the connect string may be encoded via the utility fxencode. A database interface will accept either an encoded or non-encoded connect string.

Currently the available set of database interfaces is as follows:

fx8i/fx9i/fx10g	Oracle Object-Relational 8.1/9.1/10g
fxodbc	Microsoft ODBC
fxinformix	Informix Spatial 9.x
fxmysql	MySQL 5.x
fxsde	ESRI ArcSDE