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 81. System DSN

System DSN

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

Figure 82. 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 83. Configure user ID and password

    Configure user ID and password

  • Configure the AppeonSampleForServer Database.

    Figure 84. Configure database

    Configure database

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

Figure 85. 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 86. 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 87. Configure Driver

    Configure Driver

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