[MacPorts] #67379: mssql-tools @17.10.2.1_1: Can't open lib '/opt/homebrew/lib/libmsodbcsql.17.dylib' : file not found.

[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  |
--------------------------+----------------------

Comment (by kencu):

 well, I might learn something here! Here was how the ports were installed
 for me:
 {{{
  % otool -L /opt/local/bin/sqlcmd
 /opt/local/bin/sqlcmd:
 /System/Library/Frameworks/CoreFoundation.framework/Versions/A/CoreFoundation
 (compatibility version 150.0.0, current version 1770.255.0)
         /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current
 version 1292.60.1)
         /usr/lib/libiconv.2.dylib (compatibility version 7.0.0, current
 version 7.0.0)
         /opt/local/lib/libodbc.2.dylib (compatibility version 3.0.0,
 current version 3.0.0)
         /usr/lib/libc++.1.dylib (compatibility version 1.0.0, current
 version 904.4.0)

  % otool -L /opt/local/lib/libmsodbcsql.17.dylib
 /opt/local/lib/libmsodbcsql.17.dylib:
         /opt/local/lib/libmsodbcsql.17.dylib (compatibility version 0.0.1,
 current version 10.2.1)
 /System/Library/Frameworks/CoreFoundation.framework/Versions/A/CoreFoundation
 (compatibility version 150.0.0, current version 1770.255.0)
         /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current
 version 1292.60.1)
         /opt/local/lib/libodbcinst.2.dylib (compatibility version 3.0.0,
 current version 3.0.0)
         /System/Library/Frameworks/Kerberos.framework/Versions/A/Kerberos
 (compatibility version 5.0.0, current version 6.0.0)
         /usr/lib/libiconv.2.dylib (compatibility version 7.0.0, current
 version 7.0.0)
         /usr/lib/libc++.1.dylib (compatibility version 1.0.0, current
 version 904.4.0)

 % sqlcmd
 Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Can't open lib
 '/opt/homebrew/lib/libmsodbcsql.17.dylib' : file not found.
 }}}

 because sqlcmd had no embedded library reference to libmsodbcsql.17.dylib,
 I thought it was dlopened internally, hardcoded.

 Let me try it with your changes!

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