<%
$DBASE = "DRIVE:\PATH\DATABASE.mdb" ;
$CONN = new COM('ADODB.Connection') ;
$CONN->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".$DBASE) ;
$SQLQ = "SELECT ... FROM ..." ;
$RST = $CONN->Execute($SQLQ) ;
while (!$RST->EOF) {
...
...
...
}
$RST->Close() ;
$RST = null ;
$CONN->Close() ;
$CONN = null ;
%>
<%
$ODBC = "ODBC DATABASE NAME" ;
$CONN = odbc_connect($ODBC, "", "") ;
$SQLQ = "SELECT ... FROM ..." ;
$RST = odbc_exec($CONN,$SQLQ) ;
while (odbc_fetch_row($RST)) {
...
...
...
}
$RST = NULL ;
odbc_close($CONN) ;
$CONN = null;
%>