Database Interface 8. Click OK to close the Edit Property Value dialog. Editing the value of Extended Properties 9. Click the Connection tab. 10.Click Test Connection . If a connection can be successfully established, then an appropriate message is displayed. 11.Click OK to save your changes and return to the Database Configuration property sheet. Note: Be sure to select (check) the Disable Primary Keys option in the Database Configuration dialog. If you do not, then IWS will not be able to connect to your Excel spreadsheet. Important: Desktop office applications such as Microsoft Access and Microsoft Excel cannot efficiently handle large amounts of data.
If you try to save all of your project's historical data in an Access database or Excel spreadsheet, then the queries will become slow and you might get unexpected results. Therefore, we recommend that Access or Excel be used only as a Secondary Database, with the Store and Forward option enabled, or to relay data to third-party software. To handle large amounts of historical data, we recommend that you use either IWS's proprietary format or a dedicated relational database such as Microsoft SQL Server or ORACLE. Using MySQL IWS can interface with MySQL databases, but to do so, you must install an ADO.Net provider for MySQL.
The provider required by IWS is MySQL Connector/Net, and at the time of this writing, the necessary software can be downloaded from the official MySQL site . (Please note that the linked site is beyond our control and may change without notice.) Once the provider is installed, you can use the Database Configuration property sheet to configure a MySQL database connection. However, unlike for other database types, you cannot use the Data Link Properties dialog (which is accessed by clicking ... to the right of the Connection string box) to form the connection string. Instead, you must directly enter the connection string using this basic format:
Provider=MYSQLCLIENT; Server= myServerAddress ; Database= myDataBase ; Uid= myUsername ; Pwd= myPassword ; The following optional parameters can be appended to the connection string: Optional parameters for the MySQL Connector/Net connection string InduSoft Web Studio Page 425 Parameter Description Port=number; Specifies what port to use for the connection. The default port is 3306, but any port can be specified as long as it matches the server configuration.