CLI Reference Guide

Using ODBCLink/SE With ODBC Applications ODBCLink/SE Reference Manual
ODBCLink/SE
42 ©M.B. Foster Associates Limited 1995-2000
Using Lotus 123 Release 5.0
To enable Lotus123 to use ODBC, you will have to add the following line to the file
\LOTUSAPP\DATALENS\LOTUS.BCF. (Note: The following information is summarized from the file
\123R5W\readme.txt):
DN=
@ODBC@ DL=@DLODBC@ DD=@All ODBC Sources@;
Once you have done this, you may access ODBC data sources.
⊗ Select Tools, Database, New Query, External, ODBC.
⊗ Select a data-source from the list box.
⊗ Select a table to query.
⊗ You can then choose fields to include in the query, set criteria, enter joins,
etc.