DSN issue

sreddy666 · Post by **sreddy666** » 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..

sreddy666 · Post by **sreddy666** » Sun Jun 03, 2012 5:41 am

Issue got resolved..

created 32-bit odbc dsn name and it worked out..

ray.wurlod · Post by **ray.wurlod** » Sun Jun 03, 2012 12:31 pm

Presumably you used the odbcad32.exe in SYSWOW64 folder.