Windows to Oracle

From: Graeme St. Clair (Graeme.St.Clair_at_hds.com)
Date: 11/29/04 

To: dbi-users@perl.org
Date: Sun, 28 Nov 2004 18:11:37 -0800

Newbie, I'm afraid. Context XP Pro, perl.apache.org's material. All works
quite nicely talking to a skeleton MySQL d-b on the same m/c (and for that
matter another XP m/c on my home LAN). Now I need to test my changes
against a real (and remote) Oracle d-b - the original code connected to
Oracle quite happily. I used Control Panel > Administrative Tools > Data
Sources (ODBC) to activate (if that's the word) "Microsoft ODBC for Oracle".
 
Then on my first connection, I got "install_driver(Oracle) failed: Can't
locate loadable object for module DBD::Oracle in @INC (@INC contains:
C:/Program Files/PERL_Apache/Perl/lib C:/Program
Files/PERL_Apache/Perl/site/lib .) at (eval 6) line 3 Compilation failed in
require at (eval 6) line 3. Perhaps the DBD::Oracle perl module hasn't been
fully installed or perhaps the capitalisation of 'Oracle' isn't right.
Available drivers: CSV, ExampleP, File ODBC, Proxy, SQLite, Mysql.".

So I went to CPAN for Oracle.pm 1.16, and put it in
...Perl/site/lib/DBD/Oracle.pm. Then I got "install_driver(Oracle) failed:
Can't locate loadable object for module DBD::Oracle in @INC (@INC contains:
C:/Program Files/PERL_Apache/Perl/lib C:/Program
Files/PERL_Apache/Perl/site/lib .) at (eval 6) line 3 Compilation failed in
require at (eval 6) line 3. Perhaps a module that DBD::Oracle requires
hasn't been fully installed".

So I suppose I must be doing something right. After inspecting Oracle.pm, I
obtained DynaLoader.pm and Exporter.pm, and put them in
...Perl/site/lib/*.pm. But I'm still getting the second of the above msgs.
I'm guessing I need a few more odds and ends, but it would be nice if the
msg would have told me what they were...
 
What more do I need, and how can I debug this sort of thing if it happens
again?
 
Rgds, GStC.
 

Relevant Pages

  • Re: Whats so bad about ODBC
    ... It is far better to connect to Oracle using the native connectivity. ... What exactly might be a problem with ODBC? ... data to be fetched to the client, and have it filtered on the client. ... actual execution paths are often unpredictable, ...
    (comp.databases.oracle.server)
  • RE: Windows to Oracle
    ... resolved yet (with respect to a Windows OS). ... and Oracle DBDs. ... Need to install Oracle on your own machine before you can connect to the ... If you are truly trying to use ODBC, why are you specifying the Oracle ...
    (perl.dbi.users)
  • Re: Probleme unter Access beim Zugriff auf Oracle-Daten
    ... Der Zugriff erfolgt via ODBC mit dem Microsoft Treiber. ... Hier wird allerdings nicht wirklich etwas Bewegendes gemacht: mit Access-backend verkünpfte Tabellen, mit via ODBC eingebundene Oracle Tabellen und eine PT-Abfrage. ... Schema: Es gibt zwei Schemata, welche vom Aufbau absolut identisch sind. ...
    (microsoft.public.de.access.clientserver)
  • Re: MSACCESS hangs
    ... Client -- Windows XP, MS Access 2003 using Oracle's ODBC driver ... I would try to isolate whether it is the query or ODBC. ... Senior Oracle Dba ... other thoughts are windows patches may have been installed, ...
    (comp.databases.oracle.server)
  • Re: MS OLE DB for ODBC with Oracle ODBC source headaches
    ... John Bell wrote: ... the Oracle OLEDB provider (as opposed to the Microsoft OLE for ODBC ... >> I have no idea why sometimes I can connect to the linked server with no ...
    (comp.databases.ms-sqlserver)