I had to upgrade to 5.0.9 recently so that the license I had just renewed could be taken into account.
Unfortunately, since this update, my reports have no longer been working.
The error displayed in my reports is the following :
Les requêtes hétérogènes requièrent les options ANSI_NULLS et ANSI_WARNINGS pour être définies pour la connexion. Cela assure la cohérence sémantique de la requête. Activez ces options et réexécutez la requête.
To sum it up, it says ANSI_NULLS and ANSI_WARNINGS options are not defined. But they are (and have been for several years). I defined them in the mydbr/user/defaults.php file, like this :
$mydbr_defaults['db_connection']['sql_server_init'] = 'SET ANSI_WARNINGS ON;SET ANSI_NULLS ON;SET QUOTED_IDENTIFIER OFF;';
It's always been working since I set it up a few years ago so the problem is likely to come from (one of) myDBR latest version(s).
Is there a reason why myDBR would no longer take into account the defaults.php file or would not longer take into account the instructions written inside?
Thanks in advance for your help.
PS: I can't say exactly which version of myDBR we ran before the upgrade but it was probably not very old (I upgrade it rather often because there's usually no problem when I do)