ping (Database Toolbox User's Guide)

ping	Examples See Also

Get information about database connection

Syntax

ping(conn)

Description

ping(conn)

returns the status of the database connection, conn. If the connection is open, ping returns information about the connection.

Examples

Example 1 - Get information about ODBC connection

connA is a valid ODBC connection:

ping(connA)

Database Product Name     : ACCESS
Database Product Version  : 3.0
JDBC Driver Name          : JDBC-ODBC Bridge (odbcjt32.dll)
JDBC Driver Version       : 1.1001 (3.40.2829)
Max. Database Connections : 64
Current User Name         : admin
Database URL              : jdbc:odbc:SampleDB
Auto Commit Transactions  : True

Example 2 - Get information about JDBC connection

connection is a valid JDBC connection:

ping(connection)

Database Product Name     : Oracle
Database Product Version  : Oracle7 Server Release 7.3.3.0.0 - 
                             Production Release With the
                             distributed, replication, parallel
                             query and Spatial Data options PL/SQL
                             Release 2.3.3.0.0 - Production
JDBC Driver Name          : Oracle JDBC driver
JDBC Driver Version       : 7.3.3.1.3
Max. Database Connections : 0
Current User Name         : scott
Database URL              : jdbc:oracle:oci7:
Auto Commit Transactions  : True

Example 3 - Unsuccessful request for information about connection

connB has been terminated or was not successful:

ping(connB)

Cannot Ping the Database Connection