Serial NO. : S00201030-EN
Date of Editing : 2022-09-30
Questions : How to switch between file system mode and database mode of 701ServerSQL / 701ClientSQL?
Before switching from file system mode to database mode, it’s required to download database programs.
The data between two modes are not universal, therefore, the transaction logs are irreversible after mode changed. It is recommended to use “file to text” function to save daily event log data as text file for searching requirement.
701software support database program MariaDB, MySQL and other compatible database engine, here will use MariaDB for instance.
Step1. Confirm the database program has been downloaded
Control panel > confirm database program and driver are both downloaded
Step2. Closed 701ServerSQL and 701ClientSQL
Step3. Search the folder of 701ServerSQL and 701ClientSQL, opening ODBC folders and modify the string value of “CANCEL”
*Please remind that the value is required to be synchronous, file system with value 1, database mode with value 0.
|File system mode||Database mode|
Step4. After modifying the string value, reopening 701ServerSQL and 701ClientSQL will change the mode. We could check the mode function through the software, selecting Help > About and confirm the field as below:
*It will display “SQL Database Mode” while the string value modified as 0.
*It will display “File System Mode” while the string value modified as 1.