[Canberra-pm] Still struggling with DBD-Pg on Win32

[Donovan J. Edye]

G'Day,

I am an extreme PERL newbie.  In order to get http://www.sql-ledger.org/
going I need to have a Postgres driver installed. I downloaded Active State
Perl and installed that and installed DBI with ppm. I downloaded a binary
Win32 Pg-DBD from http://www.edmund-mergl.de/export/DBD-Pg.zip However the
instructions to install the DBD-Pg from the above zip is "ppm install
--location=. DBD-Pg" once it has been unpacked. However the -location
appears to be an invalid command line option for ActiveState under Win32. It
was recommended that I unpack the zip using the tree structure it contains
as that should be all that is required. I did so as follows: (Blib was the
root directory in the zip and it seemed sane to place it at the same level
as C:\Perl\Lib)

C:\PERL\BLIB
+---arch
|   \---auto
|       \---DBD
|           \---Pg
|                   .exists
|                   Pg.bs
|                   Pg.dll
|                   Pg.exp
|                   Pg.lib
|                   
\---lib
    +---auto
    |   \---DBD
    |       \---Pg
    |               .exists
    |               
    \---DBD
            .exists
            dbd-pg.pod
            Pg.pm

However I still get an error in the SQL-Ledger admin.pl script of "No
database drivers available". Upon investigation it appears that:

sub dbdrivers {

  my @drivers = DBI->available_drivers();
  print @drivers;

  return (grep { /(Pg|Oracle)/ } @drivers);

}

in User.pm fails. If I write a script as follows:


#!c:\perl\bin\perl

  eval { require DBI; };
  print " DBI->available_drivers() reports\n";
  
  my @drivers = DBI->available_drivers();
  print @drivers;

then I get:

C:\Perl\bin>perl donovan.pl
DBI->available_drivers() reports
ExamplePProxy

A grep search of all the files on my disk and a search of the registry does
not reveal a string of "ExamplePProxy" Can anyone help me out here? How do I
get DBD-Pg going here. All help, suggestions etc. appreciated. I will run
any diagnostic scripts sent to help solve this problem.

TIA

--Donovan
Web: http://www.edye.wattle.id.au 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 5024 bytes
Desc: not available
Url : http://mail.pm.org/pipermail/canberra-pm/attachments/20030221/2f63b8eb/winmail.bin