Lotus Domino Designer 8 Help - Fields in the LEI Connection Document

LOTUS CONNECTORS

Fields in the LEI Connection Document
See the following tables for descriptions of the LEI Connection Document fields.

Connectivity

The Connectivity options are described below.

OLE DB Connection Document connectivity options bmp

Field Description

Name Specifies a unique name that identifies this Connection. The maximum number of characters allowed is 255.

Provider Specifies the programmatic ID. The choices are SQL Server 2000 and 2005.

Data Source Specifies the network name of the server running the SQL Server database, based on the value specified in the Provider field. See the "Lotus Connector for OLE DB Operational Considerations" section for details.

Catalog Specifies the name of the SQL Server database that you want to connect to. See the "Lotus Connector for OLE DB Operational Considerations" section for details.

Provider String Specifies any required provider string values. SQLOLEDB recognizes an ODBC-like syntax in provider string property values. Within the string, elements are delimited by using a semicolon. The final element in the string must be terminated with a semicolon. Each element consists of a keyword, an equal sign character, and the value passed on initialization, for example:
Server=Gumby;UID=george;
You may need to set ‘network’ to the name of the Net-Library (DLL) used to communicate with the SQL server. The name should not include the path or the .dll file name extension. For example, to use the TCP/IP network library, add the following:
Network=DBMSSOCN;
Alternatively, the default Net-Library can be set by the SQL Server Client Network Utility.

Authentication Service If this property is set to "SSPI", SQLOLEDB uses Windows NT Authentication Mode to authorize user access to the SQL server database.
If it is not set, SQL Server security is used. The SQL Server login and password are specified in the User Name and Password properties.

Access Privileges Specifies user access to the database. The choices are as follows.

Read Only
Read/Write
Exclusive Read
Only Exclusive Read/Write

User Name Specifies the user name required to log in to the SQL Server. Leave blank if using Windows NT Authentication.
Note If you do not specify a user name and password in the Connection Document, the Connector will attempt to use the NT user name and password of the account logged in on your LEI server. If that user does not have an account in SQL server, an error message will appear.

Password Specifies the password associated with the user name above. Leave blank if using Windows NT Authentication.
Password encryption is described in the "Introduction to Lotus Connectors" chapter.

Connection Options

The Connection Options section provides options for managing data transactions, creating tables, and logging SQL commands. These settings have no effect on Advanced RealTime activities.

Transaction Options
When you select the Transaction Options tab, the following options appear. The Transaction Options apply to operations that create, modify, or delete data.

OLE DB Connection Document transaction options bmp

Field Description

Commit Frequency Indicates how often to commit a transaction. If set to 1, all actions are immediately committed. If set to 0 (zero), actions are committed at disconnect. Set this option to 1 for Replication activities.

Isolation level Determines the extent that outside actions can affect a transaction. The options are as follows:

Read Uncommitted: A transaction operating at the Read Uncommitted level can see uncommitted changes made by other transactions. At this level of isolation, dirty reads, non-repeatable reads, and phantoms are all possible.
Read Committed: A transaction operating at the Read Committed level cannot see changes made by other transactions until those transactions are committed. At this level of isolation, dirty reads are not possible but non-repeatable reads and phantoms are possible.
Repeatable Read: A transaction operating at the Repeatable Read level is guaranteed not to see any changes made by other transactions in values it has already read. At this level of isolation, dirty reads and nonrepeatable reads are not possible but phantoms are possible.
Serializable: A transaction operating at this level guarantees that all concurrent transactions interact only in ways that produce the same effect: as if each transaction were entirely executed one after the other. At this isolation level, dirty reads, nonrepeatable reads, and phantoms are not possible.

Logging Options
When you select the Logging Options tab, the following options appear. The Logging Options section provides a feature for including SQL statements in the activity log.

OLE DB Connection Document logging options bmp

Field Description

Output SQL Statements to Log Select this option to include in the activity log all SQL statements generated during processing of the activity.
Note Selecting this option slows down performance. Use it only for troubleshooting.

Selection Type

Regardless of which Options tab you select, the following option is available.

OLE DB Connection Document selection type options bmp

Field Description

Selection Type Enables you to specify the metadata type for a connection.

Select Table to connect to an OLE DB table.
Select View to connect to an OLE DB view.
Select Procedure to connect to an OLE DB stored procedure.
Spaces in a table or column name are not permitted.

Table Options

These settings display a current list of tables and allow you to specify which tables will be accessed and how. You can also specify a table name not shown in the list by selecting the Manual button.

OLE DB Connection Document table options bmp

Field Description

Owner Lists the available owner names for the above table, view, or procedure selection type in the specified Database.
A selection list displays all OLE DB owners. Choose the owner of the table, view, or procedure being connected to from the list (Optional).

Name Lists the available table, view, or procedure names defined for the specified Owner.
Click the down-arrow button to select from the list of available tables, views, or procedures.
A selection list displays all OLE DB tables, views, or procedures for the selected Owner. Choose the table, view, or procedure to connect to.
If an owner is not specified, all names are listed for the specified Selection Type.
Spaces in a table or column name are not permitted.

Column Lists the columns or parameters (stored procedure) defined for the specified Name.
Spaces in a table or column name are not permitted.

Glossary

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Glossary

Field	Description
Name	Specifies a unique name that identifies this Connection. The maximum number of characters allowed is 255.
Provider	Specifies the programmatic ID. The choices are SQL Server 2000 and 2005.
Data Source	Specifies the network name of the server running the SQL Server database, based on the value specified in the Provider field. See the "Lotus Connector for OLE DB Operational Considerations" section for details.
Catalog	Specifies the name of the SQL Server database that you want to connect to. See the "Lotus Connector for OLE DB Operational Considerations" section for details.
Provider String	Specifies any required provider string values. SQLOLEDB recognizes an ODBC-like syntax in provider string property values. Within the string, elements are delimited by using a semicolon. The final element in the string must be terminated with a semicolon. Each element consists of a keyword, an equal sign character, and the value passed on initialization, for example: Server=Gumby;UID=george; You may need to set ‘network’ to the name of the Net-Library (DLL) used to communicate with the SQL server. The name should not include the path or the .dll file name extension. For example, to use the TCP/IP network library, add the following: Network=DBMSSOCN; Alternatively, the default Net-Library can be set by the SQL Server Client Network Utility.
Authentication Service	If this property is set to "SSPI", SQLOLEDB uses Windows NT Authentication Mode to authorize user access to the SQL server database. If it is not set, SQL Server security is used. The SQL Server login and password are specified in the User Name and Password properties.
Access Privileges	Specifies user access to the database. The choices are as follows. Read Only Read/Write Exclusive Read Only Exclusive Read/Write
User Name	Specifies the user name required to log in to the SQL Server. Leave blank if using Windows NT Authentication. Note If you do not specify a user name and password in the Connection Document, the Connector will attempt to use the NT user name and password of the account logged in on your LEI server. If that user does not have an account in SQL server, an error message will appear.
Password	Specifies the password associated with the user name above. Leave blank if using Windows NT Authentication. Password encryption is described in the "Introduction to Lotus Connectors" chapter.

Field	Description
Commit Frequency	Indicates how often to commit a transaction. If set to 1, all actions are immediately committed. If set to 0 (zero), actions are committed at disconnect. Set this option to 1 for Replication activities.
Isolation level	Determines the extent that outside actions can affect a transaction. The options are as follows: Read Uncommitted: A transaction operating at the Read Uncommitted level can see uncommitted changes made by other transactions. At this level of isolation, dirty reads, non-repeatable reads, and phantoms are all possible. Read Committed: A transaction operating at the Read Committed level cannot see changes made by other transactions until those transactions are committed. At this level of isolation, dirty reads are not possible but non-repeatable reads and phantoms are possible. Repeatable Read: A transaction operating at the Repeatable Read level is guaranteed not to see any changes made by other transactions in values it has already read. At this level of isolation, dirty reads and nonrepeatable reads are not possible but phantoms are possible. Serializable: A transaction operating at this level guarantees that all concurrent transactions interact only in ways that produce the same effect: as if each transaction were entirely executed one after the other. At this isolation level, dirty reads, nonrepeatable reads, and phantoms are not possible.

Field	Description
Output SQL Statements to Log	Select this option to include in the activity log all SQL statements generated during processing of the activity. Note Selecting this option slows down performance. Use it only for troubleshooting.

Field	Description
Selection Type	Enables you to specify the metadata type for a connection. Select Table to connect to an OLE DB table. Select View to connect to an OLE DB view. Select Procedure to connect to an OLE DB stored procedure. Spaces in a table or column name are not permitted.

Field	Description
Owner	Lists the available owner names for the above table, view, or procedure selection type in the specified Database. A selection list displays all OLE DB owners. Choose the owner of the table, view, or procedure being connected to from the list (Optional).
Name	Lists the available table, view, or procedure names defined for the specified Owner. Click the down-arrow button to select from the list of available tables, views, or procedures. A selection list displays all OLE DB tables, views, or procedures for the selected Owner. Choose the table, view, or procedure to connect to. If an owner is not specified, all names are listed for the specified Selection Type. Spaces in a table or column name are not permitted.
Column	Lists the columns or parameters (stored procedure) defined for the specified Name. Spaces in a table or column name are not permitted.