Hi everyone,
Been a while since I have been on here but im just getting started with a new project. I need to use an Access Database which I haven't done before, i know its not a great idea but the company requires it. Im normally a MySQL person. I'm currently having problems getting a connection to the Access Database which is called cms.
If anyone can see a problem with the code please say;
im getting a 'cannot open with driver' error but thats all so I belive the ADO bit of the code is working.
<?php
$db = 'C:\\Web\\PC\\root\\LME\\cms.mdb';
$conn = new COM ("ADODB.Connection") or exit("Cannot start ADO");
$conn->open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db") or exit ('Cannot open with driver.');
//$connStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source=$db" or exit 'Cannot open with driver.';
//$conn->open($connStr);
$conn->close();
?>
Cheers
Dan
