Use the myodbc driver with Excel v.X via MS Query

Dec 12, '02 09:54:00AM

Contributed by: dmarkman12345

Here are the steps you need to make Excel v.X work with the open source myodbc
driver.

[Editor's note: I have not tested this hint myself...]

  1. Download version 3.51 the binary of the myodbc driver.

  2. Uncompress the downloaded file, and save it somewhere like ~/Public/myodbc. The folder should contain the following files:
  3. Create two files, ODBC.preference and ODBC Installer.preference with UNIX style end-of-line markers. Create both of these files in ~/Library/Preferences. Here is a content of those files (all values could be changed):

    ODBC.preference
    [ODBC Data Sources]
    myodbc = myodbc

    [myodbc]
    Driver = /Users/username/Public/myodbc/libmyodbc3-3.51.04.so
    Description = myodbc
    Server = 127.0.0.1
    UID = dbusername
    Password = dbpassword
    Database = dbname
    ODBC Installer.preference:
    [ODBC Drivers]
    myodbc = Installed

    [myodbc]
    Driver = /Users/username/Public/myodbc/libmyodbc3-3.51.04.so
    Setup =
  4. Download and install iODBC SDK for Jaguar (or whatever) from openlinksw.com (as I understand it, it's distributed under the GPL). The installer installs the following frameworks and extensions:
NOTE: The iODBC SDK installer installs iODBC Administrator application. That application can create ODBC.preferences and ODBC Installer.preference. However, it crashes every time you want configure data source (BTW it doesn't crash for openlink mysql lite driver), so just run iODBC Administrator application, add your driver and afterwards, edit the preference files manually.

Comments (7)


Mac OS X Hints
http://hints.macworld.com/article.php?story=2002121206540038