🚀 go-pugleaf

I assume you are using ADO Express (or dbGo as it is named in BCB6) and
MySQL is on your computer.

Native OLEDB provider for MySQL is at

http://www.mysql.com/Downloads/Win32/MyOLEDB.exe
http://www.mysql.com/Downloads/Win32/MyOLEDB.chm

1. Create new project.
2. Drop TADOConnection on main form.
3. Press "ConnectionString button" (...).
4. Press "Build".
5. Choose "MySQL.OLEDB Provider". Press "Next"
6. Set Data Source to "test".
7. Press Check Connection - it should be successfull.
8. Press OK.
9. Set LoginPrompt property to False;
10. Set Connected property to True.
11. Drop TADOTable on the form and set its Connection property to
ADOConnection1.
12. Set TableName to "sample2".
13. Set Active property to True.
14. Add TDataSource and TDBGrid on the form, connect them to ADOTable1 as
usual.

Now you should see data from sample2 table from test database (this database
goes with MySQL). Look ConnectionString property of ADOConnection1 in IDE
for details.

Connection string in my case is
Provider=MySqlProv.2.5;Data Source=test;Integrated
Security="";Password="";User ID="";Location="";Extended Properties=""
but
Provider=MySqlProv.2.5;Data Source=test;
works too.

You can do all this from source code.

P.S. If in Connection String dialog you will choose "MySQL.OLEDB Provider"
and press "Check connection" without setting Data Source, you will see a
dialog where you can enter properties, such as Host IP etc.

Regards,
Vassiliev V.V.
http://www.oledbdirect.com

"Alain ROGER" <pmdander@hotmail.com> ???????/???????? ? ???????? ?????????:
news:3D6A317F.2090107@hotmail.com...
> Hi,
> I would like to know if i'm able to use MySQL with BCB5 pro ?
> if yes, is there some tips or things to do to use MySQL with BCB ?
> TIA,
> Alain
>