not able to connect to access database

[sandhya]

hi all,

 

I have a big problem with access database connectivity using php. with dsn i'm able to connect. but not with out DSN. while using the following code ..

 

$db = 'emailid.mdb';

 

$conn = new COM('ADODB.Connection') or exit('Cannot start ADO.');

 

$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db") or exit('Cannot open with Jet.');

 

 

i'm getting the following error.

 

Fatal error: Call to a member function Open() on a non-object in /home/sphoor21/public_html/san/accemail/data1.php on line 18

 

Plz help me I will be very thankful.

[sandhya]

anybody can't help me? is it a typical thing?

[gwolgamott]

Ask this in the ms sql forum, may get a response. Not exactly right place to ask perhaps but considering it's access maybe it might be, but some window/php experts tend troll that area I've found.