MySQL connector suddenly giving error -2147467259 on windows 10!

[Ola_A]

Yesterday I got notice that our small home made database access applications suddenly stopped working on windows 10! It gives error -2147467259. Seems all works fine on windows 7.

NI_Database_API.lvlib:DB Tools Open Connec (String).vi->RunSQLCommand4.vi<ERR>ADO Error: 0x80004005
Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Driver Manager] Datakällan hittades inte och ingen standarddrivrutin är angiven in NI_Database_API.lvlib:DB Tools Open Connec (String).vi->RunSQLCommand4.vi

The error occurs at DB tools Open Connection.vi

Setup

Labview 2015 sp1

WIndows 10 pro 64 bit (same problem on 32 bit)

MySQL connector 5.2.3-ansi

In test I had server, db and password stored at windows ODBC datasouces. Test there gives "OK".

(DB is mariaDB 10.0.34 )

My guess is that an update of windows 10 cause this problem. Most obvious solution to test is to update mysql connector, but to which version?

Know 5.3.4/32 did not work earlier.

5.3.9/32 I tried to install, but gave installer error on windows 10/32 bit.

MySQL gives 8.0.11 as the latest, will try, but I am a little afraid it is too new for my setup.

[Ola_A]

Latest info from trying newer mysql connectors

Removed current mysql connector.

Installed the 8.0.11 from mysql.com. It only installs 64 bit connector on 64 bit system! But my labview program needs 32bit...

Removed that and tried 5.3.10/32 instead. Same connection problem as in first post.

...mumble mumble...

[Ola_A]

Some more. I just read the post https://forums.ni.com/t5/LabVIEW/TCP-connection-on-windows-10/td-p/3797501 about TCP problems. Could very well be related to my problem.

Updated to ODBC connector 5.3.10 (latest 32bit connector for mysql).

And still I get:

1. In Developement system a program runs fine.
2. As exe (on samba server, with named server in ODBC connection):
   

   "Possible reason(s):
   ADO Error: 0x80004005
   Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [MySQL][ODBC 5.3(w) Driver]Unknown MySQL server host 'db1.blabla.se' (0) in NI_Database_API.lvlib:DB Tools Open Connec (String).vi->..."

   3. with ip number for server:
   

   "Possible reason(s):
   ADO Error: 0x80004005
   Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [MySQL][ODBC 5.3(w) Driver]Can't create TCP/IP socket (10022) in NI_Database_API.lvlib:DB Tools Open Connec (String).vi->... "

[Ola_A · Accepted solution]

The reason is that evidently windows 10s update does not allow network connections from an exe file that is started on old samba share (smb 1.1?).

See more in this thread: https://forums.ni.com/t5/LabVIEW/TCP-connection-on-windows-10/td-p/3797501