Database driver SQL processing
As discussed in Database driver overview, the
LN application virtual machine sends RDBMS
independent read and update requests to the database driver.
The database driver's function is to convert these RDBMS independent database requests into SQL statements that are appropriate for the specific RDBMS being used. This section details the SQL processing that is performed by the LN MSQL database driver.
The LN database driver uses the Microsoft Open Database Connectivity (ODBC) interface to communicate with the SQL Server, the ODBC interface is described first.