Thank you for your reply and sorry for not being clear.
you are right: I do want to connect to a Microsoft SQL server (from Mac)
I installed a 45 day free trial RStudio Pro under the assumption that it comes with the use of RStudio Drivers (ODBC; unixODBC) for evaluation.
I try to connect to the SQL server using the "New Connection Pane" in RStudio,
I select SQLserver:
follow the UI to "Sqlserver Installation"
click "next" and get:
"Installing
Driver: Sqlserver
Version: 1.5.9.1000
Path: /Users/maikduwensee/.local/share/rstudio/odbc/drivers/sqlserver
Checking prerequisites
Error in prereqs() :
unixODBC is required but missing, you can install from http://www.unixodbc.org/. Alternatively, install Brew and RStudio will install unixODBC automatically, you can install Brew by running: /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
Calls: .rs.odbcBundleInstall -> .rs.odbcBundleCheckPrereqs -> prereqs
Execution halted"
fact is that I have brew installed:
Checking in Bash reveals:
brew --version
Homebrew 3.4.6
Homebrew/homebrew-core (git revision 8c4067c6e58; last commit 2022-04-13)
maikduwensee-FVFGT86TQ05P-MacBookPro:R_working maikduwensee$
I understand that RStudio would install unixODBC if brew is installed, which is doesn't seem to do in my case.
thank you for your hellp