Connecting to an SQL Server ODBC via a Mac using Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2222742%22%20slang%3D%22en-US%22%3EConnecting%20to%20an%20SQL%20Server%20ODBC%20via%20a%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2222742%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20connect%20to%20a%20SQL%20Server%20Analysis%20services%20Cube%20on%20my%20macOS%20Big%20Sur%20(version%2011.2.3)%20through%20Excel%20(version%2016.47).%20I%20go%20to%20get%20External%20Data%20%26gt%3B%20new%20database%20query%20%26gt%3B%20SQL%20server%20ODBC%20and%20type%20in%20the%20server%20details%20but%20get%20an%20error%20whenever%20I%20try%20to%20connect.%20(See%20attached%20image)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%22odbc%20driver%2017%20for%20sql%20server%20tcp%20provider%3A%20error%20code%200x102%22%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20normally%20a%20straightforward%20enough%20task%20to%20do%20using%20a%20Windows%20PC%20and%20Excel%20but%20cannot%20seem%20to%20get%20it%20to%20work%20on%20a%20Mac.%20Any%20help%2Fadvice%20would%20be%20appreciated%20as%20I%20have%20been%20struggling%20with%20this%20for%20a%20while.%20Our%20connections%20to%20a%20SQL%20servers%20via%20Excel%20in%20Mac%20possible%20to%20do%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2222742%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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 server ODBC and type in the server details but get an error whenever I try to connect. (See attached image) 

 

"odbc driver 17 for sql server tcp provider: error code 0x102"

 

This is normally a straightforward enough task to do using a Windows PC and Excel but cannot seem to get it to work on a Mac. Any help/advice would be appreciated as I have been struggling with this for a while. Our connections to a SQL servers via Excel in Mac possible to do?

 

Thanks!  

3 Replies

@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?

@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.

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

156.239.367.59\sqlname,58357