I'm a beginner in Python.
I have a linux Redhat 4.4 server.It has python2.6 by default. I installed pyodbc 2.1.7 and python 3 tried "import pyodbc" in python3. I got the error below.
1)Is there something like pyodbc 2.1.7 is not compatiable with python3 ? I checked the documentation for pyodbc, but did not find anything conclusive. rpm was used to install pyodbc.
2) Is pypyodbc a good workaround in this case for working with python3(like anyone has any bad experience)? I tried using pypyodbc and basic select and all works with python3 with some workaround.
Python 2.6.6 [GCC 4.4.7 20120313 (Red Hat 4.4.7-4)] on linux2
$ import sys
$ import pyodbc
$ exit()
Python 3.3.5 (default, Mar 13 2014, 20:11:10) [GCC 4.1.2 20080704 (Red Hat 4.1.2-54)] on linux
$ import sys
$ import pyodbc
Traceback (most recent call last): File "", line 1, in ImportError: dynamic module does not define init function (PyInit_pyodbc)
I did a try with the following and it did the trick
virtualenv vtest -- for testing purpose. Do not use it in your case
source vtest/bin/activate -- for testing purpose. Do not use it in your case
pip3 install pyodbc
Then execute your python3
import pyodbc
Make sure you are using pip3
unixodbc-dev from npm and pyodbc from pip separately.