Re: Problems with Oracle ODBC calls from Lotus Scripts

What version of Notes are you using? Since 4.01, I've gotten in the habit of resetting the SQL property after I process the resultset and before I create a new resultset (in your example, between creating each of the 49 resultsets). I ran into problems where the resultset wasn't reliable unless I reset the SQL property. Maybe it's fixed with 4.5, but I've not had a chance to test it.

Hope this helps.

"Allan" <allansg_at_post1.com> wrote:

>Hi !
 

>I'm facing a very big problems when trying to read data from Oracle RDBMS
>using Lotus Scripts. I can only do 49 individual sql calls, where each sql
>call returns only 1 single row and then assign one column from the row
>retrieved to a field in a Notes document, from a single ODBC connection.
>When the 50th or more sql call is made it will always fail.
 

>Can anybody help ???? !!!

>Regards
 

>Allan
Received on Wed Mar 26 1997 - 00:00:00 CET