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/10/15 04:15] – mnewnham | v5:database:access [2019/12/29 21:27] – mnewnham | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Microsoft Access ====== | ||
+ | ~~NOTOC~~ | ||
+ | |||
+ | |||
+ | <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: | ||
+ | </ | ||
+ | |||
+ | This driver provides a connection to Microsoft Access databases, via an ODBC connection. The easiest way to connect to the database is to define a DSN in the ODBC connection manager and connect via that. | ||
+ | |||
+ | ===== Driver Specific Options ===== | ||
+ | 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 ===== | ||
+ | ==== Using a DSN Style Connection ==== | ||
+ | ^Field^Description^Common Example^ | ||
+ | |$host|Use for the ODBC DSN Name|northwind| | ||
+ | |$userName|Not Required|| | ||
+ | |$password|Not Required|| | ||
+ | |$database|Not Required|| | ||
+ | |||
+ | === Example === | ||
+ | <code php> | ||
+ | $db= newAdoConnection(' | ||
+ | $db-> | ||
+ | |||
+ | $sql = ' | ||
+ | $result= $db-> | ||
+ | </ | ||
+ | ===== Using a DSN less connection ===== | ||
+ | |||
+ | <code php> | ||
+ | |||
+ | $db = ADONewConnection(' | ||
+ | |||
+ | $dsn = " | ||
+ | $db-> | ||
+ | |||
+ | </ | ||
+ | |||
+ | {{tag> | ||
v5/database/access.txt · Last modified: 2020/01/13 13:06 by dregad