Tried multiple things and am still having problems. I first off tried to write a script that would copy the three pertinent files for the MySQL ODBC drivers to all of my machines and that worked but when my script is run against them, they get an error about the provider not being available or something. And on those same systems, if I go ahead and run the .msi from MySQL on the system and then re-run the script, it runs fine so I know it has to do with the fact that I'm not copying everything that needs to be copies to the different machines. Here is the code I was using to copy the three files to the System32 directory:

Code:
;COPY MYSQL ODBC DRIVERS TO TARGET SYSTEM SO THEY CAN WRITE TO THE DATABASE
IF NOT EXIST('%WINDIR%\System32\myodbc3.dll')
COPY \\gjlk2w2ws101\softwarepushes\sms\myodbc3.dll %windir%\System32\
ENDIF

IF NOT EXIST('%WINDIR%\System32\my3dsn.hlp')
COPY \\gjlk2w2ws101\softwarepushes\sms\my3dsn.hlp %windir%\System32\
ENDIF

IF NOT EXIST('%WINDIR%\System32\myodbc3S.dll')
COPY \\gjlk2w2ws101\softwarepushes\sms\myodbc3S.dll %windir%\System32\
ENDIF



Then, since I figured that wouldn't work and I was using SMS to run this script anyways, I decided I'd just try to push the MySQL msi for the ODBC drivers through SMS also. So I created the package and it just sat in the background because it was waiting for user input. I researched the MSI on MySQL's site and couldn't find command-line switches for this file and then tried to use the command lines associated with msiexec and it turns out that there are no switches for windows installer version 2.0 and below? And myself and only a few others are using SP2 which ships windows installer version 3.0 that has command line switches! And while I can run the file with the /quiet switch, it's still running in my processes so I guess it's still waiting for user input?

So I guess my questions are this. For SMS, what else do I need to add to my script so that I can push it out to all of my systems and have it install the MySQL ODBC drivers OR what do I need to do to get a silent install of the msi???

Thanx in advance!