Tuto WINDEV 25

346 Part 5: Managing a HFSQL Client/Server database 11.  The wizard proposes to enable the authentication via Active Directory. Enable this option if necessary. 12. Validate (or not) the participation in product improvement by allowing us to collect information regarding the use of product. This optional and anonymous collect allows PC SOFT to improve the product features. 13.  The setup is performed. By default (if you have not changed the administrator settings), to connect to the server in administrator mode, you must use the "Admin" user without a password. Creating an application that is using a HFSQL Client/Server database Creating a WINDEV application that is using a HFSQL Client/Server database is child’s play. You must: 1. Create the project by asking to create a new database. 2. Create the analysis by specifying that the databases used by the project will be "HFSQL Client/ Server" databases. 3. Specify the characteristics of the connection to the HFSQL Client/Server server that will be used. 4. When creating a data file in the analysis, indicate that this data file is in Client/Server mode and specify the connection used. Remark You can also describe the connection to the HFSQL server by programming. See the online help for more details: HDescribeConnection . Adapting an application to use a HFSQL Client/Server database Overview Switching a database from HFSQL Classic mode to Client/Server mode is the most common operation. WINDEV proposes several methods to perform this switch: • perform this adaptation in the data model editor. • perform this adaptation from the HFSQL Control Center. To better understand the different steps, we are going to switch the application that was created in Part 3 to Client/Server mode by using the first method, the data model editor.