Database connects with machine with IDE but no other
Posted: 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
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