SQLConnectionInformation
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)
Needs["DatabaseLink`"]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:
conn = OpenSQLConnection["demo"]Retrieve the value of a specific connection property:
SQLConnectionInformation[conn, "DatabaseProductName"]Retrieve all information about the connection:
data = SQLConnectionInformation[conn];Display the connection information in a table:
TableForm[Transpose[data]]CloseSQLConnection[conn];