DSN issue
Posted: Sun Jun 03, 2012 4:03 am
Hi Frineds,
I am facing issue while trying to connect SQL server 2008 R2 64 bit database from DataStage 8.5 on window 2008 64 bit server using System DSN.
Issue:
J_BASE_PS_COMBO_SEL_05..DRS_PS_S_COMBO_SEL_05: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and ApplicationJ_BASE_PS_COMBO_SEL_05..DRS_PS_S_COMBO_SEL_05: Unable to connect to database server 'PSEPM'.
J_BASE_PS_COMBO_SEL_05..DRS_PS_S_COMBO_SEL_05.DSLink1: DSP.Open GCI $DSP.Open error -100.
Could any one suggest me on this.
Thanks in advance..
I am facing issue while trying to connect SQL server 2008 R2 64 bit database from DataStage 8.5 on window 2008 64 bit server using System DSN.
Issue:
J_BASE_PS_COMBO_SEL_05..DRS_PS_S_COMBO_SEL_05: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and ApplicationJ_BASE_PS_COMBO_SEL_05..DRS_PS_S_COMBO_SEL_05: Unable to connect to database server 'PSEPM'.
J_BASE_PS_COMBO_SEL_05..DRS_PS_S_COMBO_SEL_05.DSLink1: DSP.Open GCI $DSP.Open error -100.
Could any one suggest me on this.
Thanks in advance..