ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:database:access

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
database:access [2015/11/26 18:45] – [Microsoft Access] mnewnhamv5:database:access [2020/01/13 13:06] (current) – Add tier2 tag dregad
Line 1: Line 1:
 ====== Microsoft Access ====== ====== Microsoft Access ======
 ~~NOTOC~~ ~~NOTOC~~
-<WRAP right info+ 
-[[database:feature_comparison|Feature Comparison Matrix]] + 
-== Alternative Driver == +<WRAP right box round 300px
-[[database:ADO]]\\ +== Specification == 
-[[database:PDO]]+^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#pdo_access|PDO Driver For Access]]
 </WRAP> </WRAP>
  
 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. 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.
- 
-===== Support Status ===== 
-This driver is supported by ADOdb project members 
-===== 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:dictionary:metacolumns]] is the metaType, not the actualType. For more on this issue, see [[https://github.com/ADOdb/ADOdb/issues/184|This Thread]] on Github. This behaviour changed in Version 5.21, but a backward compatibility mode is provided:
 +-----------------------
 +<code php>
 +$db = newAdoConnection('access');
 +$db->metaColumnsReturnType = METACOLUMNS_RETURNS_META;
 +</code>
  
 +Depending on the database security, some meta functions may not be available. For more information, try this [[http://stackoverflow.com/questions/1937703/record-cannot-be-read-no-read-permission-on-msysobjects|Stack Overflow]] response.
 +---------------------------
 ===== Connection Parameters Guidelines ===== ===== Connection Parameters Guidelines =====
 ==== Using a DSN Style Connection ==== ==== Using a DSN Style Connection ====
Line 47: Line 57:
 </code> </code>
  
-{{tag>[access supported]}}+{{tag>[access supported tier2]}}
  
v5/database/access.1448559903.txt.gz · Last modified: 2017/04/21 11:26 (external edit)