Warning: The magic method OCDI\OneClickDemoImport::__wakeup() must have public visibility in /customers/c/1/7/systemintegration.dk/httpd.www/wp-content/themes/onecom-psychologist/importer/inc/OneClickDemoImport.php on line 121 Warning: Cannot modify header information - headers already sent by (output started at /customers/c/1/7/systemintegration.dk/httpd.www/wp-content/themes/onecom-psychologist/importer/inc/OneClickDemoImport.php:121) in /customers/c/1/7/systemintegration.dk/httpd.www/wp-content/plugins/onecom-vcache/vcaching.php on line 702 Warning: Cannot modify header information - headers already sent by (output started at /customers/c/1/7/systemintegration.dk/httpd.www/wp-content/themes/onecom-psychologist/importer/inc/OneClickDemoImport.php:121) in /customers/c/1/7/systemintegration.dk/httpd.www/wp-content/plugins/onecom-vcache/vcaching.php on line 710 2.1 Installation – Broedsgaard SystemIntegration ApS

2.1 Installation

1. Unzip zip-file #

1.1 Unzip downloaded zip-file

1.2 Move folder “DBGW Service 1” to your preferred location. Example “C:\Program Files (x86)”

Note: You have to be logged in as Administrator to use folder locationC:\Program Files (x86)”.

1.3 Rename folder if you wish. Example “DBGW for ProdDB”.

Note: Folder name is going to be the name of the Windows service.

2. Edit Config file #

2.1 Double click on “Config.txt” file, for editing.

Note: Only change values or text after #1=, #2=, #3= and #4=

2.2 Select Diagnostic level (#1)

Level 0 = Only errors are logged to Windows Event Viewer. Default
Level 1 = SQL query from PLC and errors are logged to Windows Event Viewer
Level 2 = SQL query from PLC, response from database and errors are logged to Windows Event Viewer

Diagnostic level 0: #1=0

Note: Increased CPU load for Level 1 & 2 due to writing to event log, if there are many queries/second. Therefore, #1=0 is the default

2.3 Enter local IP-address or Network Connection Name (#2)

Enter IP-address for used ethernet port. Example: #2=192.168.202.21

Or enter Network Connection Name. Example: #2=Ethernet 1

Note: PLC must have access to this IP-address to establish communication to DBGW Service

2.4 Enter local listening port number (#3)

Enter unused portnumber for DBGW Service. Default 11201

#3=11201

Note: PLC must have access to this port number through switches and firewalls

Note: If your are installing 2 or more DBGW Services on the same Windows computer, each DBGW Service must have a unique port number. IP-addresses can be the same

2.5 Enter SQL-connection string (#4)

Connection string to a SQL Database depends on various things, therefore some examples are listed in the Config file.

For additional help, try this link: https://www.connectionstrings.com/sqlconnection/

Example 1: Using SQL User for database login

DBGW Service installed on Windows computer with IP-Address =192.168.202.21 and SQL Server Express is installed on another Windows computer with IP-Address 192.168.202.201, database name is “DBGW_Test”, SQL user is “PLC_user” with password “Password1234”. SQL listening portnumber=1433

#4=Server=192.168.202.201\SQLEXPRESS,1433;Database=DBGW_Test;User ID=PLC_user;Password=Password1234

Note: Blank password is not supported

#4=Server=192.168.202.201\SQLEXPRESS,1433;Database=DBGW_Test;User ID=PLC_user;Password=Encrypted:SbkSa4PpWDOoNBLOr6SAvg==:Encrypted

Note: Password will be encrypted after the first start of DBGW-Service

Note: Computername of SQL-Server can also be used instead of IP-Address

Example 2: Using Windows Workgroup User for database login

DBGW Service and SQL Server Express installed on the same windows computer with IP-Address = 192.168.202.21, database name is “DBGW_Test”

#4=Server=localhost\SQLEXPRESS;Database=DBGW_Test;Trusted_Connection=True

The Log on user for DBGW-Service must be the same as SQL database Windows Workgroup User

Note: Entering DBGW Service log on user, can first take place after installation of DBGW Service, go to next chapter.

Example 3: Using Windows Domain User for database login

DBGW Service installed on Windows computer with IP-Address =192.168.202.21 and SQL Server Express is installed on another Windows computer with IP-Address 192.168.202.201, database name is “DBGW_Test”, SQL listening portnumber=1433

#4=Server=192.168.202.201\SQLEXPRESS,1433;Database=DBGW_Test;Trusted_Connection=True

Note: Computername of SQL-Server can also be used instead of IP-Address

The Log on user for DBGW-Service must be the same as SQL database Windows Domain User

Note: Entering DBGW Service log on user, can first take place after installation of DBGW Service, go to next chapter.

Note: Future modifications to this Config.txt file requires a restart of the Windows DBGW Service to take effect.

3. Install DBGW Service #

3.1 Right click on “Install.bat” and select “Run as administrator”

3.2 Click “Yes” to allow this app to make changes on your device. Only requested if User Account Control is active.

3.3 Check that installation is successful and that the service is started, see screenshot above.

3.4 Press Enter to finish installation.

3.5 Installation finished, but if you need access to another SQL-Server instance, you need to install another DBGW-Service. Therefore copy folder “DBGW Service 1” and rename it to “DBGW Service 2” and go to chapter 2

3.6 Change Log on user for DBGW Service, only required if Windows Workgroup or Domain User is used for database login

Windows Workgroup User in selected in SQL Database:

Change Log on user for DBGW Service:

4. Check DBGW Service installation #

4.1 Write “services” in Windows search field, and select Services App.

4.2 Check that DBGW-Service is Running, see screenshot below.

4.3 Write “event” in Windows search field, and select Event Viewer App.

4.4 Under “Application and Service Log” a new “DBGW Log” folder is created. See screen shot below.

4.5 Scroll through generated events, and check that specified values in “Config.txt” file has generated the correct events.

4.6 Check that there is no Errors.

Note: The connection to SQL Database is checked during startup, if this connection fails, an error will be generated with cause description

4.7 Three optional BAT-files are available for Starting, Stopping and Force restart of DBGW service.

Note: Right click on one of the three files and select “Run as administrator” if you are not logged in as administrator