I am running an internal cold fusion site in our office. It uses MySQL as the backend. I have created some spreadsheets that do queries on this database, and I would like every station to be able to do the same. However, the only way this works (AFAIK) is that you have to install MyODBC on every workstation and add a Data Source for it on, also on every workstation.
Is that true? And if so, is there a way to deploy MyODBC and add a DSN to every workstation in the AD?