Forum Discussion

Zubin_roy's avatar
Zubin_roy
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
rodrigovc's avatar
rodrigovc
Copper Contributor
May 11, 2021

Zubin_royI have the same error message that you report. I solved it adding, port number (in my case, 57151). So I was able to enter my SQL database, however access to the databases gives me an error. I can see the list of my databases but when I try to access one of them it does not extract the information from the database and reports a nonsense table (see attached photos). Tell me if you were able to solve the access to your database and if you had the same problem?

  • ocirelos's avatar
    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's avatar
      rodrigovc
      Copper Contributor
      Jun 22, 2021

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

      156.239.367.59\sqlname,58357 

Resources