🚀 go-pugleaf

Hi

i did these steps to get MySQL work with BCB 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.

So far so good but even tho i checked loginprompt false etc it asks me to
enter my login details everytime i start my application, i tried the store
password option etc but nothing seems to work, am i doing something wrong
here(?).