ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== 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                                          |                               |
| [[v5:database:access]]                            | ODBC DSN((pre-defined in ODBC Manager))                                                | NULL                                                 | NULL                                                  | NULL                                                   |  Yes                          |
| [[v5:database:firebird|Firebird/Interbase]]       | protocol:/path/to/database                                                             | User ID                                              | Password                                              | NULL                                                   |  Yes                          |
| [[v5:database:IBM DB2]]                           | Service Name((Or DSN connection string))                                               | User Id                                              | Password                                              | Instance((Leave empty when using DSN))                 |  Yes                          |
| [[v5:database:Microsoft SQL Server]]              | Service Name((Or DSN connection string))                                               | User Id                                              | Password                                              | Database Name                                          |  Yes                          |
| [[v5:database:MySQL]]                             | Host Name((optional port via ** :xxxx**, or DSN connection string))                    | User Id                                              | Password                                              | Database Name                                          |  Yes                          |
| [[v5:database:ODBC]]                              | ODBC DSN((pre-defined in ODBC Manager))                                                | NULL                                                 | NULL                                                  | NULL                                                   |  Yes                          |
| [[v5:database:Oracle]]                            | Host Name                                                                              | User Id                                              | Password                                              | Instance                                               |  Yes                          |
| [[v5:database:pdo|PDO (PHP Data Objects)]]        | Database Type + ':' + DSN String                                                       | User Id ((Or may be NULL if set in the DSN string))  | Password ((Or may be NULL if set in the DSN string))  | Database Name ((Or may be NULL if set in DSN string))  |  Yes ((mysql & Sqlite only))  |
| [[v5:database:Postgresql]]                        | Host Name((Leave as NULL to connect via a socket, or connection string - see driver))  | User Id                                              | Password                                              | Database Name                                          |                               |
| [[v5:database:Sqlite|SQLite]]                     | /path/to/database                                                                      | NULL                                                 | NULL                                                  | NULL                                                   |  Yes                          |
| [[v5:database:sqlite|SQLite In Memory Database]]  |  ':memory:'                                                                            | NULL                                                 | NULL                                                  | NULL                                                   |  Yes                          |