Contents Index Microsoft FoxPro (Microsoft 3.51.171300) Using Procedures, Triggers, and Batches

ASA SQL User's Guide
  Server Classes for Remote Data Access
    ODBC-based server classes
      Server class odbc

Lotus Notes SQL 2.0

You can obtain this driver (version 2.04.0203) from the Lotus Web site. Read the documentation that comes with it for an explanation of how Notes data maps to relational tables. You can easily map Adaptive Server Anywhere tables to Notes forms.

Here is how to set up Adaptive Server Anywhere to access the Address sample file.

Avoiding password prompts 

Lotus Notes does not support sending a user name and password through the ODBC API. If you try to access Lotus notes using a password protected ID, a window appears on the machine where Adaptive Server Anywhere is running, and prompts you for a password. Avoid this behavior in multi-user server environments.

To access Lotus Notes unattended, without ever receiving a password prompt, you must use a non-password-protected ID. You can remove password protection from your ID by clearing it (File > Tools > User ID > Clear Password), unless your Domino administrator required a password when your ID was created. In this case, you will not be able to clear it.


Contents Index Microsoft FoxPro (Microsoft 3.51.171300) Using Procedures, Triggers, and Batches