Need Apple Silicon / M1 builds

[vpoirot]

Installation fails on Mac OS 11.0

It seems the binary have not been released yet.

Manual installation fails as well from whl file :

ERROR: pyodbc-4.0.30-cp39-cp39-macosx_10_9_x86_64.whl is not a supported wheel on this platform.

Do you know any workaround?

[tovolkmar]

I was able to run it under Mac OS 11.0 on a MacBook Air with the new M1 chip.
You need to download the source by yourself and run python setup.py build followed by python setup.py install.

[v-chojas]

That said, the ARM Mac ODBC drivers which you will need are probably still rather uncommon for the time being, given that Apple just released the new M1 Macs recently.

[fonnesbeck]

I'm able to install, but running connect fails:

InterfaceError: ('IM002', '[IM002] [unixODBC][Driver Manager]Data source name not found and no default driver specified (0) (SQLDriverConnect)')

If I look at drivers(), it also returns an empty list. However, I am able to connect using isql with the data source name as an argument, so it does not appear to be an issue with FreeTDS or unixODBC.

The main departure from the install instructions for me is that I used MacPorts (Homebrew does not work for M1 yet). I wonder if that has anything to do with it (i.e. files being located in /opt). The setup.py script seems to account for this though.

[v-chojas]

You can see which unixODBC the pyODBC has linked to, run otool -L on the pyODBC library you get with

import pyodbc.
pyodbc.__file__

[fonnesbeck]

I'm getting:

otool -L /Users/cfonnesbeck/anaconda3/lib/python3.8/site-packages/pyodbc.cpython-38-darwin.so

/Users/cfonnesbeck/anaconda3/lib/python3.8/site-packages/pyodbc.cpython-38-darwin.so:
	@rpath/libodbc.2.dylib (compatibility version 3.0.0, current version 3.0.0)
	@rpath/libc++.1.dylib (compatibility version 1.0.0, current version 1.0.0)
	/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1292.0.0)

[v-chojas]

That indicates it will be loaded from whatever happens to be in the rpath when the Python is running, and since that depends on what other libraries it has, it is probably easier to run
find / -name libodbc.2.dylib to show all the occurrences of unixODBC libraries you have; I suspect there is more than one.

[mkleehammer]

I'm going to rename this to emphasize the issue is Apple Silicon / M1 compatibility. I have access to an M1 Air (though I'm not sure the wife is going to like that :) ) but I've been waiting because of the Homebrew issue. I'm interested in any feedback people have and suggestions on which DBs can be run natively on the M1 for testing.

[Bearzooka]

Just FYI @mkleehammer brew is already working for Apple Silicon, with just a slight change on the PATH.

[marcozanella]

I was able to run it under Mac OS 11.0 on a MacBook Air with the new M1 chip.
You need to download the source by yourself and run python setup.py build followed by python setup.py install.

Hi, I am having a fatal error: 'sql.h' file not found error. sql.h doesn't look to be part of the package.
pyodbc installs just fine, with brew.

[v-chojas]

You need to install unixODBC. Please, read the documentation: https://github.com/mkleehammer/pyodbc/wiki/Building-pyodbc-from-source

[msarm]

You need to install unixODBC. Please, read the documentation: https://github.com/mkleehammer/pyodbc/wiki/Building-pyodbc-from-source

I don't see any documentation from your link that talks about the installation of unixODBC specific for Apple Silicon/M1 , can you provide exact steps if you were successful?