Re: Re: Oracle and Perl

Okay .. further development.

They have now installed DBD::ODBC. Using a DSN (LWCWeb which does connect to Oracle and work from there), I did the following:

my $dbh = DBI->connect('dbi:ODBC:LWCWeb', $user, $pass);
[download]

Which returns:

DBI->connect(LWCWeb) failed: Specified driver could not be loaded due 
+to system error  5 (Oracle73 Ver 2.5).
[download]

Does this seem to be close to what the last error message said? That the driver (I am assuming the DBD module, though I may be wrong) could not be loaded?

Is this an installation (of Perl, Modules or otherwise) problem do you think?

Thanks for any help ..

--
notsoevil
--
Jeremiah 49:32 - And their camels shall be a booty. . .

Comment on Re: Re: Oracle and Perl Select or Download Code

Replies are listed 'Best First'.
(tye)Re: Oracle and Perl by tye (Sage) on Mar 29, 2001 at 01:04 UTC
`C:\> net helpmsg 5 Access is denied. C:\>` [download] Yep, same error. - tye (but my friends call me "Tye")	[reply] [d/l]
Re: (tye)Re: Oracle and Perl by notsoevil (Pilgrim) on Mar 29, 2001 at 01:08 UTC
Any suggestions as to what I should ask (tell!) them to do about it? -- notsoevil -- Jeremiah 49:32 - And their camels shall be a booty. . .	[reply]
(tye)Re2: Oracle and Perl by tye (Sage) on Mar 29, 2001 at 01:18 UTC
Go to http://www.sysinternals.com/ and grab a file system monitor and see if you can tell if there is some file that can't be accessed. Use User Manager to turn on accounting for failed object access attempts and look in the event log to see what object can't be accessed. Another possibility is that the DllMain code that gets run to initialize the dll when it is loaded is the cause of the error. Check the documentation for your database driver for hints. If you are up to it, then you could modify win32.c and rebuild perl to allow you to load a dll without DllMain getting run and see if the behavior changes (or you could just roll your own dll loader to test this). - tye (but my friends call me "Tye")	[reply]


more useful options
	PerlMonks