omron — Studio Database Gateway

Database Interface • Options menu option: Open the Configure Messages dialog. Studio Database Gateway: Configure Messages dialog • Show Messages pane: Select Errors Only to show only error messages in the log, or select All Messages to show all database messages. • Additional Information pane: Configure to show additional information about each database message. • Message Type checkbox: Click (check) this option to show the type of the message. • Date/Time checkbox: Click (check) this option to show the timestamp of the message. Advanced Settings The Studio Database Gateway has Advanced Settings that are configured in the StADOvr.ini file.

If you are having problems interfacing with a specific database, you will probably need to change some of these settings or add new providers to the file. The following parameters are available: Page 404 InduSoft Web Studio Section of .IN I PFailreameter Accepted Values Description Providers SaveMSec 1 : Disable 2 : Enable 3 : Separate Column This setting specifies the default behavior for the provider when saving milliseconds. The default can be changed on the Advanced Settings in the Database Configuration Dialogs. Assembly Any string that contains a .Net Framework assembly Assembly option for all providers. The assembly has all the classes required to interface with the database.

Most of the providers are inside the System.Data assembly. ConnectionClass Any connection class inside the assembly The Connection Class is the one that implements the System.Data.IDbConnection interface. DateAdapterClass Any data adapter class inside the assembly The Data Adapter class is used on operations where updates to the database are necessary. It must be compatible with the connection class specified and it should implement IDbDataAdapter. CommandBuilderClass Any command builder class inside the assembly The Command Builder class is also responsible for updates on databases. It must be compatible with the connection class.

Provider Name of the provider One of the parameters in the connection string is the "Provider". The Studio ADO Gateway compares the value on the connection string with the value for this parameter in each provider and defines the proper one to be used.

ColumnDelimiterPrefix Any character or group of characters Specify a character that will be placed before column names on SQL statements ColumnDelimiterSuffix Any character or group of characters Specify a character that will be placed after column names on SQL statements TableDelimiterPrefix Any character or group of characters Specify a character that will be placed before table names on SQL statements TableDelimiterSuffix Any character or group of characters Specify a character that will be placed after table names on SQL statements ValueString Any string This value indicates how constant values are identified on SQL statements.

For Microsoft SQL databases for instance, the value should be @Value, for ODBC question mark (?) ValueStringPrefix Any string This value indicates a prefix to be used before the values. Oracle values, for instance, require the prefix. The SQL statements use value identifiers by using their prefixes, but the parameters in the Connection class do not use the prefix.