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
Firebird/Interbase	protocol:/path/to/database	User ID	Password	NULL	Yes
IBM DB2	Service Name²⁾	User Id	Password	Instance³⁾	Yes
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
Oracle	Host Name	User Id	Password	Instance	Yes
PDO (PHP Data Objects)	Database Type + ':' + DSN String	User Id ⁷⁾	Password ⁸⁾	Database Name ⁹⁾	Yes ¹⁰⁾
PostgreSQL	Host Name¹¹⁾	User Id	Password	Database Name
SQLite	/path/to/database	NULL	NULL	NULL	Yes
SQLite In Memory Database	':memory:'	NULL	NULL	NULL	Yes

¹⁾ , ⁶⁾

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