This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a MySQL database 8.0.31 with ODBC drivers running local on my MAC. I know Excel can connect to it as you see from this screen shot where I use the Get Data (Power Query From Database (Microsoft Query) and from the dialogue box select System DSN and login with my credentials and are able to run a SQL query the database:
However, when I use Get Data (Power Query) From SQL Server ODBC and fill out the corresponding dialogue box, I get the following error:
I have also tried localhost 127.0.0.1 and also with port added like 127.0.0.1:3306.
Searching on this error does not tern up anything for my particular scenario. The best I can tell it can't find the host (but I'm at a loss as to what that syntax would be.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
The example I use for teaching SQL Server when connecting Excel requires a comma. I think there's only one or two valid port numbers. One of them is 49360
When I try a coma instead of a colon between the IP and Port, I get an immediate error as if the syntax is wrong. When I do the 127.0.0.1:3306 it acts like it is at least trying and times out
Hi
I would have expected to see the IP address of the SQL Server in the Server Name field. I think there's supposed to be a comma followed by the TCP port number.