======ODBC======
=====ODBC Location=====
The 32-bit version of the Odbcad32.exe file is located in the
<code>%systemdrive%\Windows\SysWoW64</code>
The 64-bit version of the Odbcad32.exe file is located in the
<code>%systemdrive%\Windows\System32</code>
=====Automate ODBC Setup=====
ODBC entries are just registry keys. You can automate the setup of ODBC entries with registry files.
This section assumes
* You are setting up ODBC on a x64 bit Windows 7 machine.
* You are logged into the machine as a domain administrator.
* You have already installed the appropriate MySQL ODBC driver (in this case mysql-connector-odbc-3.51.30-win32)

Create a text file on the desktop called odbcsetup.txt and paste in the following text.<code>Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\PUT_YOUR_CONNECTION_NAME_HERE]
"Driver"="C:\\Program Files (x86)\\MySQL\\Connector ODBC 3.51\\myodbc3.dll"
"SERVER"="datbase.example.com"
"DATABASE"="testdb"
"PORT"="3306"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources]
"PUT_YOUR_CONNECTION_NAME_HERE"="MySQL ODBC 3.51 Driver"
</code>
Rename the file to odbcsetup.reg then double click it to add it to the registry.