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?>