The connection is running and I can collect some data from the DB.
I can test the connection using iSQL and it works fine at the command line.
Code:
$ isql [dsn] [user] [pass] -b << EOF select count(*) from GENESYS_[dsn].TABLE;
$ isql [dsn] [user] [pass] -b << EOF select count(*) from GENESYS_[dsn].TABLE;