DatabaseLink`
DatabaseLink`

SQLConnectionInformation

SQLConnectionInformation[conn]

returns a list of information about the SQL connection conn.

SQLConnectionInformation[conn,property]

retrieves the value of property.

SQLConnectionInformation[conn,{p1,p2,}]

retrieves the properties pi.

Details and Options

  • To use SQLConnectionInformation, you first need to load DatabaseLink using Needs["DatabaseLink`"].

Examples

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 in Using the Example Databases.

Open a connection to a sample database:

Retrieve the value of a specific connection property:

Retrieve all information about the connection:

Display the connection information in a table:

Close the connection: