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

jbogari has asked for the wisdom of the Perl Monks concerning the following question:

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.

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

Replies are listed 'Best First'.
Re: Installing iodbc 0.1 via CPAN (or other means) on Mac OS 10.6 by Anonymous Monk on Aug 05, 2011 at 07:00 UTC
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, );` [download] The GNU configure and build system	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re: Installing iodbc 0.1 via CPAN (or other means) on Mac OS 10.6
by Anonymous Monk on Aug 05, 2011 at 07:00 UTC

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,
);
[download]

The GNU configure and build system

[reply]
[d/l]
[select]

Back to Seekers of Perl Wisdom