Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Usage » Remote Data and Bulk Operations » Server classes for remote data access » ODBC-based server classes » Server class odbc


Lotus Notes SQL 2.0

You can obtain this driver from the Lotus web site, [external link] Read the documentation that is included with it for an explanation of how Notes data maps to relational tables. You can easily map SQL Anywhere tables to Notes forms.

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

  • Create an ODBC data source using the NotesSQL driver. The database will be the sample names file: c:\notes\data\names.nsf. The Map Special Characters option should be turned on. For this example, the Data Source Name is my_notes_dsn.

  • Create a server in SQL Anywhere:

    CLASS 'odbc'
    USING 'my_notes_dsn';
  • Map the Person form into a SQL Anywhere table:

    AT 'names...Person';
  • Query the table

    SELECT * FROM Person;
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 computer where SQL 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 (choose 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.