Re: Cursor C1 already open

["Adam Lang" <aalang@xxxxxxxxxxxxxxxxxxxx>]

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.