Getting ODBC working on OS X is pretty easy, but you’ll have to find the damn drivers first. First grab the newest iODBC SDK from the Software Availability page, and then grab the the Universal Data Access Drivers from the OpenLink download page. Install the SDK first, and then the drivers.

Once you’ve installed both of those packages you will have a new iODBC Administrator program in your Applications/Utilities/ directory. Open it up and add a System DSN just as you would on a Windows machine.