Can't connect to an Access database

[vermilck]

Hi,

I'm a new PHP user, but am proficient in ASP.

I tried to connect to an access database using the following code and received an error:

<?
$conn = new COM('ADODB.Connection');
$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\data\sites\85917\CKV\www\Db.mdb");
?>

Error Received: Fatal error: Cannot instantiate non-existent class: com in /data/sites/85917/CKV/www/Gallery.php on line 7

Line seven is the first line in my code

Can someone tell me why I'm receiving this error and how I can connect to my database?

[tsinka]

Hi,

the problem is that php treats new COM as a php class which most likely doesn't exist. I don't know if it is possible to connect to an access database with php using COM, there might be a way. The most common way is to use odbc to connect to an access database with php.

[vermilck]

Thank you. Can somebody show me how to write an ODBC connection to an Access database on a PHP page?

[Bunkermaster]

[MAN]odbc_connect[/MAN]

rtfm?