Error: SQLITE_CANTOPEN: unable to open the
Problem: when starting the USB
version of the Managed Switch Port Mapping Tool,
you see an immediate error that begins with this text:
Error Text: SQLITE_CANTOPEN: unable to open the
Source: spmap:InitInstance:opening or creating user
Switch Port Mapper Version: 2.xx
Why is this
happening? Your computer has protections
enabled to prevent writing to USB drives. This will most
likely occur on Windows 7, but it can occur on Windows
XP, Vista or 8.x.
Start / Run, enter regedit.exe then press OK.
When viewing the start icons
type regedit.exe, then click on it. WARNING: use the
registry editor with care. If you are not familiar with
using it, don't!
Locate the key:
Look for a value below that level named 'WriteProtect'.
If it has a DWORD value of '1', then the USB drive is
Read Only. Make it zero and you must reboot to allow
writing to the USB flash drive. If the key and value
does not exist, create it and make the DWORD value zero.
You may also consider creating or altering the same
WriteProtect value found under: