omron — Database/ERP worksheet

Background Tasks Database/ERP worksheet In addition to ODBC, IWS also supports Microsoft .NET ActiveX Data Objects (ADO.NET) for interfacing between the project tags database and other external databases. A Database/ERP worksheet is used to associate project tags with external database fields. Note: For more information about ADO.NET support in IWS — including how to communicate with remote databases using the IWS Database Gateway software — please see Database Interface . To interface with an external database, you must first configure a connection to the database and then build a worksheet that associates project tags with the database fields.

Database Connections To create a new connection to a target database: 1. In the Project Explorer , open the Database/ERP folder and then right-click on Connections . 2. Choose Insert from the shortcut menu. The Database Connection dialog is displayed. Database Connection dialog 3. In the Name field, enter the name that you want to use to reference the target database. You can create multiple database connections, but each connection must have a unique name. 4. In the Connection String field, click the browse button … to open a standard Data Link Properties dialog. Use the dialog to configure a connection string for the target database. Note:

The list of Database Providers shown in the Data Link Properties dialog depends on the providers actually installed and available in the station where you are running the development application. For more information about using the Data Link Properties dialog, please refer to Windows Help. 5. In the User Name and Password fields, enter an appropriate login for the target database. The login should already be created on the database server, and it should have enough privileges to read from and write to the database tables. 6. If you are connecting to a remote database through the Studio Database Gateway , then click the Advanced button to open the advanced settings dialog, as shown below.

Database Connection (Advanced) dialog 7. In the Host field, enter the IP address of the station that is running the IWS Database Gateway software ( STADOSvr.exe ). In the Port field, enter the port number on which the software has been configured to run. Page 286 InduSoft Web Studio