DatabaseLink`
DatabaseLink`

SQLConnection

SQLConnection[]

is an object that represents a connection to a data source.

Details and Options

  • To use SQLConnection, you first need to load DatabaseLink using Needs["DatabaseLink`"].
  • OpenSQLConnection and SQLConnections both return an SQLConnection object.
  • 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

Examples

Basic Examples  (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.

Create connections:

List connections:

This sets the ReadOnly option on one of the connections to True: