SQLConnectionOpenQ

SQLConnectionOpenQ[conn]

tests whether or notconn is a valid connection object.

Details and Options

To useSQLConnectionOpenQ, you first need to loadDatabaseLink usingNeeds["DatabaseLink`"].
SQLConnectionOpenQ is strictly a client-side test and initiates no communication with the connection's target server, local or remote.

Examples

open allclose all

Basic Examples (1)

If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the"DatabaseLink`DatabaseExamples`" package, as described inUsing the Example Databases.

Open a connection to a sample database:

Test the connection's validity:

Close the connection:

Test the connection's validity again:

Properties & Relations (1)

SQLConnectionOpenQ initiates no server communication, so aTrue result does not imply that queries may be issued on the connection. UseSQLConnectionUsableQ for this purpose:

Test the connection:

SinceSQLConnectionUsableQ performs server communication, it will generally take longer thanSQLConnectionOpenQ to evaluate:

Close the connection: