Creating a New Project manually, you can press the browse button (…) and select the database type from the Data Link Properties window. Data Link Properties dialog Note: The list of Database Providers shown in the Data Link Properties window depends on the providers actually installed and available in the computer where you are running IWS. Consult the operating system documentation (or the database documentation) for further information regarding the settings of the Provider for the database that you are using. • User name field: User name used to connect to the database. The user name configured in this field must match the user name configured in the database. • Password field:
Password used to connect to the database. The password configured in this field must match the password configured in the database. • Retry Interval field: If IWS is unable to connect to the database for any reason, it retries automatically to connect to the database after the number of seconds configured in this field have passed. • Advanced button: After pressing this button, you have access to customize some settings. For most projects, the default value of these settings do not need to be modified and should be kept. Database Configuration: Advanced dialog • Milliseconds combo box: You can configure how the milliseconds will be saved when saving the date in the database.
Each database saves the date in different formats; for example, some databases do not support milliseconds in a Date field. The following options are available: • Default : Uses the format pre-defined for the current database. The databases previously tested by InduSoft are previously configured with the most suitable option. When selecting Default, IWS uses the setting pre-configured for the current database type. If you are using a database that has not been previously configured, the Default option attempts to save the milliseconds in a separate field. Tip: The default option for each database is configured in the StADOSvr.ini file, stored in the \BIN sub-folder of IWS.
See Studio Database Gateway for information about how to configure the StADOSvr.ini file. • Disable : Does not save the milliseconds at all when saving the date in the database. Page 80 InduSoft Web Studio