The Lotus NotesSQL driver is a 32-bit ODBC driver designed to enable third-party applications—such as Microsoft Excel, Access, SQL Server, and custom reporting tools—to treat Lotus Notes NSF files as relational databases.
Open Windows > Advanced System Settings > Environment Variables . Under System Variables , locate and edit the Path variable. lotus notessql 2.06 driver
while (reader.Read())
using System.Data.Odbc;
NotesSQL drivers (including 2.06) are inherently 32-bit only . If you are running a 64-bit Windows OS, you must use the 32-bit ODBC Administrator located at C:\Windows\SysWOW64\odbcad32.exe to configure the DSN. The Lotus NotesSQL driver is a 32-bit ODBC
The Lotus NotesSQL driver, including the 2.06 version, is only available in 32-bit. While it can be used on 64-bit Windows platforms, it can only be used by 32-bit applications. including the 2.06 version