public inbox for [email protected]  

help / color / mirror / Atom feed

From: Dirk Hasenbrink <[email protected]>
To: [email protected] <[email protected]>
Subject: Bug in psqlodbc 13.02? Bulk updates + ODBC function SQLRowCount(...)
Date: Fri, 20 May 2022 07:37:32 +0000
Message-ID: <AM0PR09MB3812C2CD838DB01DFEC5B8D3E2D39@AM0PR09MB3812.eurprd09.prod.outlook.com> (raw)

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...]<http://www.remira.com/;
t +49 231 997 82 028
[email protected]
www.remira.com<http://www.remira.com;
[https://mailtasticcdn.azureedge.net/img/images/siglinks/company/4b62548f-e1c8-44fc-a0d6-51c5de35035c...]<https://www.xing.com/pages/remiragroupgmbh;
[https://mailtasticcdn.azureedge.net/img/images/siglinks/company/4b62548f-e1c8-44fc-a0d6-51c5de35035c...]<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...]<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;

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Bug in psqlodbc 13.02? Bulk updates + ODBC function SQLRowCount(...)
  In-Reply-To: <AM0PR09MB3812C2CD838DB01DFEC5B8D3E2D39@AM0PR09MB3812.eurprd09.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox