To obtain this driver, go to the Lotus web site at http://www.lotus.com/. 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:
CREATE SERVER names CLASS 'odbc' USING 'my_notes_dsn'; |
Map the Person form into a SQL Anywhere table:
CREATE EXISTING TABLE Person AT 'names...Person'; |
Query the table:
SELECT * FROM Person; |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |