Page 1 of 1

version 8 and sqlite protocol

Posted: 31.10.2021, 10:30
by kjteng
I have just installed version 8.0 and have the following problem on all my existing program using ver 7.x.x
Unable to connect to database (message: requested database driver was not found)
Further test shows that "protocol = sqlite-3" is no longer valid in the new version (must use protocol=sqlite).
Will this change make any difference to my old code? Is there an easier way to change this (instead of opening
each project to change this property)?

Re: version 8 and sqlite protocol

Posted: 31.10.2021, 13:54
by marsupilami
Hello kjteng,

without changes there is no easier way. You could modify the sqlite driver to also publish the sqlite-3 protocol. But we announced this change some years ago during one of the releases for Zeos 7.2. We also introduced protocol names without version numbers in Zeos 7.2 to enable users to prepare for the transition.
Usually you will not need to change your old code. sqlite vs. sqlite-3 is just a different name for the same piece of code.

Best regards,

Jan

Re: version 8 and sqlite protocol

Posted: 01.11.2021, 10:33
by kjteng
Thanks for the info and reply.
So long as Protocol = sqlite can work, I think I can use grepwin to search and replace the protocal for all the lfm file.
Another thing I just encountered is that the old version automatically add AutoEncodeStrings = true to zconnection properties - this should be removed too?