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.33.
                              228:1521:orcl'
    AutoCommitTransactions: 'True'

Example 3 - Unsuccessful Request for Information About Connection

Type

ping(conn)

where 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