I'm having the same problems on Libreelec 10, all other Kodi installs on Windows, Mac and Android are working fine.
I'm using DNS names for my shares and SQL database (no chance to change that easily).
I've been reading that SMB got an updates in Libreelec 10 and using the IP address might solve the issue.