Forum Discussion

Copper Contributor

Mar 19, 2021

Connecting to an SQL Server ODBC via a Mac using Excel

Hi there, I am trying to connect to a SQL Server Analysis services Cube on my macOS Big Sur (version 11.2.3) through Excel (version 16.47). I go to get External Data > new database query > SQL se...

excel

Excel on Mac

ocirelos

Copper Contributor

Jun 17, 2021

rodrigovc Hello, same problem here. How did you add the port number? I've tried with colon (:) and comma (,) but neither has worked. Woud really appreciate your help with this.

rodrigovc

Copper Contributor

Jun 22, 2021

ocirelos with a coma (,) IP\sqlname,XXXXX (port number) something like that:

156.239.367.59\sqlname,58357