data between disparate systems without needing to write complex LotusScript or Java agents. The Technical Hurdle
| Component | Requirement | |-----------|-------------| | | Windows 2000, XP, Server 2003, Vista, Server 2008 (also functional on Windows 7/10 32-bit; limited 64-bit via SysWOW64) | | Lotus Notes Client | Notes 6.5, 7.0, or 8.0.x (32-bit) | | ODBC Manager | Microsoft ODBC Data Source Administrator (32-bit) | | Architecture | Primarily 32-bit driver. No native 64-bit version exists. | | Disk Space | ~15 MB | lotus notessql 2.06 driver download
Unlike a traditional SQL database, Lotus Notes is "schema-less." Each document in a database could theoretically have different fields. The NotesSQL driver had to perform a "mapping" act, essentially pretending that the Notes forms and views were tables and the documents were rows. data between disparate systems without needing to write