 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Programming / Perl / July 2006Has anyone built DBD::ODBC?
Anyone have a recipe for building DBD::ODBC? sherm-- Web Hosting by West Virginians, for West Virginians: http://wv-www.net Cocoa programming in Perl: http://camelbones.sourceforge.net > Anyone have a recipe for building DBD::ODBC? 1. Sacrifice a goat... (Oh, come on, *someone* was going to say it... :-) dha  SignatureDavid H. Adler - <dha@panix.com> - http://www.panix.com/~dha/ A London.pm thread topic is like a non-alchoholic ingredient in a cocktail, its only there so you can pretend not to be an inebriated addict. - Greg McCarroll >> Anyone have a recipe for building DBD::ODBC? > > 1. Sacrifice a goat... > > (Oh, come on, *someone* was going to say it... :-) I find for my sacrificing needs squirrels are almost as effective, and *much* easier to come by. Daniel T. Staal --------------------------------------------------------------- This email copyright the author. Unless otherwise noted, you are expressly allowed to retransmit, quote, or otherwise use the contents for non-commercial purposes. This copyright will expire 5 years after the author's death, or in 30 years, whichever is longer, unless such a period is in excess of local copyright law. --------------------------------------------------------------- > Anyone have a recipe for building DBD::ODBC? I'm making some progress. Exporting ODBCHOME=/usr was enough to get it to build. But the tests still fail, and I haven't figured out why. Ah well, one step at a time. And, I'm all out of goats & squirrels, so no luck on that angle. sherm-- Web Hosting by West Virginians, for West Virginians: http://wv-www.net Cocoa programming in Perl: http://camelbones.sourceforge.net >> Anyone have a recipe for building DBD::ODBC? > [quoted text clipped - 3 lines] > > And, I'm all out of goats & squirrels, so no luck on that angle. Cats work real well. Joe. >>Anyone have a recipe for building DBD::ODBC? > >I'm making some progress. Exporting ODBCHOME=/usr was enough to get >it to build. But the tests still fail, and I haven't figured out >why. Ah well, one step at a time. So far as I can see I've succeeded. First by installing this <http://www.iodbc.org/downloads/iODBC/libiodbc-3.52.4.tar.gz> using the method at the end of the README.MACOSX $ ./configure $ make $ sudo make install and then running this in the DBD-ODBC-1.13 directory perl MakeFile.PL -o /usr/local/ As a squirrel lover and cat owner not averse to goats, I felt it was the only way. JD >>> Anyone have a recipe for building DBD::ODBC? >> [quoted text clipped - 11 lines] > $ make > $ sudo make install You could have skipped that - iODBC is shipped with the OS. > and then running this in the DBD-ODBC-1.13 directory > > perl MakeFile.PL -o /usr/local/ To use the built-in iODBC: perl Makefile.PL -o /usr (or) ODBCHOME=/usr perl Makefile.PL sherm-- Web Hosting by West Virginians, for West Virginians: http://wv-www.net Cocoa programming in Perl: http://camelbones.sourceforge.net > Anyone have a recipe for building DBD::ODBC? I built it yesterday on Solaris 10 without incident. What's the problem you're running into? On Jul 14, 2006, at 7:34 PM, brian d foy wrote: >> Anyone have a recipe for building DBD::ODBC? > > I built it yesterday on Solaris 10 without incident. What's the > problem > you're running into? I've got it building with -o /usr. There are a lot of "signed vs. unsigned pointer mismatch" type warnings - but those are new warnings in GCC 4.x, and I've seen them in a ton of stuff. I don't know if they're relevant. This may be a clue: "Umm, this looks like a unixodbc type of driver manager." It's not - I'm configuring against the built-in iodbc in /usr, not unixodbc. And the tests fail with a dynamic linker "symbol not resolved in dynamic_lookup" error, which could easily be the result of using the wrong API. What I'm aiming for is a binary build I can include with the next CamelBones patch release. Frankly, I don't know a whole lot about ODBC on *nix - which is a big part of the problem, I'm sure. I need to hit the books. sherm-- Web Hosting by West Virginians, for West Virginians: http://wv-www.net Cocoa programming in Perl: http://camelbones.sourceforge.net > I've got it building with -o /usr. There are a lot of "signed vs. > unsigned pointer mismatch" type warnings - but those are new [quoted text clipped - 9 lines] > resolved in dynamic_lookup" error, which could easily be the result > of using the wrong API. Aha! Yes - that was a clue. There's a /usr/lib/libodbc.a that's a symbolic link to /usr/lib/ libiodbc.a. As it happens, DBD::ODBC uses the presence of /usr/lib/ libodbc.a as a sign of unixodbc, and moving the symlink out of harm's way allowed Makefile.PL to correctly detect iodbc instead. The 01base.t test is working now without the unresolved symbol errors. Now I'll have to set up an actual DSN and run a real test against it. sherm-- Web Hosting by West Virginians, for West Virginians: http://wv-www.net Cocoa programming in Perl: http://camelbones.sourceforge.net |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.