Hi @AJDELACRUZ0220
Try adding the conopts= option in your connection string.
It would look like this:
connect to odbc as hindsight (datasrc='PostgreSQL30' user=myuser password="mypassword" dbmax_text=12000 conopts="UseDeclareFetch=1;Fetch=1000;UseServerSidePrepare=1;")
If this doesn't work simplify the CONOPTS= option, like this:
connect to odbc as hindsight (datasrc='PostgreSQL30' user=myuser password="mypassword" dbmax_text=12000 conopts="UseDeclareFetch=1;")
Hopefully one of these will help you.
Best wishes, Jeff
... View more