Database Toolbox

ping

Get status information about database connection

Syntax

• ping(conn)
  

Description

ping(conn) returns the status information about the database connection, conn. If the connection is open, ping returns status information and otherwise it returns an error message.

Examples

Example 1--Get Status Information About ODBC Connection

Type

• ping(conn)
  

where conn is a valid ODBC connection. MATLAB returns

• 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

Type

• ping(conn)
  

where conn is a valid JDBC connection.

MATLAB returns

• 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

Type

• ping(conn)
  

where the database connection conn has been terminated or was not successful. MATLAB returns

• Cannot Ping the Database Connection
  

See Also
database, dmd, get, isconnection, set, supports

namecolumn

primarykeys