Access w/ PHP .ldb

  • Thread starter Thread starter David
  • Start date Start date
D

David

I (have to) use PHP to connect to an Access DB. In order
to connect, I am using the Jet drivers:

$db = 'D:\\hosting\\Site\\db\\Access_db.mdb';
$conn = new COM("ADODB.Connection")
or die("Cannot start ADO");
$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=$db");
$rs = $conn->Execute("SELECT * FROM Site");

$rs->Fields['Security']->Value;

$rs->Close();
$conn->Close();
 
Back
Top