version 8 and sqlite protocol

The offical for ZeosLib 7.3 Report problems, ask for help, post proposals for the new version of Zeoslib 7.3/v8
Quick Info:
-We made two new drivers: odbc(raw and unicode version) and oledb
-GUID domain/field-defined support for FB
-extended error infos of Firebird
-performance ups are still in queue
In future some more feature will arrive, so stay tuned and don't hassitate to help
Post Reply
kjteng
Senior Boarder
Senior Boarder
Posts: 54
Joined: 10.05.2015, 15:02

version 8 and sqlite protocol

Post 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)?
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: version 8 and sqlite protocol

Post 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
kjteng
Senior Boarder
Senior Boarder
Posts: 54
Joined: 10.05.2015, 15:02

Re: version 8 and sqlite protocol

Post 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?
Post Reply