[MacPorts] #67379: sqlcmd from mssql-tools trying to use file from Homebrew

[MacPorts]

#67379: sqlcmd from mssql-tools trying to use file from Homebrew
----------------------+-------------------------
 Reporter:  posguy99  |      Owner:  (none)
     Type:  defect    |     Status:  new
 Priority:  Normal    |  Milestone:
Component:  ports     |    Version:  2.8.1
 Keywords:            |       Port:  mssql-tools
----------------------+-------------------------
 mssql-tools and msodbcsql17 both install without error.  However, sqlcmd
 does nto launch, it tries to use a dylib from Homebrew.

 {{{
 $ sudo port install mssql-tools
 --->  Computing dependencies for mssql-tools
 --->  Cleaning mssql-tools
 --->  Scanning binaries for linking errors
 --->  No broken files found.
 --->  No broken ports found.
 [ 8:01 AM][ttys000 +1][~]
 [929] mbp13 $ port info mssql-tools
 mssql-tools @17.10.1.1_1 (databases)

 Description:          Sqlcmd and Bcp for Microsoft(R) SQL Server(R)
 Homepage:             https://docs.microsoft.com/en-us/sql/tools/sqlcmd-
 utility

 Runtime Dependencies: msodbcsql17
 Platforms:            darwin
 License:              Restrictive
 Maintainers:          Email: jann at macports.org, GitHub: roederja
                       Policy: openmaintainer

 $ sudo port install msodbcsql17
 --->  Computing dependencies for msodbcsql17
 --->  Cleaning msodbcsql17
 --->  Scanning binaries for linking errors
 --->  No broken files found.
 --->  No broken ports found.

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

 $ locate libmsodbcsql.17.dylib
 /opt/local/lib/libmsodbcsql.17.dylib

 }}}

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