• Direct connection to an HFSQL Classic database.
• Connection to a database via an OLE DB provider.
• Connection to a database via an ODBC driver.
• Connection to a database via a native access.

Establishing a connection with a database

1. Launch WDSQL: a wizard will help you define the connection parameters.
   If WDSQL is already started, select "File .. Connection" (or click ). The current connection is automatically closed.
   Remark: The parameters of the last connection established are automatically proposed.
2. Select the access mode to the database ("Connection by" option).
   Remark: WDSQL enables:
   • Define the parameters of a connection. The connection can be established via:
     • an OLE DB provider,
     • an ODBC driver,
     • a native access (AS/400, Oracle, SQL Server, ...).
   • Use a stored connection (called "Custom connection"). For more details, see Custom connection.
3. Specify the data source of connection.
   
   This data source can correspond to:
   • the name and full path of the database.
     For example:
     • for HFSQL: "C:\MyDirectory\DatabaseHF.WDD".
     • for Access: "C:\MyDirectory\AccessDatabase.MDB".
   • the server name or alias.
     For example, for Oracle: "Oracle_Server".
   • The directory containing the xBase file (".DBF").
     For example: "C:\MyDirectoryxBase".
4. Type (if necessary) the username that will be used to connect to the database.
   Remark: This name was defined when the database was created.. Several users with different rights can exist for the same database.
5. Type the password if necessary. This password corresponds to:
   • The runtime password of the WINDEV analysis (for an HFSQL database). This password was defined in the description of the analysis.
   • The password used to connect to the database (for an Oracle or SQL Server database). This password was defined when creating the database.
     Remark: To automatically propose this password the next time you launch the login wizard, check the "Remember login password" option.
6. Go to the next step. The list of the different files (or tables) found in the database is displayed.
   
7. Select the files (or tables) to use with SQL in WDSQL. Specify the file password and path for each selected file.
   Note: If an identical password has been used for all selected files, enter this password for the first file selected and check the "Password is identical for all files" option.
8. Go to the next step.
   Remark: If some selected files come from a WINDEV 5.5 analysis, please specify the directory of this (or these) analysis(s).
9. The connection is established. Specify the operation to perform:
   • Creating a new SQL query.
   • Editing an SQL query already created by WDSQL.
   • Starting WDSQL.

1. Click the button found on the right of "Connection by" list. The window for custom connections is displayed.
2. Type the connection name ("Connection name" combo box).
3. Specify the connection parameters and validate. These parameters are presented in the previous paragraph (operations 2 to 5).

1. Click the button found on the right of "Connection by" list. The window for custom connections is displayed.
2. Select the name of the connection ("Connection name" combo box) and validate.