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

Поиск
Список
Период
Сортировка
От Dirk Hasenbrink
Тема Bug in psqlodbc 13.02? Bulk updates + ODBC function SQLRowCount(...)
Дата
Msg-id AM0PR09MB3812C2CD838DB01DFEC5B8D3E2D39@AM0PR09MB3812.eurprd09.prod.outlook.com
обсуждение исходный текст
Список 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

t +49 231 997 82 028
dirk.hasenbrink@remira.de
www.remira.com

Instagram

0

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.

 

В списке pgsql-odbc по дате отправления:

Предыдущее
От: Adrian Grucza
Дата:
Сообщение: Re: [PATCH] Fix FetchRefcursors issues
Следующее
От: hemant Kawalkar
Дата:
Сообщение: Support Postgresql Stored Procedure execution error in VBA