python - PYODBC connection with MS Access error -

python - PYODBC connection with MS Access error -

my softwares:

python 3.4 -64 bit pyodbc 64 bit ms office bundle installed (32 bit)

problem:

now, seek access ms access 2010 installed in computer using pyodbc. not work regardless of try. error this:

pyodbc.error: ('im002', '[im002] [microsoft][odbc driver manager] info source name not found , no default driver specified (0) (sqldriverconnect)')

i looked at:

pyodbc , ms access 2010 connection error

cannot connect access db using pyodbc

it suggested 32-64 bit problem sure is. there modification can done create work without installing 32 bit python , 32 bit pyodbc? checked website.using odbc (32-bit , 64-bit) on 64-bit windows explains accessing command panel modify odbc connnection and/or drivers. however, don't know much windows database connection internals commence changes.

is there can create work?

is there modification can done create work without installing 32 bit python , 32 bit pyodbc?

not really. if have 32-bit office installed have 32-bit version of access database engine (a.k.a. "ace"), , 32-bit applications can utilize it.

the installer 64-bit version of access database engine abort if detects 32-bit office components. there way forcefulness installer continue, not recommended because can apparently break office.

so, practically speaking, options are:

use 32-bit python , pyodbc, or replace 32-bit office 64-bit version.

python ms-access odbc pyodbc