Provide the path to your notes.ini file (usually found in the Notes client directory or your user profile).
(Optional) Add a brief description of the source.
The driver is 32-bit only . It will not work with 64-bit ODBC Data Source Administrator out of the box. You must use the 32-bit version ( C:\Windows\SysWOW64\odbcad32.exe ).
: Leave blank if accessing a local file, or enter your Domino server name. Database : Browse to your .nsf file or enter its path. Username : Enter your Notes username. 4. Authentication & User ID Configuration
Lotus Notes uses a document-oriented architecture, which is inherently different from the rows and columns found in relational databases like SQL Server or Oracle. The NotesSQL driver acts as a translator, mapping Notes forms and views to relational tables so that IT professionals can integrate legacy collaborative data into modern business intelligence reports. Core Setup Requirements
To successfully install and configure version 2.06 (or its modern successors), your system generally requires: : Version 3.5 or later.
You can test the DSN using a simple VBScript, Python script, or SQL Server Linked Server setup. Here is a generic conceptual SQL query you would execute against the DSN:
If the goal is to access the Notes data from within a Microsoft SQL Server environment, the final step is to configure a linked server in MS SQL Server using the ODBC DSN that was just created.
For systems/drivers: Open C:\Windows\SysWOW64\odbcad32.exe
The NotesSQL 2.06 driver has specific dependencies that must be met for a successful installation. Because this is a legacy driver, compatibility mismatches are the most frequent cause of installation failure. 1. The Lotus Notes Client Dependency
The or code you are seeing during installation or DSN configuration Share public link
Leave blank if accessing a local file. Enter the server name if accessing a remote database.
After installation, open from the Start Menu. Then, browse to the notes.ini file (usually located in C:\Users\<USER_NAME>\AppData\Local\Lotus\Notes\Data ) in the provided text box. Next, click "Add user…", browse to the user.id file (located in the same folder), and finally, click "Save list" to close the dialog.
