Installing iodbc 0.1 via CPAN (or other means) on Mac OS 10.6

[jbogari]

Need some help with the finer points of coercing CPAN package iodbc to build successfully and install on Mac OS 10.6.

Some background: Before you just direct me to the obvious alternative, DBI / DBD, FreeTDS and ODBC, understand that this effort is intended to replicate an existing development environment that has iodbc / FreeTDS installed on Solaris.

I have no little to no control over this environment, and those are the facilities I have to access MS SQL Server. I have numerous apps written in this environment, and I would like to be able to develop remotely - in an equivalent (portable) environment.

I have everything solved except iodbc. Yes, Perl and the libraries are known to be weak / broken on Mac OX 10.6. I have installed other Perl builds and have applied the libraries intended for repairing OS X's ODBC libraries from OpenLink:

http://wikis.openlinksw.com/dataspace/owiki/wiki/UdaWikiWeb/MacOSXiODBC

I have edited the CPAN-generated Makefile.PL to use the needed non-standard include path. To some benefit, I think.

I have tried to specify the needed library path, but to no effect. I still get "symbol not found errors", like this one:

http://sourceforge.net/mailarchive/forum.php?thread_name=D3A55201-3D0A-48D1-A745-6C5ECF8FC57B%40openlinksw.com&forum_name=iodbc-macosx

Has anyone gotten this working? Recently?

I am far from a gcc expert, and am new to CPAN. I can follow a nasty, complicated how-to, if there was one. But I seem to be alone in this position.

Where to turn for help?

I'd appreciate any input. Thanks.

[Anonymous Monk]

Where to turn for help?

Some kind of qualified sysadmin :) iodbc mailing list...

I think, your problem might actually be very simple, see Re^2: Fuse and fuse_loop and the links it lists.

More generic-er advice that applies to DIY build enviroment

MinGW/MSYS development environment - Setting up the base system

sh configure --enable-static --enable-shared --with-libxml-include-prefix=C:/msys/1.0/local/include/libxml2

$config{LIBS}='-l...libxml2.a -l...libiconv.a';
$config{INC}='-I...include/libxml2';
$config{DEFINE} =' -DLIBXML_STATIC ';
WriteMakefile(
              %INFOS,
              %config,
);

The GNU configure and build system