By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,848 Members | 1,359 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,848 IT Pros & Developers. It's quick & easy.

Unable to connect to access 2007 from perl

P: 1
Hi
I am using Perl 5.8.8 and i use DBI->connect("dbi:ODBC:driver=Microsoft 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:ODBC:driver=Microsoft Access Driver (*.mdb, *.accdb);dbq=$file" 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
Mar 18 '08 #1
Share this Question
Share on Google+
1 Reply


numberwhun
Expert Mod 2.5K+
P: 3,503
Hi
I am using Perl 5.8.8 and i use DBI->connect("dbi:ODBC:driver=Microsoft 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:ODBC:driver=Microsoft Access Driver (*.mdb, *.accdb);dbq=$file" 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
Apr 17 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.