Use the following guidelines to troubleshoot your CIMPLICITY Logger connections if you experience difficulty accessing process data:
Verify that the database computer name (or Database URL), user name, and password are correct. In Windows, try configuring an ODBC data source to connect to the database computer.
Try to configure a Relational SQL data source to connect to the CIMPLICITY logger database. If the connection to a Relational SQL data source is successful, when you configure the CIMPLICITY HMI Logger connector, choose the Advanced configuration option and use the same database URL that you used for the Relational SQL data source. See Verifying Relational Database Connections for additional information.
Look at the Data Source diagnostics for the connector. Refer to Data Sources Diagnostics.
TIP: When you are looking at the diagnostic parameters, you can click on the parameter field and select the entire row. Use Ctrl+C on the keyboard to copy the data and paste it into a text editor such as Wordpad. Do not use Notepad - it will not display the line breaks correctly.
Confirm that the Database Overview parameter matches what you expect the database computer to be.
Examine the Table Overview parameter and make sure you see the correct list of tables. If you do not, you may be set up in the wrong database. Confirm that the `DatabaseName=' parameter in the Database URL is correct.
If you are receiving the error "Error converting data type varchar to float.Error Code:8114", the cause may be that you have a string valued point, but you did not clear the As Numeric column in the Edit Source dialog box (when setting the data source for an object).