ODBC Result Error: LS:DO- The need of data has been reached

HCL Domino Domino Forum
1

I have a LotusScript agent which connects to an Oracle table to retrieve info. I am getting the above message in the server log since I upgraded my server to 6.0.1. Everything works fine on R5. Not all the info from the table is updated to my Lotus Notes db. Any help will be appreciated!

2

Subject: ODBC Result Error: LS:DO- The need of data has been reached

Did you ever get this solved? I am running a simple loop against a SQL resultset and get the “LS:DO - The end of data has been reached” even though it’s in a loop that says:

If disct = “” Then

qry.SQL = “SELECT DEFNAM, DEFADD, DEFCTY, DEFSTT, DEFZCD, DEFSEX, DEFALA, DEFAGE, DEFDTOB, DEFSSN, BOOKING#, CMLIB.CMPCHGMF.CHGSEQ, CHGDSS, CHGABV FROM CMLIB.CMPDEFMF INNER JOIN CMLIB.CMPCHGMF ON CMLIB.CMPDEFMF.CASPRE = CMLIB.CMPCHGMF.CASPRE AND CMLIB.CMPDEFMF.CASNUM = CMLIB.CMPCHGMF.CASNUM INNER JOIN CMLIB.CMPCHGTP ON CMLIB.CMPCHGMF.CHGTYP = CMLIB.CMPCHGTP.CHGTYP WHERE (CMLIB.CMPDEFMF.CASPRE ='” + pfx + “’ AND CMLIB.CMPDEFMF.CASNUM=” + nbr +") "

result.Execute

Do

result.NextRow

For i = 13 To 14

chgs = chgs & " " & result.GetValue(i)

Next

Loop Until result.IsEndOfData

Now, if I step through the code, it works FINE!!! If I just let it run, it gives me the error!

Again, this worked fine in version 5 and only broke after upgrading to version 6.

Thanks for any help!

leslie