Expected location of iodbc libraries

[Ed Mansky]

Hi all,
   I'm trying to get Open Office to use my MySQL database as a datasource.

   My config is:  Mac OSX 10.2.8  w/gcc 3.3 (Apple's supplied Aug 03 Dev Tools)
                  MySQL 4.0.22 (server built from source code, client 
taken from binary 4.0.21)
                  libiodbc 2.1.10 built from source
                  MyODBC 3.51.09 built from source
                  Open Office 1.1.2 from OSX binary

   Anybody get Open Office to connect via MyODBC/libiodbc to MySQL ? 
Specifically, where does the OO binary expect
  the library libiodbcinst.dylib to reside ?  I've built 
libiodbc2.1.10.dylib and installed it in /usr/local/lib and created
  the symlink libiodbcinst.dylib in both /usr/local/lib and /usr/lib 
and OO still doesn't find them. Got LD_LIBRARY_PATH and
  DYLD_LIBRARY_PATH both defined as well.

   Any ideas would be greatly appreciated!

Ed
-- 
E. J. Mansky II
Eikonal Research Institute
Bend, OR.