Re: Problems with Oracle ODBC calls from Lotus Scripts

Sorry for the lack of info ... I'm using Notes 4.5 and Oracle 7.3 server.

Btw ... can I know what do u meant by resetting the SQL property ?

Allan

Terrance A. Crow <tacrow_at_ix.netcom.com> wrote in article <5ha3m9$44t_at_mtinsc04.worldnet.att.net>...
> 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