1<?php 2 3// BASIC ADO test 4 5 include_once('../adodb.inc.php'); 6 7 $db = ADONewConnection("ado_access"); 8 $db->debug=1; 9 $access = 'd:\inetpub\wwwroot\php\NWIND.MDB'; 10 $myDSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;' 11 . 'DATA SOURCE=' . $access . ';'; 12 13 echo "<p>PHP ",PHP_VERSION,"</p>"; 14 15 $db->Connect($myDSN) || die('fail'); 16 17 print_r($db->ServerInfo()); 18 19 try { 20 $rs = $db->Execute("select $db->sysTimeStamp,* from adoxyz where id>02xx"); 21 print_r($rs->fields); 22 } catch(exception $e) { 23 print_r($e); 24 echo "<p> Date m/d/Y =",$db->UserDate($rs->fields[4],'m/d/Y'); 25 } 26?>