Skip to Content
avatar image
Former Member

Information Design Tool - ODBC connection error

Hello,

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.

/Suman

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jun 08, 2011 at 08:14 AM

    Given that you've published it, have you used the 32-bit version on the Webi server? I suspect this is where the problem lies. The 32 bit version is c:\windows\sysWOW64\odbcad32.exe while the 64-bit driver is at c:\windows\system32\odbcad32.exe.

    Add comment
    10|10000 characters needed characters exceeded

    • Hello,

      If you are on BOE 4.0 then it's 64 bit client install that is needed so install the 64 bit client on the BOE Server and it shoudl connect with out problems. Assuming the Server is 64 bit also or MS supports 64 client to 32 bit Server.

      If that doesn't work I suggest creating a case and work with a Rep to debug the issue.

      Don