Bug #29789 Install File Missing for MacOS X ODBC Driver
Submitted: 13 Jul 2007 15:25 Modified: 26 Jul 2007 15:25
Reporter: Marc Pope Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Documentation Severity:S1 (Critical)
Version:all OS:Mac OS X (10.4.10 Intel)
Assigned to: MC Brown CPU Architecture:Any
Tags: install, mac, mac osx, ODBC

[13 Jul 2007 15:25] Marc Pope
Description:
All the Mac OS X ODBC drivers available no longer come with a .dmg installer and instead come with a tarball. This is fine, however, there is no instructions, no make, no nothing. The README states to see the INSTALL file yet it does not exist. It's really pointless to release this because no one is able to use it.

Please provide instructions. I really need to use this. I have posted in the forums with no responses and others have also.

How to repeat:
Download and try to install it.

Suggested fix:
Provide instructions.
[13 Jul 2007 15:54] Valeriy Kravchuk
Have you read this, http://dev.mysql.com/doc/refman/5.0/en/myodbc-installation-binary-macosx.html?
[13 Jul 2007 16:36] Marc Pope
I have tried those instructions. First off, there is no /usr/local folder in OSX. I created it and tried the instructions. And I got this:

dyld: Library not loaded: /usr/lib/libltdl.3.dylib
  Referenced from: /usr/bin/myodbc3i
  Reason: image not found
Trace/BPT trap

So I tried copying them also so /usr/bin and /usr/lib and issued the command and I got this:

[myodbc3i.c][589][ERROR] ODBC Installer error 1: General installer error
[myodbc3i.c][590][ERROR] Failed to register driver

So I am stuck there. I have tried this on a Fresh install of OS X to be sure nothing was altered.

Thanks
[13 Jul 2007 17:21] Valeriy Kravchuk
OK, thank you for a reasonable documentation request then.
[17 Jul 2007 17:00] Steven eliuk
Exact same thing is happening to me, fressh install of max osx intel

Please help, i need this asap.

Where to go from here?
[17 Jul 2007 19:06] Tim Schutt
exact same problem here. 

Intel iMac, 10.4.10, fresh install of MySQL 5.0.27, installed "/lib" folder contents into "/usr/lib" and "/bin" contents into "/bin"

Help!!! ;-)
[20 Jul 2007 2:23] Marc Pope
Here is a possible method for installation. I am attempting it tonight but I thought I'd pass this on. 

From Paul Fabris:

I've been playing with a demo copy of the new Filemaker Pro 9, especially interested in it's ability to put a Filemaker face on ODBC mysql data sources.
Some tips that may help other users trying to setup MySQL ODBC datasources without flailing around for hours like me.
You can download free ODBC drivers from MySQL, and they work well, but there's little or no documentation on setup. Here's how to do it:
Installing the drivers:
1. Download the TAR files from MySQL's Connectors/ODBC site:
http://dev.mysql.com/downloads/connector/odbc/3.51.html#macosx
(Choose the PowerPC or x86 archive as appropriate to your Mac)
2. Extract the downloaded .tar.gz by double-clicking on it. Rename the resulting folder to "myodbc".
3. Copy this folder to your /usr/local/ folder. Best way to do this is using the terminal and the sudo command to preserve permissions.
sudo cp /Users/myhomefolder/path/to/myodbc /usr/local/myodbc
Now it's installed, ready for configuration.
Configuring ODBC:
1. Launch: /Applications/Utilities/ODBC Administrator
2. Important: Click the Lock icon at the bottom and Authenticate yourself. If you miss this, you won't be able to setup System DSNs.
3. First, you must add the newly installed ODBC driver. Click the Drivers tab. Click the Add button, and fill out the dialog:
Description: MyODBC3 Driver
Driver file: /usr/local/myodbc/libmyodbc3.so
Setup file: (leave blank, it will automatically use /Library/ODBC/odbcinst.ini)
Define as: System (This is important! Use System! This will allow you to create System DSNs, which are the only kind Filemaker 9 Seems to see)
Click OK
4. Now that you have a Driver, you can setup a DSN. Click on the System DSN tab. Don't bother with User DSNs. Filemaker doesn't see them. Click the Add button.
5. Important: The Data Source Name (DSN) field will allow you to type any alphanumeric string of text, as this is supposed to be an abstracted piece of information, but Filemaker or the MySQL ODBC driver implicitly assumes that the DSN is the same as the mysql database name. If there is a mismatch, you will get an error down the line. So, use a DSN that is the *same* as the name of the mysql *database* that you want to connect to.
NOTE: ODBC Administrator doesn't like DSNs with anything besides alphanumeric characters. It will complain if you type in something like "my_database", even though that's a perfectly legitimate MySQL database name. For now, remove any underscores, we'll fix that later.
6. Description: anything you want.
7. Add the following Keyword/Values by clicking the Add button:
Server IP address of your mysql server
Database name of your mysql database
Username the mysql username under which you want to connect to the server
Password self explanatory, can be left blank for blank passwords.
8. Click OK.
Now you have a DSN. Now you can go to Filemaker and "Manage Data Sources" and connect to any table in the MySQL database defined in the DSN using ODBC. Filemaker will let you add a Table Occurrence for the mysql table and you'll be able to proceed from there.
Manual Editing of DSN Names in the odbc.ini file:
If your mysql database name contains underscores, and ODBC Administrator will not let you put underscores in the DSN name field of the Add DSN dialog, you will be caught in a Catch-22. In Filemaker, when you connect to your ODBC DSN, you will get a dialog complaining that ODBC could not connect to "databasename", where "databasename" is your DSN name and "database_name" is the actual name of the database. For some reason, the "Database" Key/Value item is ignored at this stage.
To correct this, we must manually edit the odbc.ini file. Using BBEdit or pico or some text editor that allows you to edit files as root, open:
/Library/ODBC/odbc.ini
You will see 2 instances of the DSN name: once under the [ODBC Data Sources] section, and again in square brackets further below. Edit *both* these instances of the DSN name so that it matches the name of the mysql database that you want to connect to. Save the file, and in Filemaker, try again. You should no longer see the ODBC error when Filemaker tries to access the database over ODBC.
[26 Jul 2007 15:25] MC Brown
I've updated the documenation for the OS X installation so that it now shows the manual installation. This applies to version 3.51.13 through to 3.51.17. 

The forthcoming 3.51.18 includes a new installer for OS X.
[30 Aug 2007 7:56] Rudo Niemeijer
Now that the installer is there, I still run into problems. The ODBC Manager often crashes leaving me with incomplete odbc.ini and odcbinst.ini files. While the odbc.ini looks complete the odbcinst.ini is allmost empty. Could you post somewhere examples of properly filled files. That would enable me to manually edit these files by changing the content as I need them her at my installation. That would be helpning unsers that run into this same problem.
[30 Aug 2007 11:59] Susanne Ebrecht
Hi Rudo,

the configure files odbc.ini and odbcinst.ini are not from the MySQL ODBC. They come with your unixODBC or libiodbc or whatever you use as ODBC driver.

Regards,

Susanne