Information Design Tool - ODBC connection error
I am getting the following message when I try to use an Universe to create a WebI report or in Dashboard Design.
Database error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application. (IES 10901) (WIS 10901)
What I did?
1. I created a ODBC connection on a MS SQL 2008 database in 32 bit ODBC source Adminsitrator.
2. I created connection in IDT based on that ODBC connection and then Created Data foundation and Business Layer on that connection. I also published it onto the Enterprise.
3. I tested the universe and also got values in IDT using query.
4. I wanted to create WebI report based on that universe and then I get the above error message.
I am very thankfull to any input.