Thread: Bug in psqlodbc 13.02? Bulk updates + ODBC function SQLRowCount(...)
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
|