ODBC Driver Requirements

Previous Next

A USoft for ODBC application requires an ODBC driver and a DBMS to access data. There are many ODBC drivers available on the market. Not all ODBC drivers can be used with USoft. This section details the minimum ODBC driver functionality required by a USoft ODBC application.

A USoft ODBC application does not check all the requirements listed in this section every time at start-up. Instead it just activates the ODBC functions and sends SQL-statements to the driver at run-time.

If the connected ODBC driver is not capable of executing the request it will return an error. USoft will retrieve the error message, show it to the user and cancel the requested action. This way it is possible to use an USoft ODBC application in combination with an ODBC driver that does not support the complete SQL syntax and all SQL data types and scalar functions. Development or deployment can be severely hindered, or even become impossible, when too many of the requirements are not met.As a work around, you might need to change the application by changing or removing the error-producing SQL or data type definitions. Whenever possible use an ODBC driver that does support at least all the requirements.