Difference between revisions of "MyODBC connector"

Latest revision as of 15:28, 17 January 2014

This is a silent installer and uninstaller for MySQL Connector/ODBC (once known as MyODBC).

MySQL Connector/ODBC allows Windows programs, for example OpenOffice, to connect to a remote MySQL database, for example on an office server.

MySQL Connector/ODBC can be dowloaded from http://www.mysql.com/products/connector/odbc/.

MySQL Connector/ODBC 5.2

Available in either 32-bit or 64-bit varients.

"5.2, which includes the functionality of the Unicode driver and the ANSI driver, which formerly were split between Connector/ODBC 5.1 and Connector/ODBC 3.51"

"At installation time, you can choose the Unicode driver for the broadest compatibility with data sources using various character sets, or the ANSI driver for optimal performance with a more limited range of character sets. It works with MySQL versions 4.1.1 and higher."

"With MySQL Connector/ODBC 5.2 ... now offering both ANSI and Unicode drivers, you should expect to upgrade [from version 3.51] relatively soon after 5.2 becomes generally available." - http://dev.mysql.com/doc/refman/5.5/en/connector-odbc-versions.html

"LibreOffice requires a 32bit ODBC driver and needs to be configured with the 32bit ODBC administrator."

MySQL Connector/ODBC 5.1

For ODBC connections to MySQL version 5.1?

<package id="myodbc" name="MyODBC connector" revision="3" reboot="false" priority="5" >
  <check type="uninstall" condition="exists" path="MySQL Connector/ODBC 5.1" />
  <install cmd="msiexec /qn /i %SOFTWARE%\myodbc\mysql-connector-odbc-5.1.5-win32.msi " />
  <upgrade cmd="msiexec /qn /i %SOFTWARE%\myodbc\mysql-connector-odbc-5.1.5-win32.msi " />
  <remove cmd="msiexec /qn /x{29042B1C-0713-4575-B7CA-5C8E7B0899D4}" />
</package>

MySQL Connector/ODBC 3

For ODBC connections to MySQL versions prior to 5.1(?)

MSI Installer

<package id="myodbc" name="MyODBC connector" revision="1" reboot="false" priority="0" >
 <check type="uninstall" condition="exists" path="MySQL Connector/ODBC 3.51" />
 <install cmd='msiexec /passive /i "%SOFTWARE%\myodbc\myodbc-3.51.26-win32.msi"' />
<remove cmd="MsiExec.exe /qb /uninstall {0CB3C535-1171-4A20-B549-E2CB5DEB9723}" />
</package>

.exe Installer

<package id="myodbc" name="MyODBC connector" revision="1" reboot="false" priority="0" >
 <check type="uninstall" condition="exists" path="MySQL Connector/ODBC 3.51" />
 <install cmd="%SOFTWARE%\myodbc\myodbc-3.51.26.exe /s" />
 <remove cmd="%windir%\system32\unwise.exe /S %windir%\system32\myodbc3_install.log" />
</package>

Setting up an ODBC User DSN

Version 5.1

HKCU\Software\ODBC\ODBC.INI\ODBC Data Sources\<connection name> REG_SZ MySQL ODBC 5.1 Driver
HKCU\Software\ODBC\ODBC.INI\<connection name>\DATABASE <database> REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\Driver C:\Program Files\MySQL\Connector ODBC 5.1\myodbc5.dll REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\PORT 3306 REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\PWD <password> REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\SERVER <server> REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\UID <username> REG_SZ

Version 3.51

HKCU\Software\ODBC\ODBC.INI\ODBC Data Sources\<connection name> REG_SZ MySQL ODBC 3.51 Driver
HKCU\Software\ODBC\ODBC.INI\<connection name>\DATABASE <database> REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\Driver %WINDIR%\system32\myodbc3.dll REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\PORT 3306 REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\PWD <password> REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\SERVER <server> REG_SZ
HKCU\Software\ODBC\ODBC.INI\<connection name>\UID <username> REG_SZ

Setting up an ODBC System DSN

Version 5.1

dummy.reg is HKLM\SOFTWARE\ODBC\ODBC.ini\dummy exported via regedit on a machine with the appropriate DSN defined.

<package id="mysql_dummy" name="My Dummy ODBC Connection" revision="2" reboot="false" priority="4" >
  <depends package-id="myodbc" />
  <depends package-id="reg" />  <!-- Windows 2000 doesn't come with reg.exe, hence this dependency -->
  <check type="registry" condition="exists" path="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\dummy" />
  <install cmd="regedit /s  %SOFTWARE%\myodbc\dummy.reg " />
  <install cmd='reg.exe add "HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC DATA SOURCES" /v dummy /t REG_SZ /d "MySQL ODBC 5.1 Driver" /f ' />
  <upgrade cmd="regedit /s  %SOFTWARE%\myodbc\dummy.reg " />
  <upgrade cmd='reg.exe add "HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC DATA SOURCES" /v dummy /t REG_SZ /d "MySQL ODBC 5.1 Driver" /f ' />
  <remove cmd="reg.exe del  HKLM\SOFTWARE\ODBC\ODBC.INI\dummy /f" />
  <remove cmd='reg.exe del "HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC DATA SOURCES" /v dummy /f ' />
</package>

Reg.exe for Windows 2000

reg.exe isn't bundled with Windows 2000 by default, it is only available as a download or as part of the Windows 2000 Resource Kit. This copies reg.exe into place so it can be used in the above:

<package id="reg" name="Reg.exe" revision="1" reboot="false" priority="99" >
  <check type="file" condition="exists" path="%WINDIR%\system32\reg.exe" />
  <install cmd='xcopy /Q /R /Y "%SOFTWARE%\reg.exe" "%WINDIR%\system32\" ' />
</package>

Mysql Tools 5.0

<package id="mysql_gui_tools" name="MyODBC GUI Tools" revision="1" reboot="false" priority="4" >
  <check type="uninstall" condition="exists" path="MySQL Tools for 5.0" />
  <install cmd="msiexec /qn /i %SOFTWARE%\myodbc\mysql-gui-tools-5.0-r17-win32.msi " />
  <upgrade cmd="msiexec /qn /i %SOFTWARE%\myodbc\mysql-gui-tools-5.0-r17-win32.msi " />
  <remove cmd="msiexec /qn /x{FCB10DE3-E190-4A7E-B06A-FAC61567ABFC}" />
</package>