peculiar problem when running job

vijaykumar · Post by **vijaykumar** » Mon Dec 18, 2006 1:12 am

Hi gurus,
iam using odbc stage as source.
odbc--->transformer---->odbc.
i have created parameters for odbc connection, user name and password in administrator.
i called them through designer and used in the source stage,
i can view the data from source stage.i can compile the job without errors but when i run the job iam getting error.
went to director, iam getting
drs13..Transformer_2: |drs13..ODBC_0: DSD.BCIConnect Failed to map LOGON2. LOGON2: ??, NLS map: MS1252|
iam not able to analyze error.
i checked with the parameters, they are correct since i can view the data from source stage.
plz help me.

cheers;
vijay

ray.wurlod · Post by **ray.wurlod** » Mon Dec 18, 2006 2:29 pm

Then maybe your problem is in the other ODBC stage (or DRS using ODBC protocol)?

kdsuser · Post by **kdsuser** » Wed Oct 12, 2011 1:05 pm

We are getting the exact same error. It is happing on the link coming out of a database read.

"DSD.BCIConect Failed to map LOGON2. LOGON2: ???, NLS map: MS1252"

The strange thing is, it does not always happen. The job runs throughout the day and it only intermittently gets this warning.

ray, I know this is an old post, but if you are still out there... did you find a solution to this?

This job is using datastage 7.5.