http://qs321.pair.com?node_id=123064


in reply to DB connection sharing w/o DBI?

But this is one of those situations where installing a module that's not all perl is BAD.

You mention fork(), which suggests that you might not be in Win32. If you were, you could use either Win32::ODBC or Win32::OLE (to do db access through ADO). Both are part of the standard install (for ActiveState, at least).

Please say more about what environment you're working on, and what type of database you're trying to connect to.

Replies are listed 'Best First'.
(jptxs) Re: DB connection sharing w/o DBI?
by jptxs (Curate) on Nov 03, 2001 at 23:44 UTC
    Sorry about that. Been a while since I posted and I forgot my manners =]

    This would need to work on most *NIX flavors and it would always be connecting to Oracle. Took a stroll through CPAN before posting and seems all the modules to access Oracle involve some binary of some sort...no pure perl that I saw.

    We speak the way we breathe. --Fugazi

[reply]
      To my knowledge there is no pure-Perl implentation of Oracle's network protocols. DBD::Oracle makes use of a locally-installed Oracle client library (which I suspect probably carries licensing issues) to do the actual work.

      You may have some luck getting ODBC to work. I believe there are some freely available ODBC implementations out there, though I don't know if any of those are pure-Perl either.

      You say you've gone through the process of trying to install non-Perl components (I'm assuming modules that are implemented at least partially in C) and have failed. I'm not sure that it's going to be easier for you to find an all-Perl solution this or if you just need to bite the bullet and solve whatever fundamental problem that exists with your system that is making it difficult for you to install C-based Perl modules.

[reply]

In Section Seekers of Perl Wisdom