00001 <?php
00002
00003
00004
00005 include_once('../adodb.inc.php');
00006
00007 $db = &ADONewConnection("ado_access");
00008 $db->debug=1;
00009 $access = 'd:\inetpub\wwwroot\php\NWIND.MDB';
00010 $myDSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;'
00011 . 'DATA SOURCE=' . $access . ';';
00012
00013 echo "<p>PHP ",PHP_VERSION,"</p>";
00014
00015 $db->Connect($myDSN) || die('fail');
00016
00017 print_r($db->ServerInfo());
00018
00019 try {
00020 $rs = $db->Execute("select $db->sysTimeStamp,* from adoxyz where id>02xx");
00021 print_r($rs->fields);
00022 } catch(exception $e) {
00023 print_r($e);
00024 echo "<p> Date m/d/Y =",$db->UserDate($rs->fields[4],'m/d/Y');
00025 }
00026 ?>