mysql-5.7.17 odbc 安装失败重装教程

小渣渣

1: Action 14:16:53: INSTALL.
1: 1: MySQL Connector/ODBC 5.3 2: {17E48BE8-F0F8-42B6-82D3-7A5840694D79}
1: Action 14:16:53: FindRelatedProducts. Searching for related applications
1: Action 14:16:53: AppSearch. Searching for installed applications
1: Action 14:16:53: ValidateProductID.
1: Action 14:16:53: CostInitialize. Computing space requirements
1: Action 14:16:53: FileCost. Computing space requirements
1: Action 14:16:53: CostFinalize. Computing space requirements
1: Action 14:16:53: InstallValidate. Validating install
1: Action 14:16:53: SetARPINSTALLLOCATION.
1: Action 14:16:53: SetARPREADME.
1: Action 14:16:53: InstallInitialize.
1: Action 14:16:53: RemoveExistingProducts. Removing applications
1: Action 14:16:53: ProcessComponents. Updating component registration
1: Action 14:16:53: GenerateScript. Generating script operations for action:
1: Updating component registration
1: Action 14:16:54: UnpublishFeatures. Unpublishing product features
1: Action 14:16:54: RemoveODBC. Removing ODBC components
1: Action 14:16:54: RemoveRegistryValues. Removing system registry values
1: Action 14:16:54: RemoveFiles. Removing files
1: Action 14:16:54: InstallFiles. Copying new files
1: File: Copying new files,  Directory: ,  Size:
1: Action 14:16:54: WriteRegistryValues. Writing system registry values
1: Key: Writing system registry values, Name: , Value:
1: Action 14:16:54: InstallODBC. Installing ODBC components
1: Action 14:16:54: RegisterUser. Registering user
1: Action 14:16:54: RegisterProduct. Registering product
1: Registering product
1: Action 14:16:54: PublishFeatures. Publishing product features
1: Feature: Publishing product features
1: Action 14:16:54: PublishProduct. Publishing product information
1: Action 14:16:54: InstallFinalize.
1: Action 14:16:54: ProcessComponents. Updating component registration
1: Action 14:16:54: RemoveODBC. Removing ODBC components
1: Action 14:16:54: InstallFiles. Copying new files
1: File: ChangeLog.txt,  Directory: C:\Program Files\MySQL\Connector.ODBC 5.3\,  Size: 58564
1: File: myodbc-installer.exe,  Directory: C:\Program Files\MySQL\Connector.ODBC 5.3\,  Size: 4269568
1: File: myodbc-installer.pdb,  Directory: C:\Program Files\MySQL\Connector.ODBC 5.3\,  Size: 1789952
1: File: Licenses_for_Third-Party_Components.txt,  Directory: C:\Program Files\MySQL\Connector.ODBC 5.3\,  Size: 103161
1: File: COPYING.txt,  Directory: C:\Program Files\MySQL\Connector.ODBC 5.3\,  Size: 18122
1: File: myodbc5a.dll,  Directory: C:\Program Files\MySQL\Connector.ODBC 5.3\,  Size: 5419520
1: File: myodbc5S.dll,  Directory: C:\Program Files\MySQL\Connector.ODBC 5.3\,  Size: 4387840
1: File: myodbc5S.lib,  Directory: C:\Program Files\MySQL\Connector.ODBC 5.3\,  Size: 1916
1: File: myodbc5S.pdb,  Directory: C:\Program Files\MySQL\Connector.ODBC 5.3\,  Size: 2043904
1: File: myodbc5w.dll,  Directory: C:\Program Files\MySQL\Connector.ODBC 5.3\,  Size: 5417984
1: File: myodbc5a.lib,  Directory: C:\Program Files\MySQL\Connector.ODBC 5.3\,  Size: 16478
1: File: myodbc5a.pdb,  Directory: C:\Program Files\MySQL\Connector.ODBC 5.3\,  Size: 5459968
1: File: myodbc5w.lib,  Directory: C:\Program Files\MySQL\Connector.ODBC 5.3\,  Size: 16658
1: File: myodbc5w.pdb,  Directory: C:\Program Files\MySQL\Connector.ODBC 5.3\,  Size: 5451776
1: File: README.txt,  Directory: C:\Program Files\MySQL\Connector.ODBC 5.3\,  Size: 5690
1: Action 14:16:54: WriteRegistryValues. Writing system registry values
1: Key: \SOFTWARE\MySQL AB\MySQL Connector/ODBC 5.3, Name: Version, Value: 5.3.6
1: Key: \SOFTWARE\MySQL AB\MySQL Connector/ODBC 5.3, Name: , Value:
1: Action 14:16:54: InstallODBC. Installing ODBC components
1: Error 1918.Error installing ODBC driver MySQL ODBC 5.3 ANSI Driver, ODBC error 13: 无法加载  MySQL ODBC 5.3 ANSI Driver ODBC 驱动程序的安装例程，因为存在系统错误代码 126: 找不到指定的模块。 (C:\Program Files\MySQL\Connector.ODBC 5.3\myodbc5S.dll)。. Verify that the file MySQL ODBC 5.3 ANSI Driver exists and that you can access it.
1: Action 14:16:54: Rollback. Rolling back action:
1: Installing ODBC components
1: Writing system registry values
1: Copying new files
1: Removing ODBC components
1: Updating component registration
1: 1: MySQL Connector/ODBC 5.3 2: {17E48BE8-F0F8-42B6-82D3-7A5840694D79} 3: 3
1: The action 'Install' for product 'Connector/ODBC 5.3.6' failed.

mysql-5.7.17 odbc的版本是5.3.6，我的电脑是64位的，所以要装64位的odbc

下面是重新安装odbc的教程，如下：


安装失败的解决方案：

I.可能是缺少Microsoft Visual C++ 2010 需要安装即可（记得需重启）

64位：http://www.microsoft.com/en-us/download/confirmation.aspx?id=14632

32位：http://www.microsoft.com/en-gb/download/details.aspx?id=5555


最新的mysql版本，需要安装，Microsoft Visual C++ 2013 ，请自行百度下载！！

我说一下，我的修复教程吧！

1：下载安装的Microsoft Visual C++ 2010 64位
2：下载安装的Microsoft Visual C++ 2013 64位
3：重新打开mysql-5.7.17.msi安装包，选择右上角的“add”，然后，选择到“odbc 5.3.6 x64”版本，然后，点击往右的箭头，点击“Next”，如下图：（由于我已经安装成功了，所以截图里面没有x64版本的了）

4：然后程序就自动安装了，下面是我安装成功之后的截图：



如果，还有没有成功的话，请试下下面的方法，我自己未测试！

如若不好使请参考第二步

II.是一般电脑C:\Windows\System32\目录下有4个文件msvcrt.dll , msvcr100.dll , msvcr110.dll , msvcr120.dll

在安装odbc的系统中，在该目录下缺少了msvcr110.dll , msvcr120.dll这两个文件，也会报上面错误。将这两个文件下载后

放到C:\Windows\System32\即可。msvcr110.dll ： http://download.csdn.net/detail/moon1107gitana/9739511

msvcr120.dll ： http://download.csdn.net/detail/moon1107gitana/9739519

3.在配置mysql odbc 数据源时 有的人安装了odbc 可是在数据源中 无法找到自己安装的数据源

解决方法：在电脑里输入该路径,即可配置odbcC:\windows\SysWOW64\odbcad32