Redshift and error "opening multiple cursors..."
Posted: Thu 23 May 2019 10:46
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?
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?