If you are having trouble retrieving SQL data from your relational database, use the following guidelines to help you determine the cause of the problem:
Install and configure a JDBC driver for your relational database, if you have not done so. The SQL connector communicates with most relational databases using a JDBC driver. For more information about installing a JDBC driver, refer to your JDBC driver documentation. To learn how to configure a JDBC driver on the Proficy Portal server, refer to the section JDBC Drivers.
Make sure you do not have two versions of the same JDBC driver installed. If you recently installed a new version and did not uninstall the old version, this may be causing some communication problems. To determine how to uninstall the old version of the driver, refer to your JDBC driver documentation.
Verify that the data source configuration for the relational database you are communicating with is correct. If it is incorrect, make the necessary changes. For more information on examining and modifying a data source configuration, refer to the section Adding Data Sources.
