Database Toolbox™

ping - Get status information about database connection

Syntax

ping(conn)

Description

ping(conn) returns status information about the database connection conn if the connection is open. It returns an error message otherwise.

Examples

Example 1 — Get Status Information About ODBC Connection

Check the status of the ODBC connection conn.

ping(conn)
ans = 
     DatabaseProductName: 'ACCESS'
  DatabaseProductVersion: '03.50.0000'
          JDBCDriverName: 'JDBC-ODBC Bridge (odbcjt32.dll)'
       JDBCDriverVersion: '1.1001 (04.00.4202)'
  MaxDatabaseConnections: 64
         CurrentUserName: 'admin'
             DatabaseURL: 'jdbc:odbc:SampleDB'
  AutoCommitTransactions: 'True'

Example 2 — Get Status Information About JDBC Connection

Check the status of the JDBC connection conn.

ping(conn)
ans = 
    DatabaseProductName: 'Oracle'
 DatabaseProductVersion: [1x166 char]
         JDBCDriverName: 'Oracle JDBC driver'
      JDBCDriverVersion: '7.3.4.0.2'
 MaxDatabaseConnections: 0
        CurrentUserName: 'scott'
            DatabaseURL: 'jdbc:oracle:thin: ...
	@144.212.123.24:1822:orcl'AutoCommitTransactions:'True'

Example 3 — Unsuccessful Request for Information About Connection

In this example, the database connection conn has been terminated or is not successful. Run:

ping(conn)
Cannot Ping the Database Connection