Setup ODBC Connection for DataStage to Access on Windows Server

To Access any database from DataStage you will need a ODBC connection.


To Create a ODBC Connection in Windows Server 2008 R2 , follow the below steps.

For 32 Bit OS :

• 
  
• Navigate to Folder - C:\Windows\System32
• Double Click odbcad32.exe
• ODBC Administrator window opens
• Click System DSN Tab
• Click Add
• Then Follow Steps , when done click Finish

For 64 bit OS:

• Navigate to Folder - C:\Windows\SysWOW64
• Double Click odbcad32.exe ( Yes , its odbcad32.exe - its not a typo )
• ODBC Administrator window opens
• Click System DSN Tab
• Click Add
• Then Follow Steps , when done click Finish