AW: connecting to informix via network

From: Meinertzhagen Walter (Walter.Meinertzhagen_at_comverse.com)
Date: 03/16/05 

Date: Wed, 16 Mar 2005 16:23:40 +0200
To: "Jonathan Leffler" <jonathan.leffler@gmail.com>

Hallo Jonathan,

many thanks for your help.
After i posted, I found a nice article in german from Jochen Wiedmann which explains in detail how to setup DBI:Proxy

http://www.heise.de/ix/artikel/2000/10/176/

I am just bulding the modules ...

Bye the way, I am really impressed from Perl and the community.
Thanks to everybody who contributed.

Regards
         
Walter Meinertzhagen
Product Specialist
Comverse Germany GmbH
 

-----Ursprüngliche Nachricht-----
Von: Jonathan Leffler [mailto:jonathan.leffler@gmail.com]
Gesendet: Mittwoch, 16. März 2005 14:06
An: Meinertzhagen Walter
Cc: dbi-users@perl.org; Guardian of DBD::Informix
Betreff: Re: connecting to informix via network

Dear Walter,

On 15 Mar 2005 20:00:38 -0000, PerlDiscuss - Perl Newsgroups and
mailing lists <walter.meinertzhagen@comverse.com> wrote:
> Hi all who help others,
>
> i would like to create a database handle to informix
> database on alpha maschine.
> what do i have:
>
> # uname -a
> OSF1 trm61 V4.0 878 alpha
> # /usr/informix/bin/tbstat -z
>
> RSAM Version 5.08.UD2 -- On-Line -- Up 07:53:56 -- 9968 Kbytes
>
> #
>
> i wrote a perl-script which works fine on the host
> itself, but when i try to connect through the network it doesn®t
> work.
> i really tried out figure that out in cpan and other locations,
> but i was not able to get the right information.
>
> i am running activstate perl version 5.8.0 on windows 2000 sp4.
>
> any ideas ?

This is a fundamental Informix connectivity problem, rather than a
Perl problem per se. There are likely to be a variety of possible
solutions - partially dependent on what have available - on the Alpha
and on the Windows machines.

Option 1: With ClientSDK and DBI + DBD::Informix on the Windows machine.

You can use Informix I-Star on the server - run
$INFORMIXDIR/lib/sqlexecd on the Alpha to listen to database
connections - and then connect to OnLine that way.

Option 2: Run DBI::Proxy server on the Alpha machine, and have it
connect to the database.

The second option is likely the easier for you - I-Star was an extra,
separately purchasable product with OnLine 5.08 (which is (a) not
officially Y2K-compliant and (b) should really be replaced by OnLine
5.20, not least because it includes I-Star). It also avoids the
issues of building DBD::Informix on Windows. 

-- 
Jonathan Leffler <jonathan.leffler@gmail.com>  #include <disclaimer.h>
Guardian of DBD::Informix - v2005.01 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
______________________________________________________________________
  This email message has been scanned by PineApp Mail-Secure and has been found clean.

Relevant Pages