
If yes, I invite you to leave a comment, where you should also explain your reasons why you have done that shift. Today I want to ask you a very simple question: Are you also a SQL Server Professional and running on Mac? And for serious SQL Server stuff, I’m using a RDP connection to a full-blown rack server which is hosted in the basement of my house. In my case I’m using a 2012 MacBook Air with a VMware Fusion VM where my SQL Server is installed. Since the summer of last year I have also joined that group of people, and I’m doing the same. Now click the Close button to end the installation.I know a handful people who are SQL Server Professionals and using for their day-2-day job a Mac system. You’ve installed OpenLink Software ODBC on your Mac OS X. Enter your administrator Passord and click the OK button to Install MySQL Lite. The MySQL Lite tool is obviously cross-licensed by OpenLink Software and a dependency when working with the MySQL database. That enabled me to click Use existing License because I’d downloaded it too.
The next dialog is a surprise if you closed your browser because you need the trial license that was on the download page. Enter the Password and click the OK button to install the product.
The installation prompts for the system administrators password. The standard install isn’t small and it includes a driver manager. Click the Agree button that you read the license to proceed. Click Continue to get the acknowledgment that you read the license agreement. Click the Continue button to proceed with the installation. It’s amazing that there’s no better alternative but it appears that the Microsoft Query components also require Rosetta but I’ve not done a complete dependency check. Rosetta enables Power PC software to run on Intel-based Mac OS X. When you attempt to use the software, Microsoft Excel 2011 will prompt you to install Rosetta Software. What you won’t see clearly is that the OpenLink Software is native to the Power PC not Intel architecture. At this stage, you confirm that you have the correct version by reading through the Read Me dialog. The Welcome Dialog confirms that you are installing the correct version of their Universal Data Access Driver Suite. After completing all the input screens, you should get a web page like this: You need to follow the instructions carefully at the vendors site. Picking the right version of the OpenLink Software is tricky. Before you close that page, download the license file that’s shown or Step #8 will be harder than it should be to complete. The following are the screen shots to install OpenLink Software’s driver on the Mac OS X Snow Leopard.
It’s one of the two options that users have when they want to connect Microsoft Excel 2011 to a MySQL 5.5.
The OpenLink Software provides an ODBC Driver for MySQL 5.x.