We recently started using the DSD SQL Mirror to speed up reporting and are very pleased so for with the results but I have run into a problem. I am attempting to move the slower reports in SAGE custom report menus over to the mirror and when I attempt to run it within SAGE it defaults back to the SOTAMAS90 DSN. i am assuming there is a trick to getting it to override the default. I already tried the "Converted to version 5.20" trick that I have used with custom reports that run off Access Db's. Is the solution to set up an access Db with passthroughs to all the mirrored tables? That seems kind of a clunky solution.
Thanks in advance this forum has always been very helpful!