Difference between revisions of "MyODBC connector"

From WPKG | Open Source Software Deployment and Distribution
Jump to: navigation, search
m (Update for Mysql Tools version 5.0-r14)
(big tidyup)
Line 1: Line 1:
−
This is a silent installer and uninstaller for MySQL Connector/ODBC (also known as MyODBC). MyODBC allows you to connect from Windows programs to a remote MySQL database.
+
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 3 ==
 +
 
 +
=== MSI Installer ===
  
 
<source lang="xml">
 
<source lang="xml">
 
<package id="myodbc" name="MyODBC connector" revision="1" reboot="false" priority="0" >
 
<package id="myodbc" name="MyODBC connector" revision="1" reboot="false" priority="0" >
 
  <check type="uninstall" condition="exists" path="MySQL Connector/ODBC 3.51" />
 
  <check type="uninstall" condition="exists" path="MySQL Connector/ODBC 3.51" />
−
  <install cmd="%SOFTWARE%\myodbc\myodbc-3.51.12.exe /s" />
+
  <install cmd='msiexec /passive /i "%SOFTWARE%\myodbc\myodbc-3.51.26-win32.msi"' />
−
<remove cmd="%windir%\system32\unwise.exe /S %windir%\system32\myodbc3_install.log" />
+
<remove cmd="MsiExec.exe /qb /uninstall {0CB3C535-1171-4A20-B549-E2CB5DEB9723}" />
 
</package>
 
</package>
 
</source>
 
</source>
  
−
Or
+
=== .exe Installer ===
 +
 
 
<source lang="xml">
 
<source lang="xml">
−
  <install cmd='msiexec /passive /i "%SOFTWARE%\myodbc\myodbc-3.51.12-win32.msi"' />
+
<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>
 
</source>
 
</source>
  
−
MySQL Connector 5.1.5
+
== MySQL Connector/ODBC 5.1 ==
 +
 
 
<source lang="xml">
 
<source lang="xml">
 
<package id="myodbc" name="MyODBC connector" revision="3" reboot="false" priority="5" >
 
<package id="myodbc" name="MyODBC connector" revision="3" reboot="false" priority="5" >
 
   <check type="uninstall" condition="exists" path="MySQL Connector/ODBC 5.1" />
 
   <check type="uninstall" condition="exists" path="MySQL Connector/ODBC 5.1" />
−
<!-- install/upgrade of 5.1.5 fails if earlier (eg 5.1.4) version is installed, so we do a remove first. -->
 
−
  <install cmd="msiexec /qn /x{29042B1C-0713-4575-B7CA-5C8E7B0899D4}" ><exit code="0"/><exit code="1605" /></install>
 
 
   <install cmd="msiexec /qn /i %SOFTWARE%\myodbc\mysql-connector-odbc-5.1.5-win32.msi " />
 
   <install cmd="msiexec /qn /i %SOFTWARE%\myodbc\mysql-connector-odbc-5.1.5-win32.msi " />
−
  <upgrade cmd="msiexec /qn /x{29042B1C-0713-4575-B7CA-5C8E7B0899D4}" ><exit code="0"/><exit code="1605" /></upgrade>
 
 
   <upgrade 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}" />
 
   <remove cmd="msiexec /qn /x{29042B1C-0713-4575-B7CA-5C8E7B0899D4}" />
Line 27: Line 38:
 
</source>
 
</source>
  
−
Setting up an ODBC DSN (dummy.reg is HKLM\SOFTWARE\ODBC\ODBC.ini\dummy exported via regedit on a machine with the appropriate dsn defined)
+
=== If you were beta testing earlier 5.1 versions prior to 5.1.5 ===
 +
 
 +
install/upgrade of 5.1.5 fails if earlier (eg 5.1.4) version is installed, so we do a remove first by adding these:
 +
 
 +
<source lang="xml">
 +
  <install cmd="msiexec /qn /x{29042B1C-0713-4575-B7CA-5C8E7B0899D4}" ><exit code="0"/><exit code="1605" /></install>
 +
  <upgrade cmd="msiexec /qn /x{29042B1C-0713-4575-B7CA-5C8E7B0899D4}" ><exit code="0"/><exit code="1605" /></upgrade>
 +
</source>
 +
 
 +
== Setting up an ODBC DSN ==
 +
 
 +
dummy.reg is HKLM\SOFTWARE\ODBC\ODBC.ini\dummy exported via regedit on a machine with the appropriate DSN defined.
 +
 
 
<source lang="xml">
 
<source lang="xml">
 
<package id="mysql_dummy" name="My Dummy ODBC Connection" revision="2" reboot="false" priority="4" >
 
<package id="mysql_dummy" name="My Dummy ODBC Connection" revision="2" reboot="false" priority="4" >
 
   <depends package-id="myodbc" />
 
   <depends package-id="myodbc" />
−
   <depends package-id="reg" />  <!-- win2k doesn't come with reg.exe, so I have this dependency -->
+
   <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" />
 
   <check type="registry" condition="exists" path="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\dummy" />
 
   <install cmd="regedit /s  %SOFTWARE%\myodbc\dummy.reg " />
 
   <install cmd="regedit /s  %SOFTWARE%\myodbc\dummy.reg " />
Line 42: Line 65:
 
</source>
 
</source>
  
−
Reg.exe for win2k
+
=== 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:
 +
 
 
<source lang="xml">
 
<source lang="xml">
 
<package id="reg" name="Reg.exe" revision="1" reboot="false" priority="99" >
 
<package id="reg" name="Reg.exe" revision="1" reboot="false" priority="99" >
Line 50: Line 76:
 
</source>
 
</source>
  
−
Mysql Tools 5.0-r14
+
== Mysql Tools 5.0 ==
 +
 
 
<source lang="xml">
 
<source lang="xml">
 
<package id="mysql_gui_tools" name="MyODBC GUI Tools" revision="1" reboot="false" priority="4" >
 
<package id="mysql_gui_tools" name="MyODBC GUI Tools" revision="1" reboot="false" priority="4" >
Line 59: Line 86:
 
</package>
 
</package>
 
</source>
 
</source>
−
 
−
MyODBC can be dowloaded from http://www.mysql.com/products/connector/odbc/.
 
  
 
[[category:Silent Installers]]
 
[[category:Silent Installers]]

Revision as of 13:03, 24 November 2008

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 3

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>

MySQL Connector/ODBC 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>

If you were beta testing earlier 5.1 versions prior to 5.1.5

install/upgrade of 5.1.5 fails if earlier (eg 5.1.4) version is installed, so we do a remove first by adding these: 

  <install cmd="msiexec /qn /x{29042B1C-0713-4575-B7CA-5C8E7B0899D4}" ><exit code="0"/><exit code="1605" /></install>
  <upgrade cmd="msiexec /qn /x{29042B1C-0713-4575-B7CA-5C8E7B0899D4}" ><exit code="0"/><exit code="1605" /></upgrade>

Setting up an ODBC DSN

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-r14-win32.msi " />
  <upgrade cmd="msiexec /qn /i %SOFTWARE%\myodbc\mysql-gui-tools-5.0-r14-win32.msi " />
  <remove cmd="msiexec /qn /x{CCE07B0A-3DD1-4177-9743-F5A95A57CFEF}" />
</package>
Retrieved from "https://wpkg.org/index.php?title=MyODBC_connector&oldid=6455"