Assuming you have the NotesSQL 2.06 driver installed and an ODBC DSN (e.g., LotusNotesDSN ) pointing to an .nsf file.
| 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 | lotus notessql 2.06 driver
SELECT * FROM "FusionLogs" WHERE Year = 2003 AND CoreTemp > 3000 Assuming you have the NotesSQL 2
Most versions of Lotus NotesSQL, including legacy releases, are . This leads to two common hurdles: This leads to two common hurdles: string connString
string connString = "DSN=LotusNotesDSN;"; // or without DSN: // string connString = "Driver=Lotus NotesSQL Driver (*.nsf);Server=;Database=C:\\path\\db.nsf;";
Some code never dies. It just waits for someone with a VM and a forgotten password.