Selecting a Database
The Select Database dialog box comes up automatically the first time LNDB is opened once the service is installed and started and the server is selected. At other times, it can be opened from the File > Select Database menu item or by double-clicking on the DB Connection Status Label on the Status Bar. LNDB supports SQL Server Compact, SQL Server, MySQL, Oracle, and PostgreSQL databases. Once you select a database, fill in the necessary information, and click OK, a connection attempt will be made. If the connection succeeds, the database dialog will be closed and the connection will be used for the application. If the connection fails, a message will be shown and the Select Database dialog will continue to be shown.
When using SQL Server, MYSQL, Oracle, or PostgreSQL, you will need to first create a database instance to be used by LNDB. See Creating a Database for MySQL, Microsoft SQL Server, Oracle, or PostgreSQL.
For LNDB versions 2.0 and older, SQL Server Compact is included with the LNDB install. If you are running LNDB 2.0 or older, this database should not be uninstalled. It is required for LNDB to function correctly.
When installing LNDB versions newer than 2.0, you are given the option of whether or not to install SQL Server Compact. (SQL Server Compact is at end of life and Microsoft ended their extended support for this database in July 2021. Campbell Scientific provides the option to install SQL Server Compact for compatibility reasons for organizations still using this database.)
If you have upgraded an older version of LNDB to a version newer than 2.0 and you are not using the SQL Server Compact database, you can uninstall the database without affecting the functionality of LNDB.