I downloaded the demo version (2.2.6) of FactorySQL to evaluate it, and ran into serious problems. After some troubleshooting I think that I have found the source of my problem. It has to do with localized number format settings in Windows. I got this error all the time with the first server i tried:
“Error executing update query: ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.”
Nothing got written to the database, obviously. I’m using Microsoft SQL Server 2005. I first thought that I had configured it in a bad way, but then I realized that it could be the fact that I use Swedish locale in Windows while trying to log floats. The decimal separator in Sweden is ‘ , ‘ (comma) not ‘ . ‘ (dot). My guess is that the way FactorySQL updates the database doesn’t consider this. Let’s say I have the value 2,5 (that is, 2.5 in “English”) my guess is that it gets interpreted as the values 2 and 5, leading to the error above. The OPC servers returns floats according to the format set up in Windows and there is nothing I can do about that except change my locale to English. That is not really a good option. It would be better if this could be solved in the actual software if it really is what’s causing this.
When trying with integers, strings and dates everything works fine.
The second bug (kind of) was found when installing the demo on my co-workers machine. When starting the frontend we get this:
Necessary DLL Missing
Unable to start FactorySQL, as a necessary DLL was not found. You may need to reinstall FactorySQL, if the DLL cannot be added manually. The following line may indicate the missing file:
Det gick inte att ladda DLL-filen (sqlite3).
The last line translates to “Unable to load DLL-file (sqlite3)”. The file is where it should be and has correct access rights. The same installation package installs correctly on other machines. The “bug” is IMHO that the installer somehow fails to install/register the DLL correctly, without giving any error messages during the installation. Right now we have 2 running installations out of 4 attempts. Both failed installations gives the above message. This is not very reliable, is it? All installations were done with administrative access.
The compability issue we have is with " Beijer Electronics OPC Server ". Other installed servers works just fine (on the sucessfull installations and apart from the comma-bug). FactorySQL cannot connect to Beijer or browse it. Other apps like Matrikon OPC Explorer have no issues. The security settings on all installed servers are identical, and we have tried to set Authentication level to “none” as mentioned in other posts. Any ideas?
The software looks promising, but has some issues that we need answers to before we can buy it. If we are going to deploy it on our customers systems, we want to make sure that we don’t get DLL errors on random machines for example. Thanks in advance for your answers