Run the installer and just install the default components. If you are using Fusion you can simply drag and drop the installer to Windows. If you downloaded MS SQL Express on your Mac, you will need to make it accessible to your Windows VM. Go to and download MS SQL Express 2012, make sure to get the version with tools (named something like ENU\x86\SQLEXPRWT x86ENU.exe). I will be using Windows 7 (the version of IE doesn't matter).Īs you download the Windows VM you can also download the free version or MS SQL.Īt the time of writing the tiny_tds gem - the gem needed to access MS SQL - only supports MS SQL up to version 2012. Go to and download a VM (Virtual Machine) for your Mac. In this post I am using VMWare Fusion for virtualisation, but you could use something else and the instructions should be mostly portable. Many commercial applications take advantage of ODBC connectivity using this driver.I recently had to set up a MS SQL database on my Mac for a client project, if you ever have to do this here is a mini tutorial. Example source code is now available for Carbon, REALbasic, and PHP, and we will soon be providing tutorials and example source code for other languages.
You can use our driver to access a SQL Server database from your own custom applications - including PHP and REALbasic. Our driver uses the same terminology and we've organized our screens similarly. In addition, anyone who is already familiar with setting up an ODBC connection on Microsoft Windows will be right at home using our setup assistant. You just need an account, using whatever authentication method your organization has chosen. This means that no special configuration of the database is needed in order for you to connect.
Our driver supports both methods of SQL Server authentication - SQL Server accounts and trusted domain accounts.
That's why our driver resides only on the client Mac, and communicates with the database software that already exists on the server. IT support staff typically don't like to install special software on their servers - software that could affect the reliability or performance of a critical resource. Of these great cloud-based databases in just a few clicks. The Actual Technologies ODBC driver makes it easy to connect to both And Amazon Relational Database Service (RDS) providesĪ fast and easy way to configure multiple SQL Server versions in the cloud. Of a scaleable and reliable database with near-zero maintenance. The Microsoft Azure SQL Database is a great way to enjoy the benefits In addition to local databases, the driver now supports cloud-based solutions. For simple connections, you only need to specify 2 fields! All installation takes place on your Mac - nothing is installed on the server. On-line help is always available to provide explanations of all parameters. The driver includes a setup assistant that will walk you through setting up a connection to your database. Then you can use the information from the database in your spreadsheet formulas and charts and graphs. Use our ODBC driver to connect Excel to your company's SQL Server database. Microsoft Excel has built-in support for ODBC database queries.
Take Advantage of the Full Power of Excel There is no special configuration of the database required for you to connect - all you need is a user ID and password. Both methods of SQL Server authentication are supported: SQL Server native accounts and trusted domain accounts. This driver installs completely on your Mac nothing is installed on the server itself. The driver also connects to Sybase databases. You can connect to any database you are authorized to use, and work with the data just like your Windows-using co-workers. The Actual SQL Server ODBC Driver lets you access your company's Microsoft SQL Server database from within Microsoft Excel or FileMaker Pro.
Connect Microsoft Excel or FileMaker Pro on your Mac to your company's database for $39.95