title: Connecting to SQL Server 2008 from a Mac
body: <p>Office for Mac 2011 has better support for Pivot Tables in Excel, including external data.  </p>
  
  <p>I need an ODBC connection on a Mac to SQL Server 2008.  Microsoft recommends using a JDBC driver, but the documentation for it is very, very, very weak. </p>
  
  <p>Here is the link to the JDBC driver: <a href="http://msdn.microsoft.com/en-us/sqlserver/aa937724" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/sqlserver/aa937724</a></p>
  
  <p>Now, once that is downloaded and extracted, you can add the JDBC driver via the <a href="http://support.apple.com/kb/dl895" rel="nofollow noreferrer">Apple ODBC Administrator</a>.  </p>
  
  <p><img src="https://i.stack.imgur.com/0JrJ0.png" alt="JDBC Driver">.  </p>
  
  <p>Finally, you can add the ODBC connection, but it won't let me edit the keyword or values.  </p>
  
  <p><img src="https://i.stack.imgur.com/3Blai.png" alt="ODBC Connection">: </p>
  
  <p>A few questions: 
  Am I using the right driver/do I have it installed correctly?<br>
  Is there a way to change the keyword values in the ODBC Administrator?</p>
  
  <p>Thanks</p>