weecology / retriever

Quickly download, clean up, and install public datasets into a database management system
http://data-retriever.org
Other
306 stars 134 forks source link

install to msaccess error #798

Closed emchristensen closed 4 years ago

emchristensen commented 7 years ago

When I try to install a dataset to msaccess I get the error: Couldn't create table (no module named 'pypyodbc')

I've tried doing "pip install pypyodbc --upgrade" which seems to work, but doesn't help with the retriever error.

I'm on a windows 10 machine

ethanwhite commented 7 years ago

Is this install done using the Windows installer (the .exe)? If so then I think we packaged the wrong ODBC package with it.

emchristensen commented 7 years ago

Yes I used the .exe

ethanwhite commented 7 years ago

Thanks. @henrykironde will rebuild that package and have you test again.

emchristensen commented 7 years ago

after installing with the new .exe, I now get the error "Access Driver is not found"

ethanwhite commented 7 years ago

@emchristensen - I can't remember, did we ever get this figured out?

emchristensen commented 7 years ago

I can't remember either. Can you remind me how to test this, and I'll try it again?

emchristensen commented 7 years ago

I just tried it again and got the same error message -- Henry is going to check it out

emchristensen commented 7 years ago

this is still not working -- on Windows 10 Pro

ethanwhite commented 5 years ago

Given the difficulty of testing I wonder if we should deprecate support for Access.