Driver Name | access |
---|---|
Data Provider | odbc |
Status | Active1) |
Windows | Yes |
Unix | No |
ADOdb V5 | Yes |
ADOdb V6 | Yes |
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.
None
In ADOdb V5, the field type returned in metaColumns is the metaType, not the actualType. For more on this issue, see This Thread on Github. This behaviour changed in Version 5.21, but a backward compatibility mode is provided:
$db = newAdoConnection('access'); $db->metaColumnsReturnType = METACOLUMNS_RETURNS_META;
Depending on the database security, some meta functions may not be available. For more information, try this Stack Overflow response.
Field | Description | Common Example |
---|---|---|
$host | Use for the ODBC DSN Name | northwind |
$userName | Not Required | |
$password | Not Required | |
$database | Not Required |
$db= newAdoConnection('access'); $db->connect('northwind'); $sql = 'select * from products'; $result= $db->Execute($sql);
$db = ADONewConnection('access'); $dsn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=d:\\northwind.mdb;Uid=Admin;Pwd=;"; $db->Connect($dsn);