Database connects with machine with IDE but no other

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
Post Reply
Gikas
Posts: 2
Joined: Thu 20 Apr 2017 11:59

Database connects with machine with IDE but no other

Post by Gikas » Tue 25 Apr 2017 18:59

Delphi XE10.0 (Seattle)
DevAr dbExpress driver for MySQL 6.9.1.3

Problem - the compiled program runs on a comuter that has the Delphi XE 10.00 IDE installed, but not on a different computer.

Am I missing a driver?


Here are my settings:
with connDiamondLife do
begin
DriverName := 'DevartMySQLDirect';
LibraryName := 'dbexpmda40.dll'; // <library name> depends on your IDE version. See the table below.
VendorLib := 'not used';
GetDriverFunc := 'getSQLDriverMySQLDirect';
Params.Clear;
Params.Add('User_Name='+Dl_Lic.FieldByname('User_Name').AsString);
Params.Add('Password=' + Dl_Lic.FieldByname('Password').AsString);
Params.Add('HostName=' + Dl_Lic.FieldByname('HostName').AsString);
Params.Add('Database=' + Dl_Lic.FieldByname('Database').AsString);
end;
try
connDiamondLife.Open;
except
begin
showmessage('UNABLE TO CONNECT TO Company DATABASE - Application Terminating');
Halt;
end;
end;

Here are the drivers I have on the non IDE computer

dbExpMDA40.dll
LibMysql.dll (I believe I don't need this for DevArt but I need it for a different connection)


Please help

Thank you

Gikas
Posts: 2
Joined: Thu 20 Apr 2017 11:59

Re: Database connects with machine with IDE but no other

Post by Gikas » Wed 26 Apr 2017 00:54

Resolved: Use the Win 64 version of DBExpMDA.dll when working on 64 bit machines

The 2 drivers can be found in the \\windows\system (32 bit) and the \sysWOW... (64 bit) of the machine that you install the component on

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

Re: Database connects with machine with IDE but no other

Post by ViktorV » Wed 26 Apr 2017 10:45

We are glad to see you have found a solution.
Feel free to contact us if you have any further questions about our products.

Post Reply