Current Version: 1.2
LNDB is an application that enables you to easily move data from a LoggerNet data cache into a database such as Microsoft SQL Server or MySQL. Then you can use industry-standard software to access and query your data for reports. LNDB also comes with QuickReports, an application that allows you to generate simple reports from an LNDB database with just a few mouse clicks.
LNDB has two main components: LNDB Manager and LNDB Engine. LNDB Manager is used to set up a database and select the datalogger data tables that will be stored in the database. It also provides tools to monitor the LNDB Engine and to review the database data.
LNDB Engine runs as a service and sends the selected data from the LoggerNet data cache to the database. Additionally, LNDB includes utilities for importing and exporting data, and generating simple reports from your database data.
|Operating System||Windows 10, 8, or 7|
Please note: The following shows notable compatibility information. It is not a comprehensive list of all compatible products.
LNDB has been tested and shown to work with the following databases:
Note: LNDB may work with other versions of SQL Server Express, SQL Server Compact, or MySQL.
LNDB runs on Windows® 10, 8, or 7.
This tutorial shows how to move data into a database using LNDB. The report generation capabilities of QuickReports are introduced and we show how to use a database as a data source in RTMC Pro.
A fully functional 30 day trial version of LNDB (LoggerNet DataBase) software.
Note: This application requires the Microsoft .Net 3.5 and .Net 4.6.2 Frameworks. If they are not already installed on your computer, they can be obtained from the Microsoft Download Center.
Number of FAQs related to LNDB: 24
Expand AllCollapse All
Not at the same time. Currently, a user would have to manually switch back and forth between the database hosts periodically using the File menu Select Database... option to keep them both updated.
No. The purchased version is separate from the trial version. Uninstall the trial version, and install the purchased version.
Yes, as part of the SDK—the CSIDataSource control.
LNDB uses two fields as primary keys: the record number and time stamp. If the record number and time stamp are both duplicated, the record is discarded. If only the record number or only the time stamp is duplicated, LNDB should import the record.
One method is to use Custom Collect to specify a range of data and then store the data to a different file. Alternatively, if LNDB is set up to store data in a database, a range of data can be pulled out and stored in a separate data file. These two methods, however, are manual ones.
LNDB has been tested to run on Windows 7, Windows 8, and Windows 10.
Because Windows Server installations are all uniquely configured, it is nearly impossible for our application engineers to replicate a customer’s implementation environment at our facility.
To test whether LNDB will work in a particular Windows Server environment, download the 30 day trial versions of LoggerNet and LNDB. Each is available in the Downloads section of the product page: LoggerNet and LNDB.
No. It can only be changed using the Login to LoggerNet Server dialog box. The Login to LoggerNet Server dialog box opens automatically after LNDB is installed. It can also be opened at any time from the File | Select LoggerNet Server menu item or by double-clicking the LN Connection Status Label on the Status Bar.
With LoggerNet and LoggerNet Admin, remote connections are not enabled by default. They have to be enabled in the LoggerNet Toolbar. Right-click anywhere on the toolbar, and, in the resulting dialog box, verify that Allow Remote Connections is selected.
Table names in LNDB are automatically generated and cannot be changed.