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...]
- Download version 3.51 the binary of the myodbc driver.
- Uncompress the downloaded file, and save it somewhere like ~/Public/myodbc. The folder should contain the following files:
- COPYING
- libmyodbc3-3.51.04.so
- libmyodbc3.a
- libmyodbc3.la
- libmyodbc3.lai
- libmyodbc3.so
- README
- RELEASE-NOTES
- 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 =
- 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:
- /Library/Frameworks/iODBCinst.framework
- /Library/Frameworks/iODBCadm.framework
- /Library/Frameworks/iODBC.framework
- /Library/CFMSupport/iODBC CFM Bridge
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