Informix to Postgresql via DBI-Link

From: Pedro Ferro <pedro(dot)ferro(at)gmail(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Informix to Postgresql via DBI-Link
Date: 2013-02-28 15:25:22
Message-ID: CAAp6FGM9=QPo9TypT3pdr=TedxMxMvvCdcTo+5QwVy=5RmahFg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hi,

My main goal is to do a "select"
in the Informix DB and be able to import that information directly
into the DBPostgreSQL / PostGIS, from
what I understand DBI-Link is the right tool for this.
However I have a major problem and I can not install DBI-Link in Postgresql.

I have a machine with OS Windows 64-bit . (I can not change that).

As I understand I need to install first Active Perl on my machine, which I
have done.
However when I create a new extension (plperlu) in Postgresql gives me an
error like: "can not load library: c: \ Program Files \ PostgreSQL \ 9.2 \
lib \ plperl.dll."
I verified that the file plperl.dll exists in that exact location .

As I investigated the problem could be related to the version of Active
Perl installed and recommend installing version 5.10, which I did. However
just found the version for 32 bits.
(ActivePerl-5.10.1.1008-MSWin32-x86-294165.msi -
advanced-shorturl-perl-pidgin - ActivePerl 5.10 - Advanced Shorturl in Perl
for Pidgin - Google Project
Hosting<http://code.google.com/p/advanced-shorturl-perl-pidgin/downloads/detail?name=ActivePerl-5.10.1.1008-MSWin32-x86-294165.msi>
)

1 - It seems to you that the indicated error may have to do with be using
the 32-bit version of Active Perl?

1.1 - If so, does anyone know where I can get the version of Active Perl
5.10 64 bits?

I don't have many computer skills so I can be doing a basic error that is
preventing the installation of the DBI-Link in Postgresql even
when following your tutorials

I would appreciate your help because I'm stuck for several days with this
problem and do not know how to solve it ...

Regards,
Pedro

Browse pgsql-interfaces by date

  From Date Subject
Next Message dhaval257 2013-03-04 09:00:20 PostgreSQL connect with Visual C++
Previous Message Tom Lane 2013-02-25 11:13:24 Re: PQconnectdbParams returns exit value 01 (from gdb).