Supported characteristics of the Connector for OLE DB

The following table captures supported characteristics of the Lotus® Connector for OLE DB.

For a definition of the terms used in this section, see "Supported Connector Characteristics -- List of Terms" in Chapter 3 of this manual. If you are accessing the connector using LotusScript®, see the Lotus® Connector LotusScript® Extensions Guide for more information.

  • Writeback support -- Depending on the OLE DB provider, writeback support is not always available. If it is not available, it will be simulated by the Lotus® Connector for OLE DB using keyed operations. Make sure that the proper key settings and values are provided even when performing writeback update and remove operations.
  • Writeback index -- Index required for SQL server. Use the command "create index <indexname> on <tablename> (<column1>, <column2>, ..., <columnN>)".
  • Statement syntax -- Dependent on the OLE DB Provider. For Microsoft™ SQL server Full Transact-SQL syntax is supported, including stored procedures.
  • Condition syntax -- Valid when placed in the following SQL statement: SELECT ... WHERE <condition> ORDER BY
  • Array transfer -- None
  • Actions supported -- Clear, Reset, Truncate, Commit, Rollback
  • Catalog types -- Database, Metadata, Index, Field, Procedure, Parameter
  • Create types -- Metadata, Index
  • Drop types -- Metadata, Index
Note: The Database Catalog type requires a valid connection. If you attempt to use this data type without a valid connection, you will receive an error message.

All connections have a set of properties with values that can be assigned and retrieved. See the Lotus® Connector LotusScript® Extensions Guide for a list of supported properties for each Connector. Also see the "Common Connector Properties" and "LCConnection Properties" sections in the LCConnection Class chapter of that same manual.