• in 32 bits: WDSQSINS.EXE
• Versions 22 and later
  in 64 bits: WDSQSINS64.EXE
  New in version 22
  in 64 bits: WDSQSINS64.EXE
  in 64 bits: WDSQSINS64.EXE

• the setting of a connection.
• the definition of connection options.
• the test of a connection.

1. Start WDSQSINS.EXE.
2. In the window that is opened (used to list the existing connections), click the "Add" button to create a new connection.
   
3. Specify the connection settings:
   

• Choose the name of the data source. This name will be passed as a parameter to the function SQLConnect to connect to the base station.. If the connection was defined in the data model editor of WINDEV or WEBDEV, specify the name of the corresponding connection.
• Add a description caption.
• Specify a connection string. The connection string is the name of the server where SQL Server is installed. It is used to find the database. Example of connection string: CSNT
• Specify whether the format of the dates must remain 5.5-compatible.
  Reminder: Between version 5.5 and version 5.5B, the date format was modified. If you check the box, you will restore the date format returned before version 5.5B (see the paragraph below).
• Specify the options to use:
  • Use a count(*) query with SQLFirst: When running with function SQLFirst, function SQLInfo fills the Variable SQL.NbLig (number of lines in the result).
    By default, a COUNT query is generated to fill this variable ("Use a count(*) query with SQLFirst" is checked). This query increases the number of exchanges on the network but it optimizes the execution of SQLFirst.
    To avoid increasing the number of exchanges on the network, uncheck "Use a count(*) query with SQLFirst". In this case, the execution of SQLFirst may be slowed down.
  • SET ANSI_NULLS: Opens the connection in 'SET ANSI_NULLS ON' mode'. If this option is not checked, the default connection settings are used (settings defined on the server). This option is required to access a remote server (called linked server).
  • SET ANSI_WARNINGS: Opens the connection in 'SET ANSI_WARNINGS ON' mode'. If this option is not checked, the default connection settings are used (settings defined on the server). This option is required to access a remote server (called linked server).
• The connection is added to the list once the parameters are validated.

Remarks

• The information about the setting is stored in the Wdsqsins.ini file in the Windows directory ("C:\Windows\" or "C:\Users\LOGIN\AppData\Local\VirtualStore\Windows\" in Windows Vista/7).
• WDSQL is used to check whether the connection to the database is correct.

Date format returned by the native SQL Server driver

Options for the locks

• the time-out: the time-out during the call to SQLLock can be infinite or not (deadlock). The "Time-out" is set to 1 minute by default, it can be modified.
• the lock mode. See the documentation about the server for more details.

1. Select the connection whose test must be run.
2. Click the "Test" button.
3. Specify the name and password of the user.
4. Click the "Test the connection" button. The status report is displayed.