Bug #96614 | Cannot Get Data from database using Excel 2019 | ||
---|---|---|---|
Submitted: | 22 Aug 2019 10:03 | Modified: | 22 Aug 2019 23:16 |
Reporter: | Graham Stafford | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Connector / NET | Severity: | S3 (Non-critical) |
Version: | 8.0.17 | OS: | Windows (10) |
Assigned to: | CPU Architecture: | Any |
[22 Aug 2019 10:03]
Graham Stafford
[22 Aug 2019 10:42]
MySQL Verification Team
Hello Graham, Thank you for the report. Observed this while using Excel 2019 and C/NET 8.0.17 on Win10. regards, Umesh
[22 Aug 2019 10:47]
MySQL Verification Team
Bug #96545 marked as duplicate of this one
[22 Aug 2019 12:27]
MySQL Verification Team
Bug #96355 marked as duplicate of this one
[22 Aug 2019 21:29]
Jose Ramirez Ruiz
Posted by developer: For MSI installations of Connector/NET, the Renci.SshNet.dll deployed to the GAC is incorrect, causing the error. To workaround this problem the user can obtain the correct dll from the installation folder (typically C:\Program Files (x86)\MySQL\MySQL Connector Net 8.0.17\Assemblies\v4.5.2). The dll must be placed at the location of the exe calling MySql.Data.dll, in the case of Excel it must be placed at: C:\Program Files\Microsoft Office\Office16\ADDINS\Microsoft Power Query for Excel Integrated\bin. For users making use of the uninstall package, the Renci.SshNet.dll located in the folder is the correct one and must also be placed alongside the exe calling the MySql.Data.dll assembly or in some cases simply alongside MySql.Data.dll. Work is being made to remove the hard dependency on the Renci.SshNet.dll which in future releases will only be required when making use of SSH connections and will not generate errors on non-SSH connections.
[22 Aug 2019 23:16]
Christine Cole
Posted by developer: Fixed as of the upcoming MySQL Connector/NET 8.0.18 release, and here's the changelog entry: The Renci.SshNet.dll deployment was problematic for Connector/NET 8.0.17 MSI installations. Some applications, such as Microsoft Excel, were unable to read MySQL data as a result. This fix removes unnecessary dependencies on the DLL and also ensures that the MSI installation deploys the correct Renci.SshNet.dll to the GAC. Thank you for the bug report.
[20 Sep 2019 4:53]
MySQL Verification Team
Bug #96951 marked as duplicate of this one