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
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.
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