OpenDataSets

[garry]

I am trying to use the Opendatasets with almost 25 Queries.

I hv following errors
"Object was open.
Cannot execute command in current transaction context until previous opened DataSet (CursorType is ctDefaultResultSet) is fetched to end"

and
"Query does not return next result set"

I guess these error are because of
"Note, that when this operation is performed, each one of the opened datasets should return only one resultset" as mentioned in help.

What is the meaning of "One Resultset"? I never use Go statement in my queries there is always a single Query without GO.

Can you please suggest me some workaround where i can optimise the time significantly at Remote connection.

Regards

[garry]

ok
these errors gone when i used NonBlocking = False + latest Sdac version.

[Challenger]

You can not have several datasets underfetched if you do not use MARS.