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 [2016/01/04 23:59] mnewnhamv5:database:access [2020/01/13 13:06] (current) – Add tier2 tag dregad
Line 13: Line 13:
 ^ADOdb V6|Yes| ^ADOdb V6|Yes|
 == Alternatives == == Alternatives ==
-[[database:ado|ADO Driver For Access]]\\ +[[v5:database:pdo#pdo_access|PDO Driver For Access]]
-[[database:pdo#pdo_access|PDO Driver For Access]]+
 </WRAP> </WRAP>
  
Line 22: Line 21:
 None None
 ===== Driver Specific Issues ===== ===== Driver Specific Issues =====
-In ADOdb V5, the field type returned in [[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.+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 =====
Line 51: Line 57:
 </code> </code>
  
-===== Issues Accessing The Data Dictionary ===== +{{tag>[access supported tier2]}}
-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. +
- +
-{{tag>[access supported]}}+
  
v5/database/access.1451948378.txt.gz · Last modified: 2017/04/21 11:26 (external edit)