Named Connections

If your work requires that you frequently connect to the same database it might be beneficial to give this connection a name and use the name in OpenSQLConnection. The details of how to set up a named connection are given in the Database Resources section. This section describes how to learn what named connections are available.

This loads the package.

In[1]:=

The following lists all the named connections. If you have installed more connections you may see a larger list.

In[2]:=

Out[2]=

You can get more complete information on all of connections by using DataSources.

In[4]:=

Out[4]=

You can get information on just one named connection by giving a name argument to DataSources.

In[5]:=

Out[5]=

This is the most verbose form of OpenSQLConnection. Typically, you would want to use information that had been stored previously. This is discussed in the Database Resources section.