ODBCCONF.exe is a command-line tool that allows you to configure ODBC drivers and data source names.
http://msdn.microsoft.com/en-us/library/ee388579(VS.85).aspx
ODBCConf ConfigSysDSN “SQL Server” “DSN=LocalODBCConnection|SERVER=(local)” for MySQL
ODBCConf ConfigSysDSN “MySQL” “DSN=LocalODBCConnection|SERVER=MySQL_ServerName”
To get the correct Connection String for your DB reference this site:
http://www.connectionstrings.com/
Do understand the difference between SYSTEM and USER DNS:
http://digital.ni.com/public.nsf/allkb/852559036FB6447380256ADF007C3964
You cant’ give over username and password for the ODBC connection so you use this tool to change existing entrys only. MS wants use to use Logged on credentials and then make A ADS group where the user is in or not. Windows Authentication. The only way to make entrys with credentials would be to export the Registry key and then import via regedt.exe