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.

In reply to Installing iodbc 0.1 via CPAN (or other means) on Mac OS 10.6 by jbogari

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.