v5:database:access
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
database:access [2015/07/24 20:42] – mnewnham | v5:database:access [2020/01/13 13:06] (current) – Add tier2 tag dregad | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | <WRAP right info> | + | ====== Microsoft Access ====== |
- | [[database: | + | ~~NOTOC~~ |
- | == Alternative Driver | + | |
- | [[database:ADO]]\\ | + | |
- | [[database: | + | <WRAP right box round 300px> |
+ | == Specification == | ||
+ | ^Driver Name|access| | ||
+ | ^Data Provider|odbc| | ||
+ | ^Status|Active((This driver is actively supported by ADOdb project members)) | | ||
+ | ^Windows|Yes| | ||
+ | ^Unix|No| | ||
+ | ^ADOdb V5|Yes| | ||
+ | ^ADOdb V6|Yes| | ||
+ | == Alternatives | ||
+ | [[v5:database:pdo# | ||
</ | </ | ||
- | ====== Microsoft Access ===== | + | |
- | This driver provides a connection to Microsoft Access databases, via an ODBC connection. | + | This driver provides a connection to Microsoft Access databases, via an ODBC connection. |
- | ===== Specification ====== | + | |
- | |Driver Name|access| | + | |
- | |Status|Active| | + | |
- | |Supported OS|Windows| | + | |
===== Driver Specific Options ===== | ===== Driver Specific Options ===== | ||
None | None | ||
+ | ===== Driver Specific Issues ===== | ||
+ | In ADOdb V5, the field type returned in [[v5: | ||
+ | ----------------------- | ||
+ | <code php> | ||
+ | $db = newAdoConnection(' | ||
+ | $db-> | ||
+ | </ | ||
+ | Depending on the database security, some meta functions may not be available. For more information, | ||
+ | --------------------------- | ||
===== Connection Parameters Guidelines ===== | ===== Connection Parameters Guidelines ===== | ||
+ | ==== Using a DSN Style Connection ==== | ||
^Field^Description^Common Example^ | ^Field^Description^Common Example^ | ||
- | |$host||| | + | |$host|Use for the ODBC DSN Name|northwind| |
- | |$userName||| | + | |$userName|Not Required|| |
- | |$password||| | + | |$password|Not Required|| |
- | |$database||| | + | |$database|Not Required|| |
- | ===== Connection Example ===== | + | |
+ | === Example === | ||
+ | <code php> | ||
+ | $db= newAdoConnection(' | ||
+ | $db-> | ||
- | + | $sql = ' | |
- | ==== DSN-less ODBC ==== | + | $result= $db-> |
- | + | </ | |
- | ODBC DSNs can be created in the ODBC control panel, or you can use a DSN-less connection. | + | ===== Using a DSN less connection |
<code php> | <code php> | ||
Line 39: | Line 57: | ||
</ | </ | ||
- | {{tag> | + | {{tag> |
v5/database/access.txt · Last modified: 2020/01/13 13:06 by dregad