Supported characteristics of the Connector for OLE DB

The following table captures supported characteristics of the 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 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 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 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.