[islamabadi]

My system admin has just installed Informix module that I am trying to connect to through Perl via Unix. Please keep in mind that I have been successful in connecting via ODBC and run the queries.

Here is my code:

#! /usr/bin/perl

use DBI;
$dbh = DBI->connect('dbi:Informix:testdb@testserver','user',' password'
,{ AutoCommit => 0, PrintError => 1 });
$dbh->disconnect;

I get the following error:

DBI connect('db_dg@gsmdg1.cig.mot.com','omcadmin',...) failed: SQL: -1829: <<Failed to locate SQL error message>

Can someone tell me what I or the system admin need to do to get this going. I saw some reference to INFORMIXDIR, INFORMIXSERVER, etc to be set. Where do these env need to be set? USer running the Perl script??

Also, a document references sqlhosts file. Where is this other than the Informix server itself, which is there and is functional.

What is different in UNIX world that I can't figure out? Help!

[DoomDog]

try adding in your perl script before your DBI connect statement:

# Set Informix DB environment variables.
$ENV{INFORMIXDIR} = '/informix930';
$ENV{INFORMIXSERVER} = 'ak0779_gcdb';
$ENV{PATH} = '/informix930/bin:/bin:/usr/bin';

of course your specific paths and server name will most likely be different!

hope that it helps!

[islamabadi]

$ENV{INFORMIXDIR} = '/informix930';
$ENV{INFORMIXSERVER} = 'ak0779_gcdb';
$ENV{PATH} = '/informix930/bin:/bin:/usr/bin';

Is this information on the server that I am connecting to. For example, is the INFORMIXDIR the INFORMIXDIR that I have on the connecting server?

[DoomDog]

It is the information for the machine you are trying to connect from, i.e., the one you are trying to run perl on.

[Emmon]

Hi

I'm not sure which ODBC driver you're using here to connect but you'll find a step by step walkthrough on getting an ODBC connection with Perl including a script to return records at www.iodbc.org

HTH
Emmon