There are some limitations in using an MSI, it all depends on your SQL authentication model, if you are using Windows Authentication MSI's should be OK, problems arise when you have to specify usernames and passwords. ________________________________ From: gptalk-bounce@xxxxxxxxxxxxx [mailto:gptalk-bounce@xxxxxxxxxxxxx] On Behalf Of Brian Cline Sent: 12 June 2007 02:10 To: gptalk@xxxxxxxxxxxxx Subject: [gptalk] Re: Deploy ODBC via Group Policy I'm not sure if there's a way to do this via a script or other method, but there are some utilities out there that will create an MSI that creates ODBC DSNs. Advanced Installer (www.advancedinstaller.com) is one of them. The ODBC portion is part of the "professional" edition feature set, which means some $$$, but a fully functional 30-day trial is available. Brian Cline, Business Systems Analyst Department of Information Technology G&P Trucking Company, Inc. 803.936.8595 Direct 803.739.1176 Fax From: gptalk-bounce@xxxxxxxxxxxxx [mailto:gptalk-bounce@xxxxxxxxxxxxx] On Behalf Of Michael Clevidence Sent: Monday 11 June 2007 20:57 To: gptalk@xxxxxxxxxxxxx Subject: [gptalk] Deploy ODBC via Group Policy Hello, Can you tell me if it is possible to send out an ODBC and its configuration to multiple PCs using Group Policy. We are changing our database from MySQL to SQL 2003 and need to update about 110 PC's Thank you, Michael Clevidence BIAMP SYSTEMS EMAIL NOTICE The information contained in this email and any attachments is confidential and may be subject to copyright or other intellectual property protection. If you are not the intended recipient, you are not authorized to use or disclose this information, and we request that you notify us by reply mail or telephone and delete the original message from your mail system. Mae'r e-bost hwn (ac unrhyw atodiadau) yn gyfrinachol a gall gynnwys barn bersonol nad yw'n farn Ymddiriedolaeth GIG Gofal Iechyd Gwent oni bai fod hynny wedi ei ddatgan yn benodol Os ydych chi wedi ei dderbyn trwy gamgymeriad, dilewch o'ch system, peidiwch a defnyddio, copio na datgelu'r wybodaeth mewn unrhyw fodd. Hysbyswch y sawl a'i anfonodd am y camgymeriad hwn ar unwaith os gwelwch yn dda. This e-mail (and any attachments) is confidential and may contain personal views which are not the views of Gwent HealthCare NHS Trust unless specifically stated. If you have received it in error, delete it from your system, do not use, copy or disclose the information in any way. Please notify the sender immediately of this error.