Lotus Notes SQL (ODBC) driver throwing error msg in webi

Hello,

I was able to configure notes sql driver using instructions I found in one of posts posted here… whil odbc driver works fine in Crystal Reports (and even in excel) in webi i am getting error msg as in attachment. I am able to create universe in Designer, pull table data etc. no problem there but when I create report in webi and run it then i got error msg.
Did anyone had same problem?
Thanks
error.jpg


Aleks2008 (BOB member since 2008-08-17)

Hi;

I’m having the same problem with both Webi and Deski. Did you manage to resolve this.


Rapelang (BOB member since 2009-05-13)

We have never resolved it. I opened a ticket with BO Helpdesk but their final answer was that Lotus Notes is not supported as universe data source.
I still believe it is possible but considering we are going abandon Lotus Notes in near future I guess it’s not feasible to keep looking for a solution.
Good luck and let me know if you find way around or fix for this.


Aleks2008 (BOB member since 2008-08-17)

I am having the same problem using NotesSQL driver 8.5 with Notes 8.5. It works intermittently but can’t figure out why I get the “Invalid Cursor State” error. It seemed to work better when a coopy of the .nsf file was loaded to the BO report server. hsweaver@sunocoinc.com


harweaver (BOB member since 2009-05-05)