ODBC error when running query on WEBI XI R2

[Former Member]

Hi all,

I have a newly installed XIR2 on Win 2003 (32-bit), I created a simple Universe pointing to MSSQL 2005. I encountered the error below when running a query from WEBI:

Database Error: [Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified. Error: WIS 10901

Any ideas? Thanks!

Cheers,

Arms

[amrsalem1983 · Accepted solution]

its clear that the connection for this universe is not working good

import this universe to the designer and find the parameter window from

File-> Parameters.

in the connection settings click edit, or test, and fix the connection then re-export the universe again.

good luck

Amr

[Former Member · Accepted solution]

Hi Amr,

I have done this and the universe connection actually works. In fact (sorry I failed to mention this in the previous post), the same universe works fine when I used it in Desktop Intelligence ..

Cheers,

Arms

[Former Member · Accepted solution]

Hi Armstrong,

If you are using an ODBC connection, make sure the connection is defined exactly the same on the server as it defined on your computer... With SQL you can try to create an OLE DB connection, then when you export the universe, the connection will still work... ODBC connections need to be created on all machines if you plan to use the desktop tools.

Hope this helps

Jacques

[Former Member · Accepted solution]

I agree with Jaq...additionally check to see the connection name on the BO server is with the same name as on local m/c.

gud luck,

Sam