This particular application is used to created users. And it had UI to display the list of all users created. When we create a user using New and Accept buttons, it is not updating the list nor it is updating the database. We have enabled TLS 1.2 and so using ODBC Driver 17
When I changed the driver to simple "SQL Server", then all the previously non-displayed users also got added to the list and database as well.
when I debugged the code, it is failing at one particular line of code - SQLBulkOperations i.e,
As an alternative, I changed the code to
result = SQLSetPos(m_hStatement, 1, SQL_ADD, SQL_LOCK_NO_CHANGE);
It is able to add the users to database, but the problem is, the users data is not syncing to the server.
Note: We have restarted the NodeSynchronizer service. All the configurations are correct.
Please help.