Devart ODBC Driver for MySQL provides a high-performance and feature-rich connectivity solution for ODBC-based applications to access MySQL, Microsoft Azure Database for MySQL, MariaDB, Amazon Aurora databases from Windows, macOS, Linux, both 32-bit and 64-bit. MySQL provides standards-based drivers for JDBC, ODBC, and.Net enabling developers to build database applications in their language of choice. In addition, a native C library allows developers to embed MySQL directly into their applications.
There is a Linux MySQL DB we have connect to. This works fine on Windows 7 computers. Now there is Window 10 an no connection anymore. (Windows XP worked so too)
Server version: 5.1.73-1 (Debian)
I used the same parameters as on the Windows 7 machines. (ODBC driver 5.1, 32Bit - 'mysql-connector-odbc-noinstall-5.1.13-win32')
- The same driver (I tried version 5.3 32Bit too)
- The same user and password
- the machines are in the same network
The error is 'Malformed package'.
Connecting a Windows DB works.
Mysql Odbc Driver Windows 10 32 Bit
(The machine may not have an Internet connection.)
Microsoft Access 64 Bit Odbc Driver Downl…
Error Messages:
MySQL ODBC 5.1 Driver
Connection Failed: [HY000][MySQL][ODBC 5.1 Driver]Connection using old(pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)
Altough ist an old server I tried newer drivers:
MySQL 5.3 ANSI Driver
ConnectionFailed
[MySql][ODBC 5.3(a) Driver]Malformed packet:
MySQL 5.3 Unicode Driver
ConnectionFailed
[MySQL][ODBC 5.3(w) Driver]Malformed packet:
Mysql Odbc Driver Windows 10 Download
MySQL 8.0 ANSI Driver
ConnectionFailed
[MySQL][ODBC 8.0(a) Driver]Bad handshake:
MySQL 8.0 Unicode Driver
ConnectionFailed
[MySQL][ODBC 8.0(w) Driver]Bad handshake:
1 Answer
It's a driver problem: 5.1.13 does not work, 5.1.12 is needed! Then it works.
Download link:
mysql-connector-odbc-5.1.12-win32.msi
https://dev.mysql.com/downloads/file/?id=411741
see
MySQL ODBC Link Fails due to 'authentication protocol refused'