Topics

The LotusScript Data Object (LS:DO) provides full read and write access to external ODBC data sources using LotusScript. The LS:DO consists of a set of three classes -- ODBCConnection, ODBCQuery, ODBCResultSet -- that come complete with a powerful set of properties and methods and full SQL capabilities. LS:DO is easy to learn and use because its design is consistent with LotusScript's BASIC syntax and other LotusScript Notes classes.

Notes supports LS:DO on the following platforms: OS/2, Windows 3.1, Windows 95, Windows NT, AIX, and SPARC Solaris platforms. LS:DO is also on the AS/400 and OS/390 platforms. On these platforms, LS:DO is implemented using the native operating system enterprise integration not ODBC. Check the documentation on these platforms for detailed installation and implementation.

For information on using LS:DO, see Domino 5 Designer Help or Domino Designer Programming Guide Volume 2: LotusScript Classes.

Updates and additional troubleshooting information about LS:DO are available on the Lotus Developer Central Web site at http://www.lotus.com/devtools.

Also, please note the following new LS:DO feature:

Connection pooling

Connection Pooling allows a connection to a ODBC data source to be reused. When this feature is enabled, an LS:DO connection first checks to see if any connections with the same username and password are available in the connection pool. The user does not have to wait for a connection to take place if a connection is available on the pool.

A new NOTES.INI variable, ODBCConnectionPooling, has been added that enables LS:DO for use with the ODBC Driver Manager 3.x connection pooling feature. You enable this feature by setting ODBCConnectionPooling=1 on the machine where LS:DO is executed. This feature must also be enabled and configured for the ODBC Driver Manager via the ODBC Administrator. See the ODBC documentation for further details.