If you need ODBC in your Perl programs on OS X, don't try to build DBD::ODBC against Apple's built-in driver manager - it's an exercise in futility. After struggling with it for some time, I built a vanilla iODBC driver manager in /usr/local and built DBD::ODBC against it. Success!
Now if any of you have managed to make DBD::ODBC work with Apple's driver manager, I'd love to hear how. I searched for a while, but turned up nothing.