MS Access DB in php 64bit SQL state IM002 error

Question

I'm trying to fetch data from access db in php. Code works fine for 32 bit php( I've tested in php version>5), but code generates error for 64bit php wamp.

Error Message: Warning: odbc_connect(): SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in

What I've tried : How can I correct this error: Data source name not found and no default driver specified

Code :

$connection = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$db", "","");
$tabs = odbc_tables($connection);

Is there any solution or I've to install 32 bit version?

Install the 64bit Driver; microsoft.com/en-us/download/details.aspx?id=13255 — Alex K.
– Alex K., Commented Feb 24, 2014 at 13:08

Gord Thompson · Accepted Answer · 2014-02-24 13:08:49Z

1

Microsoft Access Driver (*.mdb)

refers to the older Access "Jet" driver which is installed as part of Windows itself but is only available to 32-bit applications. (There is no 64-bit version of Jet.)

You could download and install the 64-bit version of the newer Access Database Engine (a.k.a. "ACE", available here) and then use

Microsoft Access Driver (*.mdb, *.accdb)

as the driver name. (Assuming that the WAMP server does not already have a copy of Access 2007 or later installed on it.)

answered Feb 24, 2014 at 13:08

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Raza Ahmed Over a year ago

I had to uninstall office2010 32bit version for installing this driver but now it is working fine..

Collectives™ on Stack Overflow

MS Access DB in php 64bit SQL state IM002 error

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related