Problem with connection Mac Excel 2016 to SQL server

Question

We have a problem with Excel, where we have stored data.

Excel have external connection to SQLserver. In previous version (Excel for PC) connection  works fine, but problem is, if I open this excel spreadsheet in MAC excel 2016. Connection do not refresh data. If we configure new connection with these parameters (got from provider): 

Provider=SQLOLEDB.1;

Password=xxxxxxxxxxxxxxx; <<< Heslo

Persist Security Info=True;

User ID=uxls4fytXXXX; <<< Uživatel

Initial Catalog=m4c_Reporting; <<< Databáze

Data Source=athena.absrXX.XXX; <<< Server

Use Procedure for Prepare=1;

Auto Translate=True;

Packet Size=4096;

Workstation ID=FytoPC;

Use Encryption for Data=False;

Tag with column collation when possible=False

We got error:

Translated: "during creation of object converter UNICODE was error ICU"... 

Any help?

Thank you 

Jiri

Answer 1

Hi Jiri,

Since the issue is related to SQL for Excel, we have no environment to help you test, following are some suggestion and questions for you.

I would suggest you check if the same connection also work for other data source.

According to my test, if I import data from a database in Excel for Mac following the steps in this article, when I click "Data" tab> New Database Query> SQL Server ODBC, there will be a window called "Connect to SQL Server ODBC Data Source" pops up and ask me to type in Server name, Database, Authentication, User Name and Password.

For the following content, I would like confirm you used them for what.

Provider=SQLOLEDB.1;

Password=xxxxxxxxxxxxxxx; <<< Heslo

Persist Security Info=True;

User ID=uxls4fytXXXX; <<< Uživatel

Initial Catalog=m4c_Reporting; <<< Databáze

Data Source=athena.absrXX.XXX; <<< Server

Use Procedure for Prepare=1;

Auto Translate=True;

Packet Size=4096;

Workstation ID=FytoPC;

Use Encryption for Data=False;

Tag with column collation when possible=False

In addition, please try to create a new workbook to do the connection to see the result.

If you can connect to it successfully in the new workbook, then please also try to open the workbook in your Windows computer to see if you can refresh the data.

To better understand your situation, please help confirm some information:

1. What is the Office version number? You can click Excel menu> About Microsoft Excel> Version number like 16.16.
2. Could you please list the steps you connect to the database? If necessary, please also capture some screenshots to clarify.

Meanwhile, I find a article for you: Known Issues in this Version of the Driver.

You can check the article to see if it can help you.

Best Regards,

Gloria

Answer 2

That number is a scam.  It is NOT Microsoft online support.

I know - If you look at my answer, you can find it. 

But I still need help with connection... 

Jiri

Answer 3

That number is a scam.  It is NOT Microsoft online support.

Answer 4

call like this? https://answers.microsoft.com/en-us/msoffice/forum/msoffice\_sway-mso\_win10/warning-microsoft-alleged-sanctioned-scan-to-get/77f0a59c-d820-4141-910d-225b3463aa93

Is anybody to help officially from Microsoft?