Cannot load dbexpmda40.dll
Posted: 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.
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.