I have just transitioned to a Mac (from Win) and I cannot find the proper way to make a script work (it did on Win).
I am using import pyodbc
on the first line and I get the "No module .." error.
Later Edit: I changed the first line to import pypyodbc
If I enter the workspace in the preexistent python version (2.7.10) I can import the module but the script fails with:
pyodbc.Error: ('00000', '[00000] [iODBC][Driver Manager]dlopen({SQL Server}, 6): image not found (0) (SQLDriverConnect)')
I want to use python3 anyway.
If I enter python3, when trying to import the module I get an error.
My main problem is that I an not sure how to find where the problem is. Can anyone help with this?
Later Edit
It worked if I used pypyodbc
instead of pyodbc
. It imports the module and the only thing left to solve is the decoding part: UnicodeDecodeError: 'utf-32-le' codec can't decode bytes in position 0-1: truncated data