Unable to connect to access 2007 from perl

[prathaphs]

Hi
I am using Perl 5.8.8 and i use DBI->connect("dbi:O DBC:driver=Micr osoft Access Driver (*.mdb );dbq=$file" to connect to access. This used to work with access 2000. but now in access 2007 the file extension has been changed to .accdb so i changed the code to
DBI->connect("dbi:O DBC:driver=Micr osoft Access Driver (*.mdb, *.accdb);dbq=$f ile" but it is giving error

[Microsoft][ODBC Microsoft Access Driver] Not a valid file name. (SQL-HY000)(DBD: db_login/SQLConnect err=-1)

Can somebody help me to resolve this error.

Thanks

[numberwhun]

Hi
I am using Perl 5.8.8 and i use DBI->connect("dbi:O DBC:driver=Micr osoft Access Driver (*.mdb );dbq=$file" to connect to access. This used to work with access 2000. but now in access 2007 the file extension has been changed to .accdb so i changed the code to
DBI->connect("dbi:O DBC:driver=Micr osoft Access Driver (*.mdb, *.accdb);dbq=$f ile" but it is giving error

[Microsoft][ODBC Microsoft Access Driver] Not a valid file name. (SQL-HY000)(DBD: db_login/SQLConnect err=-1)

Can somebody help me to resolve this error.

Thanks

Sorry, I don't know the answer but hopefully one of our experts will be able to assist you.

My appologies for the delay in getting an answer to your question.

Regards,

Jeff