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>
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 |