WEBI web Tool error : (WIS 10901)

[Former Member]

A database error occurred. The database error

text is: [Microsoft][SQL Server Native Client 10.0]

Statements(s) could not be prepared. (WIS 10901)

I am connecting to universe using rich client it is working fine.

But for the same Universe , If I use WEBI web Tool inside Internet Explorer , I am getting above error.

I am using SAP BO XI 3.1. I am using ODBC connection for the Universe.

Any info will helpful. Let me know for any solutions.

[Former Member]

thank you all people... i did find partial solution by fully-qualified naming.... needs more info.

http://www.mssqltips.com/sqlservertip/1831/using-windows-groups-for-sql-server-logins-as-a-best-prac...

I am using windows AD login... if i use fully-qualified naming..like databasename1.dbo.table1

...

but this has become little tedious .... looking  forward far more thoughts...

[former_member184594]

Do you have the ODBC defined in BO server as well? If it is not, then you need to define with the same name as defined on your local machine. Otherwise, you will keep getting this error.

[Former Member]

Hi

You need to create an ODBC system datasource with same name you created in your client system.

Step to create ODBC system datasource

- Go to path in server "C:\WINDOWS\SysWOW64"

- Execute the exe called "odbcad32.exe"

- go to system DSN tab and create an datasource connecting to SQL Server.

Regards,

Rama

[Former Member]

I am using same 32 bit  ODBC datasource name as present on Server and inside my .unv file.

but the same error message continues...

[Former Member]

Hi,

Things are getting confused:

Initially it was been said you are able to create the report using WEBI rich client(on your machine) and only the problom lies at server side when you are refreshing the WEBI in Infoview.

Now, there is problem in universe. It seems there is a problem in query. Check the object definition and the query you developed using that objects.

Regards,

Rama

[former_member207342]

Check your connection security in CMC.

--Kuldeep

[sapanesh_agnihotri]

HI Lotus,

Create a 64 bit DNS on server as well, you might be having only 32 bit DNS on client machine.

make sure both DNS has same name.

Thanks,
Sapanesh

[Former Member]

not sure y 64bit is needed ? for BOE XI 3.1 ...

[Sujit]

Hi Lotus,

Was this working before or you testing this for first time? Have you created a ODBC connection at the Server level too, after exporting the Universe to the repository?

If not, you will have the create a System DSN on the server, with the same name as locally defined connection

Also, remember not to have any blank spaces in the ODBC datasource name.

Re-export your universe with this new connection and let me know if it helped.

Thanks.

Sujit Honrao

[Former Member]

using same 32 bit  ODBC datasource name as present on Server and inside my .unv file.

but the same error message continues...

[Sujit]

Do you have it defined on your local machine too?

[DayaJha]

HI,

Please refer the below thread & SNotes From SAP Market Place regarding  WIS: 10901 Data source name not found and no default driver specified(ODBC).

1396736 - "(SBO0001) DBD: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" error when testing connection in Universe Designer on 64-bit Windows OS

Links:

https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F6465...

Links:

http://scn.sap.com/thread/1004813

http://scn.sap.com/thread/1914241

Hope this will help you as well.

Thanks,

Daya

[Former Member]

please see my other replies.. Thank you