|
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.
|
