I'm not sure offhand if Delphi 6 supports MySQL through the DB Express drivers (Kylix 3 does). If so, you can go that route. Otherwise:
You can get libaries such as the one from Core Lab: http://crlab.com/mydac/
or you can use ODBC drivers which you can find here: http://www.mysql.com/downloads/api-myodbc-2.50.html
There aren't any special tips I can think of. Connecting to MySQL via Delphi with any of the above is straightforward and the same as connecting to any other DB with Delphi. So far with both Delphi version 5 & 7, all the data aware controls work just fine with either the library (which I use all of the time now) or the ODBC drivers. You do still need to use a DataSource component with the Core Lab library if you are showing data in any of the data aware controls. For example to show some data in a grid with the Core Lab library:
MyConnection -> TMyQuery (also to a database) -> DataSource -> DBGrid
Bill Allaire Polytop Corporation
The Glide wrote:
Hi I am currently trying to use mysql 3.23 for a database project and connect to it using a Delphi 6 front end. Can anyone tell me how the connect to a MySQL database and any other tips they might have on using Delphi 6 with MySQL. I have never used MySql before and so the information needs to be pretty specific.
Hope someone can help
Thanks Clive Glasgow
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php