Mysql Odbc Driver Windows 10

Active9 months ago

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

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

Windows

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:

Andy U.
Andy U.Andy U.

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'

Andy U.Andy U.

Not the answer you're looking for? Browse other questions tagged mysqllinuxwindows-10odbc or ask your own question.