Here's just a quick thought:
DBI connects to remote machines are expecting a port as argument too, which
i'm not seeing in your statement.
Furthermore, if the params to DBI connect are interpolated, you might want
to check the contents of connect as well.
You can read up on more DBI stuff at
http://search.cpan.org/doc/ADESC/DBI-FAQ-0.38/FAQ.pm
and
http://search.cpan.org/doc/TIMB/DBI-1.15/DBI.pm
Regards,
Jos Boumans
----- Original Message -----
From: "John Peterson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 15, 2001 1:18 AM
Subject: DBI connecting to Informix DB
> I've got a Perl script using DBI to connect to an Informix database on
> another server. These servers are identical as far as where Informix is,
> etc.
>
> My script works fine when I run it locally, but when I try to connect
> remotely I get the following error.
>
> DBI->connect failed: SQL: -25555: Server myserver is not listed as a
> dbserver.
> at ia10.pl line 27
>
> I'm setting the enviornment variables like this:
>
> $ENV{"INFORMIXDIR"} = '/usr/informix';
> $ENV{"ONCONFIG"} = 'onconfig.databasename';
> $ENV{"INFORMIXSERVER"} = 'databasenametcp';
> $ENV{"IFORMIXSQLHOSTS"} = '/apphome/system/usr/sqlhosts';
>
> my $dbh = DBI->connect( 'dbi:Informix:mydb@myserver', 'joeuser',
> 'thepassword' )
> or die "Couldn't connect to database: " . DBI->errstr;
>
> Can anyone help or point me in the right direction of a good article?
>
> Thanks,
>
> John Peterson
> Gentner Communications Corporation
> 801.974.3693
> [EMAIL PROTECTED]
> "Perfect Communication through Technology, Service and Education."
>
>
>
