DBExpress: TDBXError Too many connections

[Hardee Mahoney]

Hello,

I am using Delphi 2007 and MySQL 4.1.

I have a single TSQLConnection which connects to the database when my
application opens. I have a TSQLDataset with that connection. Then I use
that TSQLDataset over and over again with a different CommandText property.
I always close the TQLDataset after everytime I open it.

After not many calls I get the exception TDBXError: Too many connections.

Could someone give me some ideas as to what causes this error?

Thanks in advance,

Hardee Mahoney
Washington, DC

[Thomas Pfister]

Hello Hardee,
can you share some code ??

:-) thomas

HM> Hello,
HM>
HM> I am using Delphi 2007 and MySQL 4.1.
HM>
HM> I have a single TSQLConnection which connects to the database when
HM> my application opens. I have a TSQLDataset with that connection.
HM> Then I use that TSQLDataset over and over again with a different
HM> CommandText property. I always close the TQLDataset after everytime
HM> I open it.
HM>
HM> After not many calls I get the exception TDBXError: Too many
HM> connections.
HM>
HM> Could someone give me some ideas as to what causes this error?
HM>
HM> Thanks in advance,
HM>
HM> Hardee Mahoney
HM> Washington, DC