Link to home
Start Free TrialLog in
Avatar of slugerama
slugerama

asked on

NotesSQL ODBC connection

I am trying to extract information from a Notes DB into a BO XI report but am having trouble. I have got the NotesSQL (3.02)software and have installed and configured it. I have created the ODBC connection and it is working fine. I have gone into Business Objects Created a new connection, and then written an SQL statement:

Select * from table_name
Click on RUN or VIEW and it starts to do its thing then gets to about 17000+ rows when I get this message:

Connection or SQL sentence error: (DA0005) click on Details gives you :

Exception: DBD, [Lotus][ODBC Lotus Notes]Invalid cursor stateState: 24000
ASKER CERTIFIED SOLUTION
Avatar of Sjef Bosman
Sjef Bosman
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial