Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Sometimes there are ODBC Error and SQL Statement Execution Error during the operation, what solution for that?

April 26, 2017Error execution ODBC operation solution sql

0

Posted

Sometimes there are ODBC Error and SQL Statement Execution Error during the operation, what solution for that?

1 Answer

0

Posted

Concerning the ODBC error that sometimes occur, please update your MDAC to the version 2.6 available in http://www.microsoft.com/data or you can find it on CardFive CD in the following directory \Tools\Odbc\Uk\setup.exe. If the error still occurs please contact the NFive Tech Support with more information about it. Also make sure that the database is not being accessed by more than one process at the same time for writing purposes. If the process is running in a slow machine, the windows locking methods may fail and the N5 Database Interface may issue the SQL Statment Execution Error message. This exception has been noticed under rare circumstances when using more than one Auto Print session involving the same database resources.