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
- To use SQLConnectionInformation, you first need to load DatabaseLink using Needs["DatabaseLink`"].
Examples
Basic Examples (1)
| In[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:
| In[4]:= |
Display the connection information in a table:
| In[6]:= |
See Also
SQLConnectionOpenQ SQLConnectionUsableQ OpenSQLConnection CloseSQLConnection SQLConnections SQLConnection SQLConnectionPools SQLConnectionPool