MySQL and ODBC

I have been an avid MySQL and Perl developer for several years now. I have always used DBI and DBD for perl. Very familiar with this. But now I have to use Delphi.....

I have been assigned to write a Delphi application that stores data into a MySQL database. I really have no idea of how to do this and how to access MySQL from within a Delphi application. I would assume some type of ODBC connection.

Can anyone give me some hints and some links to go to so I can learn this? I'm sure it is not hard, but just not sure where to look. I tried googling for it, but links I found were not very informative.

Thanks.

There is two ways I know of to connect to a MySQL server in Delphi:
1. ODBC
Download the ODBC driver from http://dev.mysql.com/downloads/

2. Native API
You can download MySQL for windows and use the libmysql.dll file for native access to all MySQL functions without any restrictions.

This requires a header conversion from C to Delphi though.

I made a simple one myself. It's unfinished, not a component yet, and I didn't get to writing a simple example program demonstrating how to use it yet either.
Only the most basic functions are implemented right now. I didn't mean to publish it yet, but maybe it helps: MySQL native API unit for Delphi

M.

You can also use the ADODB components that come with Delphi to use ADO and open a connection to MySQL, or the BDE components and ODBC.