Error in connecting to Informix

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Error in connecting to Informix

Post by admin »

....Pls. help

I have created Informix DSN and connection test was successful.
Now while importing table definitions in Datastage7.0 from the Informix
DB I get following error message :

DSR.MetaGeta(GET.TABLES)(SQLConnect('InformixDSN2','gcdbusr2')): BCI
Error:
SQLSTATE=IM009,CODE=-11048,[DataStage][SQL
Client][ODBC][Informix][Informix ODBC

Please let me know what is to be done.

I have just started using datasatage with experience level of hardly a
week in it.

--
Thanks & Regards
Samir V Chaudhari
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Error in connecting to Informix

Post by admin »

the complete error message is

DSR.MetaGeta(GET.TABLES)(SQLConnect('InformixDSN2','gcdbusr2')): BCI
Error:
SQLSTATE=IM009,CODE=-11048,[DataStage][SQL
Client][ODBC][Informix][Informix ODBC Driver]Unable to load translation
DLL.


Samir Chaudhari wrote:

> ...Pls. help
>
> I have created Informix DSN and connection test was successful.
> Now while importing table definitions in Datastage7.0 from the Informix
> DB I get following error message :
>
> DSR.MetaGeta(GET.TABLES)(SQLConnect('InformixDSN2','gcdbusr2')): BCI
> Error:
> SQLSTATE=IM009,CODE=-11048,[DataStage][SQL
> Client][ODBC][Informix][Informix ODBC
>
> Please let me know what is to be done.
>
> I have just started using datasatage with experience level of hardly a
> week in it.
>
> --
> Thanks & Regards
> Samir V Chaudhari

--
Thanks & Regards
Samir V Chaudhari
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Error in connecting to Informix

Post by admin »

Hi,

on which platform are you running DataStage ? This error is normally
generated when one of your environment variables is not set correctly.

Simon

----- Original Message -----
From: "Samir Chaudhari"
To:
Sent: Tuesday, October 21, 2003 9:14 AM
Subject: Re: Error in connecting to Informix


> the complete error message is
>
> DSR.MetaGeta(GET.TABLES)(SQLConnect('InformixDSN2','gcdbusr2')): BCI
> Error:
> SQLSTATE=IM009,CODE=-11048,[DataStage][SQL
> Client][ODBC][Informix][Informix ODBC Driver]Unable to load translation
> DLL.
>
>
> Samir Chaudhari wrote:
>
> > ...Pls. help
> >
> > I have created Informix DSN and connection test was successful.
> > Now while importing table definitions in Datastage7.0 from the Informix
> > DB I get following error message :
> >
> > DSR.MetaGeta(GET.TABLES)(SQLConnect('InformixDSN2','gcdbusr2')): BCI
> > Error:
> > SQLSTATE=IM009,CODE=-11048,[DataStage][SQL
> > Client][ODBC][Informix][Informix ODBC
> >
> > Please let me know what is to be done.
> >
> > I have just started using datasatage with experience level of hardly a
> > week in it.
> >
> > --
> > Thanks & Regards
> > Samir V Chaudhari
>
> --
> Thanks & Regards
> Samir V Chaudhari
>
>
>
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Error in connecting to Informix

Post by admin »

Datastage is on Windows 2000 -SP4
Informix Database is on UNIX (Informix Dynamic Server v9.3 on HP-UX 11i)

--Samir

Simon Fryett wrote:

> Hi,
>
> on which platform are you running DataStage ? This error is normally
> generated when one of your environment variables is not set correctly.
>
> Simon
>
> ----- Original Message -----
> From: "Samir Chaudhari"
> To:
> Sent: Tuesday, October 21, 2003 9:14 AM
> Subject: Re: Error in connecting to Informix
>
> > the complete error message is
> >
> > DSR.MetaGeta(GET.TABLES)(SQLConnect('InformixDSN2','gcdbusr2')): BCI
> > Error:
> > SQLSTATE=IM009,CODE=-11048,[DataStage][SQL
> > Client][ODBC][Informix][Informix ODBC Driver]Unable to load translation
> > DLL.
> >
> >
> > Samir Chaudhari wrote:
> >
> > > ...Pls. help
> > >
> > > I have created Informix DSN and connection test was successful.
> > > Now while importing table definitions in Datastage7.0 from the Informix
> > > DB I get following error message :
> > >
> > > DSR.MetaGeta(GET.TABLES)(SQLConnect('InformixDSN2','gcdbusr2')): BCI
> > > Error:
> > > SQLSTATE=IM009,CODE=-11048,[DataStage][SQL
> > > Client][ODBC][Informix][Informix ODBC
> > >
> > > Please let me know what is to be done.
> > >
> > > I have just started using datasatage with experience level of hardly a
> > > week in it.
> > >
> > > --
> > > Thanks & Regards
> > > Samir V Chaudhari
> >
> > --
> > Thanks & Regards
> > Samir V Chaudhari
> >
> >
> >

--
Thanks & Regards
Samir V Chaudhari
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Error in connecting to Informix

Post by admin »

Sometimes you need to ensure that the informix bin is included in the system
PATH. You also need to ensure that the INFORMIXDIR env variable is set
correctly too.

Simon

----- Original Message -----
From: "Samir Chaudhari"
To:
Sent: Tuesday, October 21, 2003 9:38 AM
Subject: Re: Error in connecting to Informix


>
> Datastage is on Windows 2000 -SP4
> Informix Database is on UNIX (Informix Dynamic Server v9.3 on HP-UX 11i)
>
> --Samir
>
> Simon Fryett wrote:
>
> > Hi,
> >
> > on which platform are you running DataStage ? This error is normally
> > generated when one of your environment variables is not set correctly.
> >
> > Simon
> >
> > ----- Original Message -----
> > From: "Samir Chaudhari"
> > To:
> > Sent: Tuesday, October 21, 2003 9:14 AM
> > Subject: Re: Error in connecting to Informix
> >
> > > the complete error message is
> > >
> > > DSR.MetaGeta(GET.TABLES)(SQLConnect('InformixDSN2','gcdbusr2')): BCI
> > > Error:
> > > SQLSTATE=IM009,CODE=-11048,[DataStage][SQL
> > > Client][ODBC][Informix][Informix ODBC Driver]Unable to load
translation
> > > DLL.
> > >
> > >
> > > Samir Chaudhari wrote:
> > >
> > > > ...Pls. help
> > > >
> > > > I have created Informix DSN and connection test was successful.
> > > > Now while importing table definitions in Datastage7.0 from the
Informix
> > > > DB I get following error message :
> > > >
> > > > DSR.MetaGeta(GET.TABLES)(SQLConnect('InformixDSN2','gcdbusr2')): BCI
> > > > Error:
> > > > SQLSTATE=IM009,CODE=-11048,[DataStage][SQL
> > > > Client][ODBC][Informix][Informix ODBC
> > > >
> > > > Please let me know what is to be done.
> > > >
> > > > I have just started using datasatage with experience level of
hardly a
> > > > week in it.
> > > >
> > > > --
> > > > Thanks & Regards
> > > > Samir V Chaudhari
> > >
> > > --
> > > Thanks & Regards
> > > Samir V Chaudhari
> > >
> > >
> > >
>
> --
> Thanks & Regards
> Samir V Chaudhari
>
>
>
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Locked