v5:database:access
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
database:access [2015/07/24 20:37] – mnewnham | v5:database:access [2019/12/29 21:27] – mnewnham | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | <WRAP right info> | + | ====== Microsoft Access |
- | [[feature_comparison|Feature Comparison Matrix]] | + | ~~NOTOC~~ |
- | </ | + | |
- | ====== Microsoft Access ===== | + | |
- | <WRAP round info> | + | < |
- | See also the [[ADO]] and [[PDO]] | + | == 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: | ||
</ | </ | ||
- | ===== Description ===== | + | 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 41: | Line 57: | ||
</ | </ | ||
- | {{tag> | + | {{tag> |
v5/database/access.txt · Last modified: 2020/01/13 13:06 by dregad