<div>
Are you using the default mysql driver for this ? &nbsp;If that's the case, the mysql driver shipped with Delphi 7 was designed around 3.23 and a lot of the mysql internals have changed since then.<br />
<br />
I assume you're using the 3.23 client libraries to connect to 4.0 that that sooner or later will cause conflicts. &nbsp;I suggest you downgrade your server to the latest 3.23 and I'm sure your problems will be fixed.<br />
<br />
If downgrading is not an option, look for an alternative method for connecting to mysql other than dbexpress.
</div>


Are you using the default mysql driver for this ?  If that's the case, the mysql driver shipped with Delphi 7 was designed around 3.23 and a lot of the mysql internals have changed since then.

I assume you're using the 3.23 client libraries to connect to 4.0 that that sooner or later will cause conflicts.  I suggest you downgrade your server to the latest 3.23 and I'm sure your problems will be fixed.

If downgrading is not an option, look for an alternative method for connecting to mysql other than dbexpress.

<div>
problem is the same is 3.23 and 4.0 - as i have said in my other question (on the mysql page) it is the way dbExpress is working.<br />
<br />
I have seen on the net another company that produces dbExpress - do you know if their driver is any better?
</div>


problem is the same is 3.23 and 4.0 - as i have said in my other question (on the mysql page) it is the way dbExpress is working.

I have seen on the net another company that produces dbExpress - do you know if their driver is any better?

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
Does anyone know why the MaxStmtsPerConn in the TSQLConnection component always gets set to 1 when using mysql (v4) and dbexpress? &nbsp;<br />
<br />
Everytime i create a query a new connection is opened, i thought this could support loads of queries?<br />
<br />
This is causing me no end of grief as i soon run out of connections!
</div>
</div>


Hi

Does anyone know why the MaxStmtsPerConn in the TSQLConnection component always gets set to 1 when using mysql (v4) and dbexpress?  

Everytime i create a query a new connection is opened, i thought this could support loads of queries?

This is causing me no end of grief as i soon run out of connections!

Problem with MySQL via dbExpress - get invalid username/password after doing queries

Delphi is the most powerful Object Pascal IDE and component library for cross-platform Native App Development with flexible Cloud services and broad IoT connectivity. It provides powerful VCL controls for Windows 10 and enables FMX development for Windows, Mac and Mobile. Delphi is your choice for ultrafast Enterprise Strong Development™. Look for increased memory for large projects, extended multi-monitor support, improved Object Inspector and much more. Delphi is 5x faster for development and deployment across multiple desktop, mobile, cloud and database platforms including 32-bit and 64-bit Windows 10.