I'm going to make a batch script to do some basic troubleshooting. Among other things, I want to test 32-bit MySQL ODBC's for connectivity. This script will run locally on each workstation. There doesnt appear to be any option in odbcconf.exe for this.
1 Answer
Something like:
sqlcmd.exe -U MyLogin -P MyPassword -S ComputerName\InstanceName | find "connected"
If the connection succeeds, then you know your ODBC connection is good.
Also, check out this big article on scripting with sqlcmd: