Mysql ODBC 5.1 Driver免安装脚本

在使用Mysql 的时候,需要使用ODBC数据源的方式来连接mysql,所以常常需要用到免安装的驱动,自己参考官网的脚本,

修改了一个实用点的脚本,放出来大家一起分享:

安装mysql odbc 5.1 Driver

  1. @ECHO OFF
  2. SET installdir=none
  3. IF EXIST %windir%/system/nul   SET installdir=%windir%/system
  4. IF EXIST %windir%/system32/nul SET installdir=%windir%/system32
  5. IF %installdir%==none GOTO :doError5
  6. IF EXIST %installdir%/myodbc-installer.exe GOTO :doError4
  7. REM ****
  8. REM * Find out the bin/lib directory, or use default
  9. REM ****
  10. SET libdir=lib
  11. SET bindir=bin
  12. IF EXIST lib/release/myodbc5.lib         SET libdir=lib/release
  13. IF EXIST lib/relwithdebinfo/myodbc5.lib  SET libdir=lib/relwithdebinfo
  14. IF EXIST bin/release/myodbc-installer.exe        SET bindir=bin/release
  15. IF EXIST bin/relwithdebinfo/myodbc-installer.exe SET bindir=bin/relwithdebinfo
  16. REM ****
  17. REM * Copying myodbc libraries and executables to install dir...
  18. REM ****
  19. ECHO Copying installation files
  20. IF NOT EXIST %libdir%/myodbc5.lib  GOTO :doError2
  21. IF NOT EXIST %libdir%/myodbc5S.lib GOTO :doError2
  22. IF NOT EXIST %bindir%/myodbc-installer.exe GOTO :doError2
  23. copy %libdir%/myodbc5S.dll %installdir%
  24. copy %libdir%/myodbc5S.lib %installdir%
  25. copy %libdir%/myodbc5.dll  %installdir%
  26. copy %libdir%/myodbc5.lib  %installdir%
  27. copy %bindir%/myodbc-installer.exe      %installdir%
  28. copy doc/*.hlp             %installdir%
  29. REM ****
  30. REM * Registering driver...
  31. REM *
  32. REM * We can do this with myodbc-installer.exe or the MS Windows ODBCConf.exe. It
  33. REM * may be safer to use the ODBCConf.exe when we think about such things
  34. REM * as 64bit windows.
  35. REM ****
  36. ECHO Registering driver
  37. myodbc-installer -d -a -n "MySQL ODBC 5.1 Driver" -t "DRIVER=myodbc5.dll;SETUP=myodbc5S.dll"
  38. ECHO "+-----------------------------------------------------+"
  39. ECHO "| DONE                                                |"
  40. ECHO "+-----------------------------------------------------+"
  41. ECHO "|                                                     |"
  42. ECHO "| Hopefully things went well; the Connector/ODBC      |"
  43. ECHO "| files have been copied to the system directory      |"
  44. ECHO "| and the driver has been registered.                 |"
  45. ECHO "|                                                     |"
  46. ECHO "| Connector/ODBC is ready to use.                     |"
  47. ECHO "|                                                     |"
  48. ECHO "| The most common thing to do next is to go to the    |"
  49. ECHO "| Control Panel and find the ODBC Administrator -     |"
  50. ECHO "| then use it to create a Data Source Name (DSN)      |"
  51. ECHO "| so you (and your application) can connect to a      |"
  52. ECHO "| MySQL server.                                       |"
  53. ECHO "|                                                     |"
  54. ECHO "+-----------------------------------------------------+"
  55. EXIT /B 0
  56. :doError2
  57. ECHO "+-----------------------------------------------------+"
  58. ECHO "| ERROR                                               |"
  59. ECHO "+-----------------------------------------------------+"
  60. ECHO "|                                                     |"
  61. ECHO "| Connector/ODBC not built.                           |"
  62. ECHO "|                                                     |"
  63. ECHO "+-----------------------------------------------------+"
  64. PAUSE
  65. EXIT /B 1
  66. :doError4
  67. ECHO "+-----------------------------------------------------+"
  68. ECHO "| ERROR                                               |"
  69. ECHO "+-----------------------------------------------------+"
  70. ECHO "|                                                     |"
  71. ECHO "| Existing Connector/ODBC installed. Request ignored. |"
  72. ECHO "|                                                     |"
  73. ECHO "+-----------------------------------------------------+"
  74. PAUSE
  75. EXIT /B 1
  76. :doError5
  77. ECHO "+-----------------------------------------------------+"
  78. ECHO "| ERROR                                               |"
  79. ECHO "+-----------------------------------------------------+"
  80. ECHO "|                                                     |"
  81. ECHO "| Can't find the Windows system directory             |"
  82. ECHO "|                                                     |"
  83. ECHO "+-----------------------------------------------------+"
  84. PAUSE
  85. EXIT /B 1

卸载部分

  1. @ECHO OFF
  2. REM #########################################################
  3. REM
  4. REM /brief  Uninstall myodbc.
  5. REM
  6. REM         This exists for those working with the Windows source
  7. REM         distribution.
  8. REM
  9. REM         Use this to remove the driver and supporting files
  10. REM         from the system directory and deregister the driver.
  11. REM
  12. REM /sa     README.win
  13. REM
  14. REM #########################################################
  15. SET installdir=none
  16. IF EXIST %windir%/system/nul   SET installdir=%windir%/system
  17. IF EXIST %windir%/system32/nul SET installdir=%windir%/system32
  18. IF %installdir%==none GOTO :doError4
  19. IF NOT EXIST %installdir%/myodbc-installer.exe GOTO doError2
  20. REM ****
  21. REM * Deregistering driver...
  22. REM ****
  23. myodbc-installer -d -r -n "MySQL ODBC 5.1 Driver"
  24. REM ****
  25. REM * Removing files...
  26. REM ****
  27. del /Q /F %installdir%/myodbc5S.dll
  28. del /Q /F %installdir%/myodbc5S.lib
  29. del /Q /F %installdir%/myodbc5.dll
  30. del /Q /F %installdir%/myodbc5.lib
  31. del /Q /F %installdir%/myodbc-installer.exe
  32. del /Q /F %installdir%/myodbc3*.hlp
  33. ECHO "+-----------------------------------------------------+"
  34. ECHO "| DONE                                                |"
  35. ECHO "+-----------------------------------------------------+"
  36. ECHO "|                                                     |"
  37. ECHO "| Hopefully things went well; the Connector/ODBC      |"
  38. ECHO "| files have been removed from the system directory   |"
  39. ECHO "| and the driver has been deregistered.               |"
  40. ECHO "|                                                     |"
  41. ECHO "+-----------------------------------------------------+"
  42. EXIT /B 0
  43. :doError2
  44. ECHO "+-----------------------------------------------------+"
  45. ECHO "| ERROR                                               |"
  46. ECHO "+-----------------------------------------------------+"
  47. ECHO "|                                                     |"
  48. ECHO "| Connector/ODBC does not appear to be installed.     |"
  49. ECHO "|                                                     |"
  50. ECHO "+-----------------------------------------------------+"
  51. PAUSE
  52. EXIT /B 1
  53. :doError4
  54. ECHO "+-----------------------------------------------------+"
  55. ECHO "| ERROR                                               |"
  56. ECHO "+-----------------------------------------------------+"
  57. ECHO "|                                                     |"
  58. ECHO "| Can't find the Windows system directory             |"
  59. ECHO "|                                                     |"
  60. ECHO "+-----------------------------------------------------+"
  61. PAUSE
  62. EXIT /B 1

关键部分都带有注释,如有问题欢迎大家一起讨论。

同时附已经做好的mysql odbc 5.1 Driver免安装包

mysql odbc 5.1 Driver

http://blog.csdn.net/blpluto/article/details/5677487

上一篇:使用nginx反向代理进行负载均衡


下一篇:Asp.net 高性能 Sqlite ORM 框架之 sqliteSugar