Try User DSN
i have already tried User DSN but it notify "DSN contains an architecture mismatch between the Driver and Application"
1 person found this helpful
This is likely a 64bit vs 32bit issue. Your BI Server ODBC is 64bit and therefore is not available with 32bit Office. Looks like you will need the 32bit OBIEE Client tools.