Lotus Domino Designer 6.5 Help - Fields in the DECS Connection Document

LOTUS CONNECTORS

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

OLE DB Connection Document for DECS bmp

Connectivity Options

The Connectivity options are described below.

Field Description

Provider Specifies the programmatic ID. For this release, the choices are Access 2000 and SQL Server 7/2000.

Data Source Specifies the network name of the server running SQL Server 7/2000 or the path to the Access 2000 database (for example, "F:\Access\database.mdb") depending on which is 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 7/2000 database that you want to connect to. This field in not used with Access 2000 providers. 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 specified by the Init Datasource and Init Catalog properties.
If it is not set, Access 2000 or SQL Server 7/2000 server security is used. The Access 2000 or SQL Server 7/2000 server login and password are specified in the User Name and Password properties.

Access Privileges
(visible only if connecting to Access 2000) 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 Access 2000 or SQL Server 7/2000 server. Leave blank if using Windows NT Authentication.

Password Specifies the password associated with the user name above.

Selection Type Select Table/View to choose from a table or a SQL view for the type of metadata you want.
Select Procedure to choose from among stored procedures.
Spaces in a table or column name are not permitted.

Table/View Selection or Procedure Selection

The title of this set of options and the options themselves are dependent on what choice you made in "Selection Type." See the table above for more description.

Field Description

Owner Enables you to narrow the selection of data sources to a specific owner level. Click the arrow button to select from a list of owner names.

Name Specifies the name of the selected table, view, or procedure. Click the arrow button to select from a list of table, view, or procedure owner names.
Spaces in a table or column name are not permitted.

Column(s)
(or Parameter(s)) Lists the columns and corresponding data types from the selected table that you want to use as "metadata."
If "Procedure" was chosen as Selection Type, then this field is used to specify the parameters and corresponding data types for the selected procedures listed here.
Spaces in a table or column name are not permitted.

Glossary

Help on Help

Open Full Help Window

Glossary

Help on Help

Open Full Help Window

Field	Description
Provider	Specifies the programmatic ID. For this release, the choices are Access 2000 and SQL Server 7/2000.
Data Source	Specifies the network name of the server running SQL Server 7/2000 or the path to the Access 2000 database (for example, "F:\Access\database.mdb") depending on which is 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 7/2000 database that you want to connect to. This field in not used with Access 2000 providers. 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 specified by the Init Datasource and Init Catalog properties. If it is not set, Access 2000 or SQL Server 7/2000 server security is used. The Access 2000 or SQL Server 7/2000 server login and password are specified in the User Name and Password properties.
Access Privileges (visible only if connecting to Access 2000)	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 Access 2000 or SQL Server 7/2000 server. Leave blank if using Windows NT Authentication.
Password	Specifies the password associated with the user name above.
Selection Type	Select Table/View to choose from a table or a SQL view for the type of metadata you want. Select Procedure to choose from among stored procedures. Spaces in a table or column name are not permitted.

Field	Description
Owner	Enables you to narrow the selection of data sources to a specific owner level. Click the arrow button to select from a list of owner names.
Name	Specifies the name of the selected table, view, or procedure. Click the arrow button to select from a list of table, view, or procedure owner names. Spaces in a table or column name are not permitted.
Column(s) (or Parameter(s))	Lists the columns and corresponding data types from the selected table that you want to use as "metadata." If "Procedure" was chosen as Selection Type, then this field is used to specify the parameters and corresponding data types for the selected procedures listed here. Spaces in a table or column name are not permitted.