DatabaseLink`
DatabaseLink`
SQLConnection
is an object that represents a connection to a data source.
更多信息和选项
- 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" Automatic set the catalog for the connection "ReadOnly" Automatic set the connection to be read only "TransactionIsolationLevel" Automatic set transaction isolation for the connection
范例
基本范例 (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.
This sets the ReadOnly option on one of the connections to True: