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..
DSN issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: