If you are trying to make a change or save some new data in Keywin 5 application, and you receive an error, there might be an issue that the application cannot find the SQL. An issue that has been happening to a lot of different applications running SQL 2012.
Something in the Microsift directory has changed and preventing the application and SQL to find the correct path. Go to C:\ProgramData\Creone AB\KeyWin 5 open the txt.file with todays date and see if you find an error that says this:
Unable to load DLL 'SqlServerSpatial110.dll':The specified module could not be found. (Exception from HRESULT: 0x8007007E)
There is a valid workaround for this, follow the steps below:
1. Go to C:\Program Files (x86)\Creone AB\KeyWin 5
2.Drag the file KeyWin.exe to the desktop, open with notepad
3. Copy the below code snippet:
<runtime><assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Microsoft.SqlServer.Types" publicKeyToken="89845dcd8080cc91" />
<bindingRedirect oldVersion="1.0.0.0-11.0.0.0" newVersion="10.0.0.0" />
</dependentAssembly>
</assemblyBinding></runtime>
4. Copy it below the appSettings row according to this image:
5. save the file, drag the file into the folder Keywin 5, restart Keywin.
You should now be able to save any information in Keywin 5 without any error.