|
SOLUTIONS
|
DATABASELINK SYMBOL
OpenSQLConnection
OpenSQLConnection[src]
makes a connection to a data source.
OpenSQLConnection[]
opens a GUI that helps to make a connection to a data source.
DetailsDetails
- To use OpenSQLConnection, you first need to load DatabaseLink using Needs["DatabaseLink`"].
- The following options can be given:
-
"Description" "" textual description of the connection "Location" "" location of the file that defines the connection "Name" "" name of the connection "Password" "" password to use for connecting "RelativePath" False whether the connection data contains a relative path "Timeout" None the timeout for the query "Username" "" username to use for connecting "Version" None version of the configuration file "Catalog" Automatic location of the database catalog "ReadOnly" Automatic set the connection to be read only "TransactionIsolationLevel" Automatic set transaction isolation for the connection
ExamplesExamplesopen allclose all
Basic Examples (1)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
package, as described in Using the Example Databases.
| In[2]:= |
| Out[2]= |
| In[3]:= |
This uses JDBC:
| In[4]:= |
| Out[4]= |
| In[5]:= |
| In[6]:= |
| Out[6]= |
| In[7]:= |
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.
Mathematica 9 is now available!
New to Mathematica?
Find your learning path »
Have a question?
Ask support »

