question

Romao S2 avatar image
1 Like"
Romao S2 asked Jeanette F commented

Connection Failed with Error: libmySQL.dll

Hello, my connection to a MySQL database was working on Flexsim version 23 Update 1. The same connection does not work on newer versions (Update 2 and 2024).

1706636205004.png

FlexSim 24.0.1
mysql
1706636205004.png (66.9 KiB)
· 3
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot avatar image Jason Lightfoot ♦♦ commented ·
What have you tried to fix this? Can you access it from another application?

A quick search suggests that some people have solved it by installing the MS VC Redistributable download.

0 Likes 0 ·
Romao S2 avatar image Romao S2 Jason Lightfoot ♦♦ commented ·
Hi @Jason Lightfoot , I can access the MySQL database from other applications and everything works fine with Flexsim version 2023 update 1. I believe it is a bug in new releases because I asked my colleague to test it on a different computer and the same happened. So, I don't believe that everyone who wants to use a MySQL DB (that was used in previous versions) now has to install something.
0 Likes 0 ·
Jeanette F avatar image Jeanette F ♦♦ commented ·

Hi @Romao S2, was Matthew Gillespie's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.

0 Likes 0 ·

1 Answer

Matthew Gillespie avatar image
0 Likes"
Matthew Gillespie answered

FlexSim does not have a license to redistribute that DLL and it is no longer included in its installer. If you want to use a MySQL database connector you need to download that DLL from Oracle.

Our user manual explains how to do this: Setting up a Database Connection. If you follow that link and scroll down to the DLL Dependencies section (a blue box), it tells you how to download the file and set it up.

5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.