When pinging the appeonsample data source, no connection is made.
Cause: Ping of appeonsample fails because the data source is not established correctly.
Solution: Follow the steps below to fix the problem.
Step 1: Verify that the AppeonSampleForServer system DSN exists in the ODBC Data Source Administrator (Windows Control Panel > Administrative Tools > Data Sources (ODBC)).
Select Configure, and click Test Connection on the ODBC tab to check AppeonSampleForServer connectivity.
If the Appeondb data source does not exist or the connection test fails, try to manually add/configure the data source.
-
Configure the Appeondb Login (User ID: dba; Password: sql).
Step 2: Verify that the appeonsample data source exists in EAServer Manager.
Right-click the appeonsample data source and select "Properties" to open the Connection Cache Properties window.
-
Check the configuration in the General tab (Server Name: jdbc:odbc:AppeonSampleForServer; User Name: dba; Password: sql).
-
Check configuration in the Driver tab, and verify that the same settings are used. Select JDBC and specify the driver string as "sun.jdbc.odbc.JdbcOdbcDriver".
Step 3: Right-click the appeonsample data source in EAServer Manager and select "Ping" to test the database connection again.
