Hi. Help me, please with Pg for Windows:

1. WinXP SP2
2. Perl:

This is perl, v5.8.8 built for MSWin32-x86-multi-thread
(with 33 registered patches, see perl -V for more detail)

Copyright 1987-2006, Larry Wall

Binary build 819 [267479] provided by ActiveState http://www.ActiveState.com
Built Aug 29 2006 12:42:41

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl".  If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.

3. PostgreSQL:

postgres (PostgreSQL) 8.2.1

4. Pg install as:

ppm install http://dbdpgppm.projects.postgresql.org/DBD-Pg-5.8s.ppd

5. ppm list is:

C:\>ppm list
┌──────────────────────────┬────────────┬───────┬──────────┬──────┐
│ name                     │ version    │ files │ size  
   │ area │
├──────────────────────────┼────────────┼───────┼──────────┼──────┤
│ ActivePerl-Config        │ 1.0        │     2 │    11 
KB │ perl │
│ ActivePerl-DocTools      │ 2.0        │    13 │    63 
KB │ perl │
│ ActivePerl-PPM           │ 4.0        │    63 │   545 
KB │ perl │
│ ActiveState-RelocateTree │ 1.3        │     4 │    29 
KB │ perl │
│ ActiveState-Scineplex    │ 1.0        │     6 │    77 
KB │ perl │
│ ActiveState-Utils        │ 2.1        │    21 │   106 
KB │ perl │
│ Archive-Tar              │ 1.30-r1    │     8 │    82 
KB │ perl │
│ Archive-Zip              │ 1.16       │    10 │   154 
KB │ perl │
│ Compress-Zlib            │ 1.42       │     7 │   121 
KB │ perl │
│ DBD-Pg                   │ 1.49       │    10 │  1958 
KB │ site │
│ DBD-PgPP                 │ 0.05       │     5 │    61 
KB │ site │
│ DBD-SQLite               │ 1.12       │     6 │   288 
KB │ perl │
│ DBD-mysql                │ 3.0002     │    15 │  1296 
KB │ site │
│ DBI                      │ 1.52       │    44 │  1179 
KB │ perl │
│ Data-Dump                │ 1.06       │     2 │    14 
KB │ perl │
│ Digest-HMAC              │ 1.01       │     4 │     5 
KB │ perl │
│ Digest-MD2               │ 2.03       │     6 │    29 
KB │ perl │
│ Digest-MD4               │ 1.5-r1     │     6 │    38 
KB │ perl │
│ Digest-SHA1              │ 2.11       │     6 │    38 
KB │ perl │
│ File-CounterFile         │ 1.04       │     2 │     6 
KB │ perl │
│ Font-AFM                 │ 1.19       │    14 │    38 
KB │ perl │
│ GD                       │ 2.35       │    20 │  1181 
KB │ site │
│ HTML-Parser              │ 3.55       │    12 │   129 
KB │ perl │
│ HTML-Tagset              │ 3.10       │     2 │    13 
KB │ perl │
│ HTML-Tree                │ 3.20       │    10 │   314 
KB │ perl │
│ IO-String                │ 1.08       │     2 │    12 
KB │ perl │
│ IO-Zlib                  │ 1.04       │     2 │    16 
KB │ perl │
│ LWP                      │ 5.805-r1   │    69 │   657 
KB │ perl │
│ MD5                      │ 2.03       │     2 │     1 
KB │ perl │
│ MIME-Base64-Scripts      │ 1.00       │     9 │     3 
KB │ perl │
│ Math-BigInt-FastCalc     │ 0.10       │     6 │    31 
KB │ perl │
│ Perl                     │ 5.8.8.819  │  1529 │ 24138 
KB │ perl │
│ SOAP-Lite                │ 0.55-r1    │    29 │   332 
KB │ perl │
│ Tcl                      │ 0.89-r2    │     8 │  2371 
KB │ perl │
│ Term-ReadKey             │ 2.30       │     7 │    48 
KB │ perl │
│ Term-ReadLine-Perl       │ 1.0302-r1  │     3 │   139 
KB │ perl │
│ Text-Autoformat          │ 1.13       │     2 │    43 
KB │ perl │
│ Text-Reform              │ 1.11       │     7 │    60 
KB │ perl │
│ Tk                       │ 804.027-r6 │   693 │  5988 
KB │ perl │
│ Tkx                      │ 1.04       │     9 │    68 
KB │ perl │
│ URI                      │ 1.35       │    50 │   116 
KB │ perl │
│ Unicode-String           │ 2.09       │     7 │   601 
KB │ perl │
│ Win32-AuthenticateUser   │ 0.02       │     7 │    26 
KB │ perl │
│ XML-Parser               │ 2.34-r1    │    32 │   483 
KB │ perl │
│ XML-Simple               │ 2.14       │     3 │   111 
KB │ perl │
│ libwin32                 │ 0.26-r3    │   154 │  2180 
KB │ perl │
└──────────────────────────┴────────────┴───────┴──────────┴──────┘
 (46 packages installed)

6. DBI drivers is:

install_driver(CX) failed: Can't locate DBD/CX.pm in @INC (@INC contains: 
D:/USR/site/lib D:/USR/lib .) at (eval 5) line 3.
Perhaps the DBD::CX perl module hasn't been fully installed,
or perhaps the capitalisation of 'CX' isn't right.
Available drivers: DBM, ExampleP, File, Pg, PgPP, Proxy, SQLite, Sponge, mysql.

=================

SO, when I start testing script, I see next:

Software error:
install_driver(Pg) failed: Can't load 'D:/USR/site/lib/auto/DBD/Pg/Pg.dll' for 
module DBD::Pg: load_file:Не найден указанный модуль at 
D:/USR/lib/DynaLoader.pm line 230.
 at (eval 5) line 3
Compilation failed in require at (eval 5) line 3.
Perhaps a required shared library or dll isn't installed where expected

But file "D:/USR/site/lib/auto/DBD/Pg/Pg.dll" EXIST:

D:\USR\site\lib\auto\DBD\Pg>dir
 Том в устройстве D имеет метку DATA
 Серийный номер тома: 4CEF-E6FC

 Содержимое папки D:\USR\site\lib\auto\DBD\Pg

16.02.2008  12:39    <DIR>          .
16.02.2008  12:39    <DIR>          ..
16.02.2008  12:39               324 .packlist
16.02.2008  12:39         1 036 288 libeay32.dll
16.02.2008  12:39                 0 Pg.bs
16.02.2008  12:39           159 744 Pg.dll
16.02.2008  12:39               752 Pg.exp
16.02.2008  12:39             1 854 Pg.lib
16.02.2008  12:39           371 712 Pg.pdb
16.02.2008  12:39           196 608 ssleay32.dll
               8 файлов      1 767 282 байт
               2 папок  19 979 456 512 байт свободно

What can I do to work with PostgreSQL via Perl? DBD:PgPP have so much errors!
Now I use MySQL - no problems! But I want use PostgreSQL, as I use at my work 
(with FreeBSD).

Help me with this bugs, pls.!

Thank's and regardes,
Serge Khomitsky

Reply via email to