Hi all,
I am trying to create some reports and when I reun the query an error pops out “Database error: [DataDirect][ODBC lib] Data source name not found and no default driver specified. Contact your Business Objects administrator or database supplier for more information. (Error: WIS 10901)”.
What actons do I need to take to eliminate this error? Any ideas please!
Regards.
Aussie2582 (BOB member since 2008-04-16)
Hi,
Check whether the connection used in the universe that you use for your report has been properly configured on the BO server.
Marek Chladny 
(BOB member since 2003-11-27)
The connection in the universe works fine if I use DeskI. I am only having this issue if I try to use WebI.
Is it still a connection issue?
Aussie2582 (BOB member since 2008-04-16)
Yes, it may be because when you use Deski then the report connects to the database using the middleware configures in your PC/laptop while when you run the report in Webi then the middleware in the BO server is used.
So you need to configure the same connection/middleware as you have in your PC also in the BO server.
Marek Chladny (BOB member since 2003-11-27)
What you are saying is that, I need to add the universe connection name as mentioned in the designer on to BO server? Right?
Aussie2582 (BOB member since 2008-04-16)
No, I am saying that to connect to the database from your PC you use some middleware (either ODBC, or OLE DB for SQL server, or Oracle client for Oracle DB or something else). The same middleware must be configured also on the BO server. With the information you provided I can not help more.
Marek Chladny (BOB member since 2003-11-27)