Database Interface Note: These procedures were tested using MySQL v5.1.11 and MySQL Connector/Net v6.2.0. Page 426 InduSoft Web Studio Parameter Description If a port of -1 is specified, then the connection will use the named pipes network protocol (see Protocol below). Server=myServerAddress1 & myServerAddress2 & … & myServerAddressN; Use any server in a replicated server configuration. Encryption=true; Enables SSL encryption for all data sent between the client and the server. The server must have a valid certificate installed. Encrypt=true; An alternative to Encryption above, in case there are errors.
Default Command Timeout=milliseconds; Specifies a default command timeout for the connection. This does not supercede any timeout properties on individual commands. Connection Timeout=seconds; Specifies how long the client will wait for a server connection before terminating the attempt. Ignore Prepare=true; Instructs the database provider to ignore Command.Prepare statements, to prevent corruption from server-side prepared commands. Protocol=myProtocol; Specifies which network protocol to use. The default is socket or tcp, but you can specify pipe to use a named pipes connection or memory to use a shared memory object.
Shared Memory Name=MySQL; Specifies the name of the shared memory object to be used for communication. (This parameter applies only if the Protocol parameter above is set to memory.) CharSet=UTF8; Specifies which character set to use to encode queries to the server. Please note that query results are encoded in the same character set that the data itself is recorded.