Connection to MARIADB with MYDAC

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
PDT be-right
Posts: 4
Joined: Fri 08 Jan 2016 11:28

Connection to MARIADB with MYDAC

Post by PDT be-right » Wed 16 May 2018 09:57

Hello
Since last Windows 10 update on all clients worksation, connection is impossible.

Error code is :

Cannot create TCP/IP socket:
Invalid argument provided
Socket error Code : 10022($2726)

Idea ?

Rgds

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Connection to MARIADB with MYDAC

Post by ViktorV » Wed 16 May 2018 12:05

Unfortunately, we cannot reproduce the issue on the latest version MyDAC 9.1.5.
In order for us to be able to give you a detailed answer, we need to have a sample demonstrating the specified behavior. Therefore, please compose a full sample demonstrating the described behavior and send it to us contact form https://devart.com/company/contactform.html. Also specify the exact versions of Windows, Windows Update and IDE.

PDT be-right
Posts: 4
Joined: Fri 08 Jan 2016 11:28

Re: Connection to MARIADB with MYDAC

Post by PDT be-right » Fri 25 May 2018 15:37

Hello all,

In fact the issue with MYDAC and Windows 10 version 1803 is linked to security patch regarding SMB

If your network drive is not using SMB2, Windows 10 reject the socket connection.
Moving to SMB2 on the NAS or server resolve the issue and connection is then going on without problem.

This is then not a MYDAC issue.

Rgds
Patrick

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Connection to MARIADB with MYDAC

Post by ViktorV » Tue 29 May 2018 10:33

You are right.
This behavior is possible if you use the SMBv1 protocol. To solve the issue, you should make sure that you are using SMBv2 or SMBv3 protocols, but not SMBv1 (if you do not know how to do this, then contact your system administrator). This behavior is due to the architecture specificity of Windows 10, and we cannot influence this in any way.

Post Reply