Lotus Notessql 2.06 Driver
Installing the NotesSQL driver is straightforward, but subtle mistakes can lead to connection failures. Follow this guide carefully.
Even in its stable state, the 2.06 driver has quirks. Here are the most common issues: lotus notessql 2.06 driver
| Error Code | Message | Probable Cause | Fix |
| :--- | :--- | :--- | :--- |
| ODBC 8001 | 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 | | Notes Field Type | SQL Data Type | NotesSQL 2
string connString = "DSN=LotusNotesDSN;";
// or without DSN:
// string connString = "Driver=Lotus NotesSQL Driver (*.nsf);Server=;Database=C:\\path\\db.nsf;";
| Notes Field Type | SQL Data Type | NotesSQL 2.06 Mapping | |----------------|---------------|------------------------| | Text | VARCHAR (up to 64KB) | SQL_VARCHAR | | Number (float) | DOUBLE | SQL_DOUBLE | | Number (integer) | INTEGER | SQL_INTEGER | | Date/Time | TIMESTAMP | SQL_TIMESTAMP | | Rich Text | LONG VARCHAR | SQL_LONGVARCHAR | | Names | VARCHAR | SQL_VARCHAR | | Keywords | VARCHAR | SQL_VARCHAR | Installing the NotesSQL driver is straightforward