DatabaseLink SQL Operations >

SQLConnection

SQLConnection[...]
is an object that represents a connection to a data source.
  • The following options can be modified in an SQLConnection object:
"Catalog"Automaticset the catalog for the connection
"ReadOnly"Automaticset the connection to be read only
"TransactionIsolationLevel"Automaticset transaction isolation for the connection
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 package, as described in .
Create connections:
List connections:
This sets the option on one of the connections to True.
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 package, as described in Using the Example Databases.
Create connections:
In[2]:=
Click for copyable input
Out[2]=
In[3]:=
Click for copyable input
Out[3]=
List connections:
In[4]:=
Click for copyable input
Out[4]=
This sets the option on one of the connections to True.
In[5]:=
Click for copyable input
Out[5]=
In[6]:=
Click for copyable input
In[7]:=
Click for copyable input
Ask a question about this page  |  Suggest an improvement  |  Leave a message for the team