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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Remote data access » Server classes for remote data access » Server class ODBC


Lotus Notes SQL

To obtain this driver, go to the Lotus NotesSQL web site at [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 your Lotus Notes contacts.

  • Make sure that the Lotus Notes program folder is in your path (for example, C:\Program Files (x86)\IBM\Lotus\Notes).

  • Create a 32-bit ODBC data source using the NotesSQL ODBC driver. Use the names.nsf database for this example. The Map Special Characters option should be turned on. For this example, the Data Source Name is my_notes_dsn.

  • Create a remote data access server using Interactive SQL connected to a 32-bit database server. Here is an example:

    CREATE SERVER NotesContacts
    USING 'my_notes_dsn';
  • Create an external login for the Lotus Notes server. Here is an example:

    CREATE EXTERNLOGIN "DBA" TO "NotesContacts" 
  • Map some columns of the Person form into a SQL Anywhere table:

    ( DisplayName CHAR(254), 
      DisplayMailAddress CHAR(254),
      JobTitle CHAR(254),
      CompanyName CHAR(254),
      Department CHAR(254),
      Location CHAR(254),
      OfficePhoneNumber CHAR(254) )
    AT 'NotesContacts...Person';
  • Query the table:

    SELECT * FROM PersonDetails
    WHERE Location LIKE 'Waterloo%';