I've seen [Pypyodbc: Can't open lib 'FreeTDS' : file not found") error when trying to connect to SQL server](https://stackoverflow.com/questions/28566121/pypyodbc-cant-open-lib-freetds-file-not-found-error-when-trying-to-conne), but. that's 7 years old, and doesn't seem to be working for me, possibly because brew appears to be putting things in different places now?

I've used brew to install unixodbc, it's in `/opt/homebrew/Cellar`.

When I do pip install pyodbc, it appears to work, but I get:

```
 connection = pyodbc.connect(connection_string)
pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libtdsodbc.so' : file not found (0) (SQLDriverConnect)")

```

which is obviously wrong, because libtdsodbc is in `/opt/homebrew/lib`

I tried editing `odbcinst.ini`, but I'm not sure where that's supposed to live. There wasn't one in /etc, or a /etc/unixODBC directory... and when I create either one, the don't seem to be read, because it still complains about /usr/local/lib...

ETA: This is on a new Macbook, so on one of the new M1 chips.