Fail to ping appeonsample data source

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)).

Figure 77. System DSN

System DSN

Select Configure, and click Test Connection on the ODBC tab to check AppeonSampleForServer connectivity.

Figure 78. Check the data source

Check the data source

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).

    Figure 79. Configure user ID and password

    Configure user ID and password

  • Configure the AppeonSampleForServer Database.

    Figure 80. Configure database

    Configure database

Step 2: Verify that the appeonsample data source exists in EAServer Manager.

Figure 81. Select Properties

Select Properties

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).

    Figure 82. Configure general information

    Configure general information

  • 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".

    Figure 83. Configure Driver

    Configure Driver

Step 3: Right-click the appeonsample data source in EAServer Manager and select "Ping" to test the database connection again.