python - pyodbc - ODBC Connection not working -

python - pyodbc - ODBC Connection not working -

i new python , trying utilize library pyodbc connect ms access database. have 32 bit database, , 32 bit drivers. maintain reading unable understand looks simple set of commands.

import pyodbc dbfile = 'c:/users/davisr/my documents/temp/comp_model_db_testing.mdb' conn = pyodbc.connect("driver={microsoft access driver(*.mdb, *.accdb)};dbq=dbfile")

the error received follows: c:\python27\python.exe c:/users/davisr/pycharmprojects/file_names/ex1.py traceback (most recent phone call last): file "c:/users/davisr/pycharmprojects/file_names/ex1.py", line 6, in conn = pyodbc.connect("driver={microsoft access driver(*.mdb, *.accdb)};dbq=+dbfile") pyodbc.error: ('im002', '[im002] [microsoft][odbc driver manager] info source name not found list item , no default driver specified (0) (sqldriverconnect)')

your help appreciated. sure simple.

respectfully,

robert davis

i took advice of beargle , serge ballesta , next worked:

access_database_file = 'c:\\users\\davisr\\my documents\\temp\\comp_model_db_testing.mdb' odbc_conn_str = 'driver={microsoft access driver (*.mdb, *.accdb)};dbq=%s;' %access_database_file– user23208211 min ago

thank serge , beargle

python pyodbc