Re: Cursor C1 already open

I was doing the explicit close in both my attempts.  I even set the
recordset to nothing after the close.

It only works if I set the connection object to nothing also and reconnect
on every loop.

I am reinstalling CAE 4.4 and seeing if it works.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: <vhamberg@attbi.com>
To: <midrange-l@midrange.com>
Sent: Wednesday, August 28, 2002 1:21 PM
Subject: Re: Cursor C1 already open


> Boy, I don't know. Does the example from IBM do the
> explicit Close? If not, it might bomb. It may have
> worked when the example was written, but that could have
> been several releases ago.
> > I rewrote my program to use command objects, connection objects and
> > parameters and it still fails with that error.
> >
> > I downloaded the sample code from IBM and ran the program that that had
a
> > similar type of call and it also bombs out.
> >
> > I installed CAE 5.1 a week or so ago (when I had done this before over a
> > year ago the code worked andit was on CAE4.4).
> >
> > The AS/400 is still 4.4.
> >
> > Any possible issues with the OLE DB provider maybe?
> >
> > Adam Lang
> > Systems Engineer
> > Rutgers Casualty Insurance Company
> > http://www.rutgersinsurance.com
> > ----- Original Message -----
> > From: "Vernon Hamberg" <vhamberg@attbi.com>
> > To: <midrange-l@midrange.com>
> > Sent: Tuesday, August 27, 2002 11:09 PM
> > Subject: Re: Cursor C1 already open
> >
> >
> > > Adam
> > >
> > > There is a need to close a cursor when the statement has changed. In
this
> > > case, the cursor describes an access plan based on one input value.
Then
> > > when a different input value is used, that access plan is different -
a
> > > different recordset returned. Is there a kind of reset or renewal of
the
> > > recordset, based on the new input value - I forget - my VB and ADO is
> > rusty.
> > >
> > > HTH and is even a little bit close.  <g>
> > >
> > > Vern
> > >
> > > At 11:52 AM 8/27/02 -0400, you wrote:
> > > >I am writing some short VB code to query information of the AS/400
using
> > ADO
> > > >(ole db).  I want to create on connection and recall a function to
keep
> > > >running the same query over and over with only a parameter change.
> > >
> > >
> > > -snip-
> > >
> > > _______________________________________________
> > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > > To post a message email: MIDRANGE-L@midrange.com
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> > > or email: MIDRANGE-L-request@midrange.com
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/midrange-l.
> >
> > _______________________________________________
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> > To post a message email: MIDRANGE-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> > or email: MIDRANGE-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.