Devart Forums

Hi!

I have problem to connect with mysql with IdMappedPortTcp.
My mysql is in localhost with port 3306.... i have mapped port 4000->3306 with idmappedporttcp so i have tried to connect with Mydac on localhost and port 4000. TConnection connect with server but when i do an sql command or i use TQuery it disconnect. Who can help me?

object IdMappedPortTCP1: TIdMappedPortTCP

DefaultPort = 4000
MaxConnections = 20
ReuseSocket = rsFalse
TerminateWaitTime = 50000
MappedHost = 'localhost'
MappedPort = 3306
Left = 80
Top = 80
end

procedure TForm1.Button1Click(Sender: TObject);
begin
IdMappedPortTCP1.Active := true;
myconnection1.Connected := true;
myconnection1.GetDatabaseNames((memo1.Lines));
end;

Br,Alessandro

Unfortunately, we couldn't reproduce the problem in the way you have described: MySQL server wasn't turned off either on executing TMyConnection.GetDatabaseNames or on using TMyQuery. Please update MyDAC to the latest version (8.5.14). If this doesn't solve the issue, send us a small sample demonstrating the problem, including the script for creating and filling in the database objects.