🚀 go-pugleaf

Hi

I followed these steps made by Vassiliev. 

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

The only problem is that my settings are not stored (the host,
database, login and password), i have to enter it everytime i launch
my application, i tried the option store password etc but it doesn't
seem to work :/

Maybe i am doing something wrong(?)