Notes SQL not working in Notes 9

HCL Domino Domino Forum
1

Notes SQL is not working when using Notes 9 - after reinstall to 8.5.3 everything works as normal.

Any hits / tips / fixes?

2

Subject: RE: Notes SQL not working in Notes 9

Thanks alot - the workaround worked for me!

3

Subject: RE: Notes SQL not working in Notes 9

Many thanks for this tip!
This worked for me.

Alex

4

Subject: maybe a work around

If you still have some problems, please feel free to contact me.

edit 90.reg, change “Path” to your Notes directory, then import reg to registry.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Lotus\Notes\8.0]
“DataPath”=“”
“Description”=“IBM Notes”
“Name”=“IBM Notes.exe”
“Path”=“C:\Program Files\IBM\Notes\”
“Version”=“080000”
“ShortcutCreation”=“false”
“MultiUser”=dword:00000001

if still not work, see details below:

work around here:

1, (optional)uninstall NotesSQL 853(In my computer(winxp 32bit), uninstall is not necessary.)
2, install Notes90 if needed.
3, run “regedit”, find key

[HKEY_LOCAL_MACHINE\SOFTWARE\Lotus\Notes\9.0]
or [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Lotus\Notes] (Notes90 on Win7 64bit)

4, export all keys in this directory to 90.reg, see below.

5, edit 90.reg, change [HKEY_LOCAL_MACHINE\SOFTWARE\Lotus\Notes\9.0] to [HKEY_LOCAL_MACHINE\SOFTWARE\Lotus\Notes\8.0],
and change “Version”=“090000” to “Version”=“080503”.
6, import 90.reg.
7, after import, you will see [HKEY_LOCAL_MACHINE\SOFTWARE\Lotus\Notes\8.0] added.
8, (optional)install NotesSQL853.

tips:
1, after install Notes90/Domino90, configure it first, and make sure notes.ini being created.
2, if still come across errors, please uninstall NotesSQL and install again.
3, not sure if add registry keys had some impact on other software, so if any other error, delete them.