BorlandTalk.com

Guest

Hello!

I've created a soap web service with Delphi 8 that connects to Mysql
Database with Mysql .net connector 1.0.8.0.
I access the soap service from Delphi 7 app.

Everything works fine for a while, but then for some reason the mysql
connection hangs.
The webservice it self is accessible but when the service tries to
write etc to database the webservice hangs and fails to return
anything.

I connect to the database in webservices Create method. Here is the
method:

constructor FTCashierServices.Create;
begin
inherited;
InitializeComponent;
try
FSQLConnection := MySqlConnection.Create('Database=filmtown;Data
Source=XXXX;User Id=XXXX;Password=XXXX');
FSQLConnection.Open;
except
on E: Exception do

end;
end;

And in dispose method, I close the connection and free it.

Any ideas what might cause the hanging?

Thanks in advance!

Marko