Accessing MySql via Delphi

[gxydas]

Hi everyone,
I'm using Delphi 7 and I was wondering if there is a freeware component collection for accessing MySql DBMS (DataBase, Table, Query e.t.c.).
And something else... what version of MySql should I use;
Thanks anyway.
George

 

[towerbase]

Have you tried using the dbExpress components which come with Delphi 7 ?

There are freeware components available. I suggest you use Google to search for Delphi and MySQL ?

Check out the

http://www.mysql.com

site for the status of the latest versions of MySQL. It all depends on what you want. For example, are you prepared to risk an Alpha or Beta version for increased functionality?

Andrew
Hampshire, UK

 

[pwesson]

I purchased DAC for MySQL™ and am very happy with it...

http://www.microolap.com/products/connectivity/mysqldac/

Paul Wesson, Programmer/Analyst

http://www.ipaw.net

 

[svanels]

Try Zeos opensource database components

http://www.zeoslib.net/

Steven van Els
SAvanEls@cq-link.sr

 

[AP81]

Hey gxydas,

I was in the same place as you not too long ago, when I discovered Direct Mysql Objects. I dabbled with all of the above, but found Direct Mysql Objects. It's completely free and is ultra fast. It has a DIRECT connection to the database...no ADO, nothing.

I mainly use it for loading information into comboxes & stringrids as well as INSERT,DELETE,TRUNCATE,UPDATE commmands. I can insert over 8000 lines into a database table in under 30 seconds.

Take a look at

http://www.webclass.ru/eng/Tutorials/Delphi/MySQL_and_Delphi.html

It will point you in the right direction. If you are having trouble, reply back and give me your email address.

Just unzip the zip file and add uMySqlVio, uMysqlCT, uMysqlClient, uMysqlHelpers to your Delphi/Lib folder or put them in your project directory and you're away!

Good luck.




------------------------------------
There's no place like 127.0.0.1
------------------------------------