Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Anaconda Python 3.5 Install PyODBC

I meed to install PyODBC to connect Anaconda with Python 3.5 to database. Support for PyODBC only goes up to Python 3.3. I tried download the PyODBC adapter for Python 3.5 from here http://www.lfd.uci.edu/~gohlke/pythonlibs/#pyodbc ,but I cant seem to get it installed. Thanks!

like image 818
Jorge Avatar asked Jan 26 '16 18:01

Jorge


People also ask

Does Anaconda have Pyodbc?

anaconda / packages / pyodbc 34. 2 pyodbc is a Python DB API 2 module for ODBC. This project provides an up-to-date, convenient interface to ODBC using native data types like datetime and decimal.

Does Pyodbc work with Python 3?

x versions will be the last to support Python 2.7. The pyodbc 5. x versions will only support Python 3.7 and above.

How do I know if Pyodbc is installed?

You can use the subprocess module to execute pip list to get a list of the installed modules and check if it contains the pyodbc module.


2 Answers

This worked for me:

conda install -c anaconda pyodbc=3.0.10

Also, check here to make sure you'll install the latest version

https://anaconda.org/anaconda/pyodbc

like image 63
BGA Avatar answered Sep 27 '22 16:09

BGA


I have pyodbc running with Python 3.5. Have you tried:

pip install pyodbc==3.0.10

Here's the latest / greatest version, it is no longer on Google Code: https://github.com/mkleehammer/pyodbc

like image 43
FlipperPA Avatar answered Sep 27 '22 18:09

FlipperPA