Well, with some hints from the list and elsewhere, I finally got this
working late yesterday afternoon (Fri) - sorry I didn't re-post then, but
the results were just too fascinating...
But not on my personal m/c (5.8.4 + 2.0.52) where I report in the quote
below. I don't have the Oracle client on that m/c, and IIRC ActiveState's
site said it's not separately available any more. Certainly, I couldn't
find any link on Oracle's site that didn't offer the whole shooting match,
which I felt was Too Much Software. I do have a call in to our official
help-desk, but not at high priority.
My official m/c (combined 5.6.1 + 1.3.27) had come with the 8.1 client
installed, and I finally got the connection to work after installing
DBD::Oracle 1.12 from AS, and changing my source (this is how ignorant I was
last Monday!) $ENV{ORACLE_HOME} from q{/long/complicated/solaris/address} to
q{C:\Oracle\Ora81}, and adding the full host name to the dbh->connect
string. The app had originally been intended only for use on the server
with the actual d-b. I still intend to experiment a little with
ENV{TWO_TASK}, and tidy up the code so it can work both here and on that
server, and also cater both for the remote Oracle, and a local MySQL copy of
it that I intend to make - after I've found how big it is...
Thanks to the list (and Google!) for general nudges and hints rather than
any specific advice, rgds, G.
-----Original Message-----
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 04, 2004 4:17 PM
To: 'Graeme St. Clair'; [EMAIL PROTECTED]
Subject: RE: Windows to Oracle
> ***
>
> The link is fine, once my lamentable ignorance of ppm is mended...
>
> On my 5.8.4 plus 2.0.52 m/c, I ran the two cmds "ppm install ..
> DBI.ppd" and "... DBD-Oracle.ppd", changing 5.8.3 to 5.8.4. The two
> installs each stated they were successful, versions 1.45 and 1.16
> respectively. But on trying to connect, I'm now getting:-
>
> install_driver(Oracle) failed: Can't load
> 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module
> DBD::Oracle: load_file:The specified module could not be found at
> C:/Perl/lib/DynaLoader.pm line 230. at (eval 6) line
> 3 Compilation failed in require at (eval 6) line 3. Perhaps a required
> shared library or dll isn't installed where expected at
> C:/Apache2/cgi-bin/xxx/yyy.pl line 321
>
> File seems to be where it's supposed to be (I did re-boot first just
> to be
> paranoid):-
Do you have the Oracle client installed and does SQL*Plus work?
Thanks,
Jeff
