Webi Rich client connection problem with OLE DB

building reports webintelligence
1

Environment: SQL Server 2000, Webi Rich client 12.4.0 built 966

I have a weird problem with a database connection through OLE DB. I have one connection that is used in 2 universes, say universe A and B. From my own system (webi 12.3.0) I can connect without problems with both universes and get data.
On other systems (webi 12.4.0) I can connect and get data through universe A but not with universe B. Because they use the same connection is seems very weird.

The error I am getting is:

Database error: [Microsoft OLE DB Provider for SQL Server] : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.(Error: WIS 10901)

Other info: DeskI works without problems, I can view the SQL code in Webi so the universe can be reached.

Input appreciated!

HenkK

HenkK :netherlands: (BOB member since 2004-03-02)

2

Does universe B use any tables that use Linked Server based tables or similar further links?

3

Thanks for the response!

Both universes just use tables from the same database. No linked servers, no linked universes. :roll_eyes:

HenkK

HenkK :netherlands: (BOB member since 2004-03-02)

4

OK, next thing to check. Do you call any functions?

5

Well, I use SQL Server functions in some objects. But the same problem persists when I create a new report with the universe with a single (simple) object in it … :reallymad:

HenkK

HenkK :netherlands: (BOB member since 2004-03-02)

6

It could be an issue with different pieces of kit on different versions of BO then.