DatabaseLink`
DatabaseLink`

SQLConnectionOpenQ

SQLConnectionOpenQ[conn]

tests whether or not conn is a valid connection object.

更多信息和选项

范例

打开所有单元关闭所有单元

基本范例  (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 in Using 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 a True result does not imply that queries may be issued on the connection. Use SQLConnectionUsableQ for this purpose:

Test the connection:

Since SQLConnectionUsableQ performs server communication, it will generally take longer than SQLConnectionOpenQ to evaluate:

Close the connection: