pyodbc: Works in Plain Python, Django 1.8 Shell Throws Error

[Matt Woodward]

Running into a bit of an odd problem I hope someone can help with.

Envrionment:

* Ubuntu Server 14.04, 64-bit (Vagrant box)

* Python 3.4

* Django 1.8

* pyodbc 3.0.8

pyodbc installs fine. When I do python3 and then import pyodbc, that works fine.

When I do python3 manage.py shell and then import pyodbc, however, I get this:

http://pastebin.com/cNDrmvcb

Got a bit of help in IRC with someone suggested to turn on pdb trace on the run_shell command, which I did, but then I just get this:

*** SystemError: initialization of pyodbc raised unreported exception

I just can't figure out why it'd work in a plain python interpreter but not in the Django shell, and I'm not sure how to diagnose or troubleshoot further.

Appreciate any tips or suggestions anyone might have. Thanks!

[Ederson Mota Pereira]

Hi Matt,

I have been through something similar some days ago.

Reverting to the 3.0.7 pyodbc version worked for me.

If you are using pip, maybe you will need to use --allow-external and --allow-unverified flags. Be warned of the security issues of doing something like this.

Att,

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/949d8be7-8ca2-499d-90eb-aa621498b038%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Matthew Woodward]

Thanks for the response! Turns out that it was actually a bug in pyodbc that's already been fixed:
https://github.com/mkleehammer/pyodbc/issues/38

Working for me now, or at least the import is. :-) Running into another issue that'll hopefully be fixed soon:

https://github.com/mkleehammer/pyodbc/issues/40

https://github.com/mkleehammer/pyodbc/issues/41

Thanks again for the input!

You received this message because you are subscribed to a topic in the Google Groups "Django users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/django-users/Krnd1cN7YX0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to django-users...@googlegroups.com.

To post to this group, send email to django...@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAAJxEYskHp3SLs8AWZ5p1Zge0mQHhFtUOBQ-5TShfhU-DNrVYQ%40mail.gmail.com.