Cannot load dbexpmda40.dll

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
Post Reply
usuallyconfused
Posts: 4
Joined: Fri 08 Mar 2013 08:16

Cannot load dbexpmda40.dll

Post by usuallyconfused » Fri 08 Mar 2013 08:41

I have been running a Delphi 7 program on a Windows 2000 terminal server, connecting to a MySQL database (v 4.1.15) for some years using the Devart dbExpress drivers and everything has worked fine.

However, I have just moved the system to a new Windows 2008 R2 (64 bit) terminal server. Initially, I installed the same version of MySQL but have subsequently installed the latest Community Edition in an effort to solve the problem below. I have also obtained the latest dbexpmda40.dll from Devart.

Since my program would not run, I created a small test program with only a TSQLConnection component on it and simply tried to connect to MySQL either using LoadParamsOnConnect to use the original dbxconnections.ini / dbxdrivers.ini files or by entering the connection parameters manually. In the same folder were the all the dll files which I might use for testing different configurations - dbexpmda40.dll, dbexpmysql.dll, libmysql.dll & midas.dll. (This is as I did before, with all the ini and dll files in the same program folder).

I tried different options for connecting, but always got an error message "Unable to Load dbexpmds40.dll".

My guess is that there is something about the security / permissions on the Windows 2008 server which is causing the problem and it isn't actually the driver which is at fault. But I am stuck.

Any suggestions as to what I might need to try?

Thank you.

DemetrionQ
Devart Team
Posts: 271
Joined: Wed 23 Jan 2013 11:21

Re: Cannot load dbexpmda40.dll

Post by DemetrionQ » Tue 12 Mar 2013 12:16

Hello.

For Delphi 7 you should use dbexpmda.dll instead of dbexpmda40.dll. You can read more detailed information on what driver library versions to use in different IDEs in the ReadMe.

usuallyconfused
Posts: 4
Joined: Fri 08 Mar 2013 08:16

Re: Cannot load dbexpmda40.dll

Post by usuallyconfused » Mon 18 Mar 2013 17:03

Thank you for the reply. I tried dbexpmda.dll originally and it didn't work but I have now tried a different version and it works! :D
Thanks again.

Jack Baird
Posts: 1
Joined: Wed 26 Mar 2014 19:14

Re: Cannot load dbexpmda40.dll

Post by Jack Baird » Wed 26 Mar 2014 21:22

usuallyconfused wrote:I have been running a Delphi 7 program on a Windows 2000 terminal server, connecting to a MySQL database (v 4.1.15) for some years using the Devart dbExpress drivers and everything has worked fine.

However, I have just moved the system to a new Windows 2008 R2 (64 bit) terminal server. Initially, I installed the same version of MySQL but have subsequently installed the latest Community Edition in an effort to solve the problem below. I have also obtained the latest dbexpmda40.dll from Devart.

Since my program would not run, I created a small test program with only a TSQLConnection component on it and simply tried to connect to MySQL either using LoadParamsOnConnect to use the original dbxconnections.ini / dbxdrivers.ini files or by entering the connection parameters manually. In the same folder were the all the dll files which I might use for testing different configurations - dbexpmda40.dll, dbexpmysql.dll, libmysql.dll & midas.dll. (This is as I did before, with all the ini and dll files in the same program folder).

I tried different options for connecting, but always got an error message "Unable to Load dbexpmds40.dll".

My guess is that there is something about the security / permissions on the Windows 2008 server which is causing the problem and it isn't actually the driver which is at fault. But I am stuck.

Any suggestions as to what I might need to try?

Thank you.
Did they ever get back to you on this? I'm having the same issue. Giving serious consideration based upon the response time to my own ticket to demanding a refund and trying a different product.

Dimon
Devart Team
Posts: 2888
Joined: Mon 05 Mar 2007 16:32

Re: Cannot load dbexpmda40.dll

Post by Dimon » Fri 28 Mar 2014 08:51

Please check that you deploy the 32-bit version of the dbexpmda40.dll library. This library is different for 32-bit and 64-bit applications.

prauss
Posts: 3
Joined: Sun 17 Sep 2017 19:27

Re: Cannot load dbexpmda40.dll

Post by prauss » Sat 13 Jan 2018 10:57

I have simillar problem with TDBXError40.dll.
I wrote apps for Win 10, 64 bits platform, and after starting it, there appeared message "Exception TDBXError40.ddl in Module ...".
I downloaded this TDBXError40.dll from any webseite in the net and put it into Windows\system directory, then into my app's directory but without success. Maybe it is not correct version of DLL?
I searched this DLL in my Delphi &Devards directories but without success ..:(

My first question, where can I download TDBXErro40.dll for 32 and 64 bits platform?
My second question is, where should I put this DLL?

Thanks for Your help.

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

Re: Cannot load dbexpmda40.dll

Post by ViktorV » Mon 15 Jan 2018 11:41

This question is not related to dbExpress driver for MySQL functionality, but to the IDE functionality, because TDBXError40.dll is a library of standard dbExpress driver that is distributed with RAD Studio, it is not our driver.
Therefore, in order to get an answer to your question, please refer to the IDE documentation, the IDE technical support or ask the appropriate question at the specialiazed forums.

Post Reply