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."


Reply via email to