Remember to run it as Administrator or you won’t be able to touch the System DSNs. The Physical Address is the adapter’s MAC address. Each adapter should have a Physical Address. In the Command Prompt window, type ipconfig /all and press enter. This shows both 32-bit and 64-bit DSNs and more importantly you can add and configure 32-bit DSN. Press Enter, or click on the Command Prompt shortcut. Ipconfig is very useful to check any networking issues, with ipconfig computer can read routers and modems whether internet connection is available or not when you are having problem connecting to. If you want to see and configure the 32-bit DSNs (which you would want to for supporting legacy processes), you have to run the 32-bit ODBC administrator CPL found here: C:\%windir%\SysWOW64\odbcad32.exe Something to note: It seems that the default Data Sources CPL only shows and configures 64-bit DSNs on a 64-bit Windows 7 install. With that done, I tested the spreadsheets once more and finally, no more errors refreshing data.
(System DSNs are only modifiable by the administrator.) Now that all the errors removing and adding DSNs had gone away, I removed the User DSN for Excel Files and re added it as System DNS for Excel Files using the version 14 driver. This package has no conflicts with Click-to-run. To be exact the Microsoft Access Database Engine 2010 Redistributable which installs version 14 of the ODBC drivers for Excel and Access. (I stole their image because I forgot to screenshot my error before fixing it.) I could try installing an older driver for Office 2010. That shows what I want to see 99 of the time, but ipconfig /all also shows things like DHCP lease times and servers.
where#HOW TO RUN AN IPCONFIG ON A MAC MAC OS X#
Googing the error I found this helpful page which gave me a hint of what I could try next. ipconfig shows things like hostname, DNS servers, those are in a different place than just IP addresses in linux, so you will need a couple of commands. If you momentarily forget where you are at a Mac OS X terminal session, you might type 'ipconfig /all' or something equally Windowish.
Playing around with the ODBC administration CPL some more, I eventually got it to generate another error when I tried to add the currently installed ver 16 Office ODBC Excel driver. It warned me that it was it did not play nicely with the Click-to-Run Office installs I had.
#HOW TO RUN AN IPCONFIG ON A MAC INSTALL#
However after downloading the x86 version of the run time (you need to match your office install architecture). (Access and Excel ODB C drivers are apparently related).
Looking for a current version driver proved difficult but eventually I discovered installing the Microsoft Access 2016 Runtime should do it.