[MacPorts] #67379: mssql-tools @17.10.2.1_1: Can't open lib '/opt/homebrew/lib/libmsodbcsql.17.dylib' : file not found. (was: sqlcmd from mssql-tools trying to use file from Homebrew)

[MacPorts]

#67379: mssql-tools @17.10.2.1_1: Can't open lib
'/opt/homebrew/lib/libmsodbcsql.17.dylib' : file not found.
--------------------------+----------------------
  Reporter:  posguy99     |      Owner:  roederja
      Type:  defect       |     Status:  closed
  Priority:  Normal       |  Milestone:
 Component:  ports        |    Version:  2.8.1
Resolution:  fixed        |   Keywords:
      Port:  mssql-tools  |
--------------------------+----------------------
Changes (by ryandesign):

 * cc: ryandesign (added)


Comment:

 This warning when installing the port from source on Apple Silicon (well,
 on Intel but with `os.arch=arm` on the command line) gave me the clue
 about why it didn't work:

 {{{
 Warning: reinplace s|/usr/local|/opt/local|g didn't change anything in
 /opt/local/var/macports/build/_Volumes_Shared_macports-
 ports_databases_msodbcsql17/msodbcsql17/work/msodbcsql-17.10.2.1/odbcinst.ini
 }}}

-- 
Ticket URL: <https://trac.macports.org/ticket/67379#comment:8>
MacPorts <https://www.macports.org/>
Ports system for macOS