Furthermore, the same database can be accessed by one or more client applications simultaneously, via any of seven common protocols, over a network or on one machine. The login screen-shot displays a simple interface to a networked database. Solid reports compliance with Entry Level SQL2 syntax, significant features from Intermediate Level SQL2, SAG CLI standards. The API also features 16 and 32-bit ODBC drivers and Solid's own SA interface, giving the customer the added flexibility to integrate Solid Server within existing structures with minimal conversion. The query screen shot shows the SQL instructions used to extract the data shown in the result set example.
Data integrity is only as good as the steps taken to preserve it.
Solid Server accomplishes this task using automated backup, concurrent logging and check points. Few applications can recover from a surprise shutdown, but Solid Server lost nothing during my testing. It is safe to say a stand-alone installation of Solid Server will survive most, if not all, system surprises. My system logs reported all of the recoveries as successful. Furthermore, the recovery process was so quick I hardly had time to read the extra line displayed.