Example of How to Connect to IBM DB2 SQL Setup: SQL database is installed on laptop with IP address 192.168.250.50. NJ uses address 192.168.250.1 Introduction: The SQL DB connection is setup in the “Configurations and Setup” in Sysmac Studio. Show “Host Connection Setting” in the setup section of Sysmac Studio. This lets you test and setup your connection to the SQL Host. • DB Connection Service Settings – specify error files and enable service • DB Connection Settings – set logon to SQL server Under Service Start – pick “Auto Start” to make the SQL service start on power up.
If you pick “Test Mode” (database not present) then the NJ will send all SQL commands to the SD memory card and all the program instructions will assume connection or data transfer was good – for debugging. Page 2 of 21