Configuring the Connection to the SQLite Database with the SQL Gateway Console

Preconditions

Before you configure the connection to the SQL database with the SQL Gateway Console, make sure that you already executed the steps for establishing an SQL connection:

Step 1: Set up the PC on which you intend to install the SQL Gateway.
Step 2: Set up your SQL database.
Step 3: Install the SQL Gateway.

To configure a connection to an SQLite database, you first have to configure a general Database Server for SQLite specifying the server name and the server type. As the SQLite database file is saved locally on the SQL Gateway PC, there is no further configuration required for the server. In a second step, configure one or more Database Connections to specific SQLite database files that are accessible via the Database Server.

Configuring Access to SQLite Database Servers

This procedure describes how to define the access to an SQLite database server:

Step	Action	Remark
1	In the Configuration tab of the SQL Gateway, right-click the Database Servers node in the tree structure on the left-hand side and execute the command New Database Server.	Result: A new subnode with a default name is created.
2	Enter a unique Server Name in order to identify this database server.	–
3	Select SQLite from the Server Type list.	Since SQLite database files are accessed directly without a database server, no further Database Servers parameters need to be configured. Proceed with the Database Connections configuration.

Configuring the Database Connections

This procedure describes how to create a connection to an SQLite database file:

Step	Action	Result/Remark
1	In the Configuration tab of the SQL Gateway, right-click the Database Connections node in the tree structure on the left-hand side and execute the command New Database Connection.	Result: A new subnode with a default name is created.
2	Enter a unique Connection Name in order to identify this database connection.	Make sure that exactly the value of the parameter Connection Name is used in the client configuration: The element wsDbConnectionName configured in the EcoStruxure Machine Expert SqlRemoteAccess library must have the identical value as the parameter Connection Name.
3	From the Server Name list, select the SQLite database server.	The Server Name list contains entries for those servers that are defined under the Database Servers node. After you have selected an SQLite database server as Server Name, the configuration parameters described in this chapter are displayed.
4	Enter the path to the SQLite Database File directly or click the Browse button to browse the file system for the file.	–
5	In order to add further parameters to your SQLite database configuration, click the Select button and activate the parameters of your choice in the Select Advanced Properties dialog box.	Result: After you have confirmed your selection with OK, the selected parameters will be displayed in the editor and can be configured.
6	Click the Test Database Connection button in order to verify whether the connection to the database can be established with the parameters configured.	Result: A message is displayed indicating the result of the test. For further information, refer to the Troubleshooting chapter.