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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.