This is an old revision of the document!

The Connection Matrix

Common connection parameters, by database type

	Parameter 1	Parameter 2	Parameter 3	Parameter 4	Verified
Legacy Name	Host Name	User ID	Password	Database Name
Microsoft Access	ODBC DSN¹⁾	NULL	NULL	NULL	Yes
ADO
Firebird/Interbase	protocol:/path/to/database	User ID	Password	NULL	Yes
Frontbase
IBM DB2	Service Name²⁾	User Id	Password	Instance³⁾	Yes
IBM Informix
Microsoft SQL Server	Service Name⁴⁾	User Id	Password	Database Name	Yes
MySQL	Host Name⁵⁾	User Id	Password	Database Name	Yes
ODBC	ODBC DSN⁶⁾	NULL	NULL	NULL	Yes
ODBTP	See Driver For Examples
Oracle	Host Name	User Id	Password	Instance	Yes
PDO (PHP Data Objects)	Database Type + ':' DSN connection parameter	User Id ⁷⁾	Password ⁸⁾	Database Name ⁹⁾	Yes ¹⁰⁾
PostgreSQL	Host Name¹¹⁾	User Id	Password	Database Name
SAP Adaptive Server Enterprise	Host Name	User Id	Password	Database Name
SAP MaxDB	ODBC DSN¹²⁾	NULL	NULL	NULL
SAP SQLanywhere	ODBC DSN¹³⁾	NULL	NULL	NULL
SQLite	/path/to/database	NULL	NULL	NULL	Yes
SQLite In Memory Database	':memory:'	NULL	NULL	NULL	Yes
Visual Foxpro

¹⁾ , ⁶⁾ , ¹²⁾ , ¹³⁾

pre-defined in ODBC Manager

²⁾ , ⁴⁾

Or DSN connection string

³⁾

Leave empty when using DSN

⁵⁾

optional port via :xxxx, or DSN connection string

⁷⁾ , ⁸⁾

Or may be NULL if set in the DSN string

⁹⁾

Or may be NULL if set in DSN string

¹⁰⁾

mysql & Sqlite only

¹¹⁾

Leave as NULL to connect via a socket, or connection string - see driver