Redshift and error "opening multiple cursors..."

[mariot]

Hi.

I use Unidac 7.3.10 and have problem with data access provider for Amazon Redshift.
When I open new query, while exist another open query (main), then this error appeared (after second record in main query is processed):
"opening multiple cursors from within the same client connection is not allowed"

I use provider for Amazon Redshift similar way as data access provider for PostgreSQL with similar program code. In PostgreSQL it is OK, in Amazon Redshift not.

With ODBC connection it is OK (for Amazon Redshift).

Any suggestion please?

[mariot]

Solution: I had UniDirectional parameter set to true. When I set it to false, then using of Redshift provider is OK, but it is more slow.

[MaximG]

The described issue is not caused by our driver functionality - it stems from the limitations that Amazon Redshift imposes on the use of cursors. Please see this page for a detailed description: https://docs.aws.amazon.com/en_us/redsh ... clare.html