Skip to Content
author's profile photo
Former Member

WIS: 10901 Data source name not found and no default driver specified(ODBC)

Hi, gurus.

We've created a universe based on Excel spredsheet or MS Access which is using ODBC connection. Then, I try to create query (which is using these universe) in QAAWS or in InfoView, and when I add a filter object to the query, the error occurs:

"GetDatasourceObject LOV exception (error WIS: 10901)".

If I don't choose any filter options and want to create query, I'm getting the error: ' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (error WIS: 10901)'.

We tried to do this in different operations systems - Windows 7 (32 bit) and XP (32 bit).

Anymore, we can use this universes at web intelligence rich client with or without filters.

Need to solve this problem. Please help us.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Mar 16, 2011 at 12:07 PM

    In order to use this in the InfoView you have to define the ODBC DSN also on the machine where your BO Server is installed on. Use the same name for the DSN as the one on your local machine. Make sure to use the 32bit ODBC administrator utility (odbcad32.exe) if your BO server runs on 64bit WIndows

    Regards,

    Stratos

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Client Tools uses 32 bit driver but server uses 64 bit driver.

      I am trying to solve this issue too.

      I am using Bo 4.0 Sp2 Patch8 on Windows Server 2008 Enterprise R2 64bit

      Database Sybase ASE 15.

      I installed both 32 bit and 64 bit OLEDB drivers to server.

      Added server name etc by "dsedit".

      Client tools works but Web Intelligence Application and Explorer gives the error IES 10901 WIS 10901

      Some help will be great!

      Thanks.

  • author's profile photo
    Former Member
    Posted on Mar 16, 2011 at 12:51 PM

    Thank you. This solve issue.

    Add comment
    10|10000 characters needed characters exceeded