Article:		Open Database Connectivity in Jaguar, Part 2
Subject:		iODBC
Date:		2003-07-26 10:31:27
From:		anonymous2
I could not get ODBC to work without downloading OpenLink Software's iODBC sdk. It's simple to install so you might as well use it. As the author states it has more features than Apple's ODBC Administrator app. Apple's ODBC Administrator does not seem to work at all. I got PostgreSQL working with Excel after I updated Office V.x and downloaded Microsoft Query X for Mac. You can get the updates for Excel at http://www.microsoft.com/mac/downloads.aspx.

Showing messages 1 through 1 of 1.

• iODBC
  2003-08-17 02:16:47  anonymous2 [Reply | View]
  
  
  It *is* possible to get an ODBC connection working to MySQL just using Apple's ODBC Administrator.
  
  The odbctest program will work fine.
  
  *However*, Excel v.X (ie Query) will *not* work unless you install the iODBC SDK. This is because Query is a CFM application, and the ODBC libraries that Apple installs are Mach-O libraries (a different format). One file the iODBC SDK installs is a "bridge" that lets CFM apps like Query use the Apple libraries. After you install the bridge, Query works fine :-)