Delphi 7 and mySQL 5

[MaggotMouth]

Hi.

Im running Delphi 7 and mySQL 5. Problem : The dbexpress components dont support mySQL 5 (or am I mistaken?). Where can I find an alternative to dbexpress or an update or something. Of course, me being a cheap ass, I need a FREEWARE solution. If anyone can help, it will be greatly appreciated.

Cheers

 

[towerbase]

MySQL 5 came out some time after Delphi 7 and so it is not surprising if the D7 MySQL drivers don't support MySQL 5.

I could never get the D7 dbExpress drivers to work reliably with earlier versions of MySQL.

I use MySQL 5 with Delphi 7 but I use and can recommend the dbExpress drivers from CoreLab

http://crlab.com/dbx/

They are not Freeware, but are reasonably priced.

I believe that a free alternative is to use ODBC and BDE but I've never tried that and I would guess there is a performance overhead (which may or may not matter to you).

Andrew
Hampshire, UK

 

[MaggotMouth]

Thx Andrew.

Sadly enough, I already had the Core Labs drivers and they expired. Unfortunately I dont have the money to pay for the drivers (the exchange rate is a bitch) and I really dont feel like paying for something when I'm writing the program as a favor to a friend.

I will check out the ODBC thing, tho I know squat about it.

Thx Again
Cheers

 

[buho]

Tower, can you clarify me a point?

BDE is a blocked path, Borland dropped it. A ODBC + ADO approach will not be better?

TIA.
buho (A).

 

[MaggotMouth]

Well, I kinda found a solution to my problem, so I'm posting it here. Hopefully some newbie like myself will see it before starting they're own thread.

The project is called Zeoslib and is available from

http://sourceforge.net/projects/zeoslib/

I havent completely tested it, but it seems to work.

Cheers

 

[towerbase]

buho,

I have never used ADO so I am unable to comment or recommend it.

For the last two or three years, all my database development work has used MySQL and dbExpress although I have had a look at SQLite.

Whilst the BDE may be a "blocked path" it still works but does have a number of limitations.

Andrew
Hampshire, UK

 

[buho]

Thanks, Tower.

I'm thinking about migratinag an old system from Access to something else, so I'm collecting opinions.

buho(A).