| Error Code | Message | Probable Cause | Fix | | :--- | :--- | :--- | :--- | | | Driver's SQLAllocEnv failed | No Notes client installed OR environment variables missing ( Notes.ini not found) | Reinstall Notes client before driver; set PATH=%PATH%;C:\Lotus\Notes | | ODBC 8012 | Cannot access view 'All Documents' | The view selected in DSN mapping is public-read prohibited | Change the view access list or use a different view | | ODBC 8020 | Data truncated. Column 'Body' | Rich text exceeds driver's 255 char limit for SQL_VARCHAR | In Map Designer, change the column type to LONGCHAR or Memo | | Notes Error 0x13E | You are not authorized to access that database | The Notes ID used is locked (workstation mode) | Ensure Notes client is closed; run nclean.exe to release locks |
As of 2026, version 2.06 is extremely dated. While some legacy archives still host the files, HCL (the current owner of Domino) has moved toward newer HCL ODBC Drivers for Notes/Domino that support more modern security protocols like TLS 1.2. HCLSoftware Lotus NotesSQL ODBC Driver Download lotus notessql 2.06 driver
The NotesSQL 2.06 driver is a for organizations that still rely on archaic Lotus Notes applications . While it provides a vital link for data migration or simple reporting, it is generally outperformed by modern modernization tools or REST API-based connectors found in newer Domino versions. Rating: 3/5 Stars | Error Code | Message | Probable Cause
Legacy web applications or VB6/C++ programs can use the driver to read user profiles or document logs stored within Notes without utilizing the C API. Troubleshooting Known Issues HCLSoftware Lotus NotesSQL ODBC Driver Download The NotesSQL
NotesSQL is an driver. It presents the non-relational Notes data structure to the outside world as if it were a standard relational database. This allows developers and analysts to use standard SQL commands ( SELECT , INSERT , UPDATE ) to interact with Notes data without needing to learn the complex LotusScript or Notes API.
IBM officially ended support for Lotus NotesSQL in 2015, and HCL does not list it as a current product. However, the driver continues to function in many environments due to the stability of the Notes API. Two scenarios dictate its future: