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 need to get some data from an SQL Server and I have an .odc file.
I have installed the ODBC drivers from actual and have connected to the databases.
When I select Create Pivot Table and external data source and I click the "Get Data.." button it opens iODBC chooser.
When I select file DNS it defaults to a directory named /Library/ODBC/ODBCDataSources and the list is empty. I have verified that my .odc file is in there. If I try to navigate the directory structure Microsoft Query crashes.
I am using Mac OS X 10.8.2
Any Hints? Any other way to use the .odc file?
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.
Answer accepted by question author
Apple discontinued support for Rosetta. You now must add new data sources in the Mac OS ODBC data choose (Applications > Utilities folder).
See Important note for users of Lion and Mountain Lion in this tutorial **Part 7 - Queries - A step by step how-to example**