- skip to content

# Database Abstraction Layer

### User Tools

- Login

### Site Tools

- Recent changes
- Media Manager
- Sitemap

### Sidebar

##### Resources

- Reference Manual
- User Guide
- The Data Dictionary
- ADOdb-xmlschema
- ADOdb Active Record
- Performance Monitoring
- Date/Time Library
- Session Management Library
- Unsupported Addons
- Coding Standards

##### Supported Databases

- Access
- ADO
- CSV
- Firebird
- Frontbase
- IBM DB2
- Informix
- Interbase
- LDAP
- Microsoft SQL Server
- MySQL
- Netezza
- ODBC
- ODBTP
- Oracle
- PDO
- Postgresql
- SAP ADS
- SAP ASE
- SAP Maxdb
- SAP Sqlanywhere
- Sqlite
- Sybase
- Plain Text
- Visual Foxpro

##### Other

- Feature Comparison Matrix
- Connection Matrix
- Include File Guide

v5:database:connection_matrix

# 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 |
access | ODBC DSN1) | NULL | NULL | NULL | Yes
ADO |  |  |  |  |
Firebird/Interbase | protocol:/path/to/database | User ID | Password | NULL |
Frontbase |  |  |  |  |
IBM DB2 | Service Name2) | User Id | Password | Instance3) | Yes
Informix |  |  |  |  |
Microsoft SQL Server | Service Name4) | User Id | Password | Database Name | Yes
MySQL | Host Name5) | User Id | Password | Database Name |
ODBC | ODBC DSN6) | NULL | NULL | NULL | Yes
ODBTP | See Driver For Examples |  |  |  |
Oracle | Host Name | User Id | Password | Instance | Yes
Postgresql | Host Name7) | User Id | Password | Database Name |
SAP_ASE | Host Name | User Id | Password | Database Name |
SAP MaxDB | ODBC DSN8) | NULL | NULL | NULL |
SAP SQLanywhere | ODBC DSN9) | NULL | NULL | NULL |
Sqlite | /path/to/database | NULL | NULL | NULL | Yes
Sqlite In Memory Database | ':memory:' | NULL | NULL | NULL | Yes
Visual Foxpro |  |  |  |  |

1) , 6) , 8) , 9) pre-defined in ODBC Manager
2) , 4) Or DSN connection string
3) Leave empty when using DSN
5) optional port via :xxxx, or DSN connection string
7) Leave as NULL to connect via a socket, or connection string - see driver
v5/database/connection_matrix.txt · Last modified: 2016/01/13 08:19 by mnewnham

### Page Tools

- Show pagesource
- Old revisions
- Backlinks
- Rename Page
- Back to top