Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

10.4: Compile Intel-native MyODBC drivers UNIX
If you're a web or FileMaker developer and need access to MySQL databases via ODBC, you probably know that there are no binary distributions of MyODBC drivers that work on an Intel Mac. The PowerPC version won't work, and just trying to compile from source won't either.

After discussions with others, we've succeeded in compiling myODBC and it works! The trick is that you need to make simple changes in three files. Change the references to odbcinst.h to iodbcinst.h in these files: util/MYODBCUtil.h, driver/myodbc3.h, and myodbcinst/myodbcinst.c.

A short article and video tutorial on the process can be found on our site.

[robg adds: Apparently this information is in a README.osx in the distribution, but many haven't found that (judging by the results of a quick net search). This thread on the macosxhints' forums also covers the problem; if you need more detail on the process, check either link.]
    •    
  • Currently 3.25 / 5
  • 1
  • 2
  • 3
  • 4
  • 5
  (4 votes cast)
 
[6,189 views]  

10.4: Compile Intel-native MyODBC drivers | 4 comments | Create New Account
Click here to return to the '10.4: Compile Intel-native MyODBC drivers' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
10.4: Compile Intel-native MyODBC drivers
Authored by: alex_kac on Dec 11, '06 11:22:33AM

Maybe its me - but why post a video when you could just post the binaries?



[ Reply to This | # ]
10.4: Compile Intel-native MyODBC drivers
Authored by: zellpharm on Dec 12, '06 07:40:15AM

I thought it would be a good idea to teach people how to go through the steps...
In any case, I've posted the binaries. You're welcome ;)



[ Reply to This | # ]
10.4: Compile Intel-native MyODBC drivers
Authored by: alex_kac on Dec 12, '06 04:56:24PM

Good point. The point of my question was that you've spent some time getting the compiled version working - and a lot of other people would enjoy the Intel-compiled version, so why make them watch a video and for most of them do things they don't have a clue about anyway?

My question came mainly because I've seen a flurry of these types of posts - here is how to do x all by yourself which left out people who either lacked the experience or time to watch, read, and perform the steps and so I was curious why.

Oh and thank you for the binaries ;)



[ Reply to This | # ]
10.4: Compile Intel-native MyODBC drivers
Authored by: comet270 on Feb 08, '07 09:24:26AM
I downloaded the www.graphiccare.ca binaries and followed the odbcAdmin setup instructions from the video, but encountered the following when I tried to use them:
[iODBC][Driver Manager]dlopen(/usr/local/myodbc/lib/libmyodbc3-3.51.12.so, 6):
Library not loaded: /usr/lib/libltdl.3.dylib
Referenced from: /usr/local/myodbc/lib/libmyodbc3-3.51.12.so
Reason: image not found
--------------------------------
I checked and the *.dylib mentioned did not exist.

Anyone know what to do, or do I have to wrestle with the procedure for doing a local compile.

Thanks for anyone's advice,
Jim

[ Reply to This | # ]