Unknown exceptions possibly originating from psqlodbc

Hello,

I am a software engineer working for Kepware Technologies. We provide control and monitoring software for automation devices. One of our products is an application that stores device data into a customer's database. We support various database products, Postgres among them.

I was given your contact information by one of our customers, John Psihos at ProcessLinx.

We have been working on an issue with him for several months now, where we are intermittently receiving an unknown exception when trying to update a record set (an MFC call that ultimately goes to the ODBC driver). We have tested our code, as well as MFC (as much as possible) and have found no issues. The most likely area left seems to be the ODBC driver. We are using version 9.3.400 of the ODBC driver, and PostgreSQL 9.4. Once we receive this unknown exception from the record set, it is unusuable (as if it's internal state is bad, although I haven't been able to discover any evidence of this on my side), and generates further unknown exceptions when I try to close or delete it.

My primary question is, do you have any insight into what exceptions you might throw in the case of a record set update? Further, are there any tools, header files, debug versions, logging utilities, etc. that you could provide to help us diagnose this problem?

Any help you could provide in this matter would be appreciated.

Regards,

Brent Smith
Senior Software Engineer | Kepware Technologies<http://www.kepware.com/>

Email: Brent(dot)Smith(at)kepware(dot)com<mailto:Brent(dot)Smith(at)kepware(dot)com>

Follow Us: Facebook<https://www.facebook.com/kepware> | Twitter<https://twitter.com/Kepware> | LinkedIn<http://www.linkedin.com/company/kepware-technologies> | YouTube<http://www.youtube.com/user/kepware>