Bug in psqlodbc 13.02? Bulk updates + ODBC function SQLRowCount(...)

From: Dirk Hasenbrink <dirk(dot)hasenbrink(at)remira(dot)de>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Bug in psqlodbc 13.02? Bulk updates + ODBC function SQLRowCount(...)
Date: 2022-05-20 07:37:32
Message-ID: AM0PR09MB3812C2CD838DB01DFEC5B8D3E2D39@AM0PR09MB3812.eurprd09.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Good morning,

we would like to connect our C++-application, which can be connected to various databases (SQL Server, Oracle , MySQL ...) via ODBC, also
with a PostgreSQL 14. We are currently using the ODBC driver psqlodbc Unicode(x64) 13.02. Everything works fine except for one problem,
which we can't solve.
We use bulk insert operations and bulk update operations with arrays in our application and set the following for the
attributes:
retcode = SQLSetStmtAttr(stmt, SQL_ATTR_PARAM_BIND_TYPE, SQL_PARAM_BIND_BY_COLUMN, 0),
SQL_ATTR_PARAMSET_SIZE, SQL_ATTR_PARAM_STATUS_PTR and SQL_ATTR_PARAMS_PROCESSED_PTR

In our application we need the number of affected rows. We query this with the ODBC function SQLRowCount(...). However, the
ODBC driver psqlodbc always returns only a "1", although several updates or inserts were executed. Can you tell us why only 1 is always returned? Other
ODBC drivers from other suppliers return the correct numbers of effected rows. Does any parameter or options still need to be set? Or is it a bug?

Thank you in advance.

Best regards,
Dirk

Mit freundlichem Gruß aus Dortmund
Dirk Hasenbrink
Team Lead New Technologies
[https://mailtasticcdn.azureedge.net/img/images/siglinks/company/4b62548f-e1c8-44fc-a0d6-51c5de35035c/u_logo-XukoQU7xBJ.png]<http://www.remira.com/>
t +49 231 997 82 028
dirk(dot)hasenbrink(at)remira(dot)de
www.remira.com<http://www.remira.com>
[https://mailtasticcdn.azureedge.net/img/images/siglinks/company/4b62548f-e1c8-44fc-a0d6-51c5de35035c/u_xing-85vtGaAslp.png]<https://www.xing.com/pages/remiragroupgmbh>
[https://mailtasticcdn.azureedge.net/img/images/siglinks/company/4b62548f-e1c8-44fc-a0d6-51c5de35035c/u_linkedin-m569aSm5Dm.png]<https://www.linkedin.com/company/remira/>
[Instagram]<http://www.instagram.com/remiragroup>
[https://mailtasticcdn.azureedge.net/img/images/siglinks/company/4b62548f-e1c8-44fc-a0d6-51c5de35035c/u_fb-sPFVqLx6I2.png]<https://www.facebook.com/remirasupplychainsolutions/>
[0]<https://app.mailtastic.de/api/linkserve/campaign/53a656aa-4f46-43f5-af61-8bb891b199be/16779>
REMIRA Group GmbH | Phoenixplatz 2 | 44263 Dortmund

Amtsgericht Dortmund I HRB 31900 I Geschäftsführer: Stefan Braatz, Oliver Jenneskens, Stephan Unser

Im Rahmen dieser Korrespondenz werden Ihre personenbezogenen Daten verarbeitet. Hier gelangen Sie zur Datenschutzerklärung. Your personal data will be processed as part of this correspondence. More information in our Data Protection policy. <https://www.remira.com/de/datenschutzerklärung>

Browse pgsql-odbc by date

  From Date Subject
Next Message hemant Kawalkar 2022-05-21 19:44:12 Support Postgresql Stored Procedure execution error in VBA
Previous Message Adrian Grucza 2022-05-09 02:31:48 Re: [PATCH] Fix FetchRefcursors issues