Connecting problems with UniDAC 6.1.3 MySQL provider using Lazarus 1.4.2

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
neseir
Posts: 7
Joined: Tue 16 Aug 2011 12:56

Connecting problems with UniDAC 6.1.3 MySQL provider using Lazarus 1.4.2

Post by neseir » Wed 22 Jul 2015 20:13

Hi

I have problems connecting the UniDAC 6.1.3 source edition with a MySQL 5.1 service. Using the component design time works perfect getting all tables and listing information in the dataaware components. The problem is that when I tries to execute the program it claims first that there are some problems in the threading and then ends up with a 10061 message.

Switching from direct mode to client mode solves this but I then get problems with text fields are recognized as floats and it all crashes.

I have disabled the keep designtime connection to reduce the connections initiated from the application but with no difference. Using the same application code on windows works perfect with no problem connection to the database.

Have tested this using UniDAC 6.0.2 and 6.1.3 in Lazarus 1.2.6, 1.4.0 and 1.4.2. All end up with the same problem. Currently I'm using Ubuntu 14.04 LTS 64 bit edition (using the standard SqlDB components in Lazarus works perfect accessing the same database). I'm out of ideas to test and I'm quite confident that there is nothing to change on the remote MySQL instance since both designtime and standard MySQL components in all Lazarus versions works ok.

Regards
Eirik

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

Re: Connecting problems with UniDAC 6.1.3 MySQL provider using Lazarus 1.4.2

Post by ViktorV » Mon 27 Jul 2015 08:34

To resolve the problem, in the project file ( with the *.lpr extension) add the following string: {$DEFINE UseCThreads}, before {$IFDEF UNIX}{$IFDEF UseCThreads}

neseir
Posts: 7
Joined: Tue 16 Aug 2011 12:56

Re: Connecting problems with UniDAC 6.1.3 MySQL provider using Lazarus 1.4.2

Post by neseir » Tue 28 Jul 2015 20:36

Thank You!

That solved the problem :D !

Regards
Eirik Nesje

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

Re: Connecting problems with UniDAC 6.1.3 MySQL provider using Lazarus 1.4.2

Post by ViktorV » Wed 29 Jul 2015 07:10

It is good to see that the problem has been solved.
Feel free to contact us if you have any further questions about UniDAC.

Post Reply