Last post Sep 27, 2013 01:00 PM by MyItGuy
Sep 27, 2013 01:00 PM|MyItGuy|LINK
I'm writing a service that will run and generate reports on multiple servers. The CR templates currently use stored procedures through an ODBC connection to a common DB but for speed and scalabilty I want to replicate the required tables on each server and
execute the template against the individual servers local DB copy. Is this possible using a common template located on a network drive?
if I create identical ODBC datasources (same name but local DB) on each server would this work?
Thanks for any advice.