Page 1 of 1
Looking for simple example or tutorial
Posted: Sat 23 Sep 2006 04:28
by mem5922
Would like to try out the MyDAC trial but can't find HELP with how to apply the components on a form. Can anyone point me to a simple example or tutroal for the MyDAC components? As a test, I simply want to access a MySQL database on a network drive (on my LAN) and see data in a table(s). Thx
-Mike
Posted: Mon 25 Sep 2006 11:16
by Antaeus
When installing MyDAC creates menu item in the Delphi main menu. It is named "MyDAC". You can call MyDAC Help from this menu. Also you can download MyDAC help in printable format by
this link.
You can find MyDAC demos in %MyDAC%\Demos\ directory.
%MyDac% is the MyDAC installation path on your computer.
Error on compiling/running demo
Posted: Mon 25 Sep 2006 16:12
by mem5922
Antaeus,
Thanks for your reply. I did find these demos but have not figured out what are the minimum components that must be dropped on a form to access any MySQL data BUT I will read through the printed help further. I am using D7.
BTW, I am trying to analyze the TABLE demo so I can see how it works BUT I get the follwoing when I try to run it:
[Fatal Error] Main.pas(8): Unit MyAccess was compiled with a different version of MySQLMonitor.TMySQLMonitor
[Fatal Error] Main.pas(11): File not found: 'MyDacClx.dcu'
Posted: Tue 26 Sep 2006 08:53
by Antaeus
> what are the minimum components that must be dropped on a form to access any MySQL
Following components are enough to get browsable and editable recordset:
1) MyConnection
2) MyTable or MyQuery
3) DataSource
4) DBGrid and DBNavigator
> BUT I get the following when I try to run it:
Please see description about solution of this problem in
this topic.
Missing the other components on DAC mySQL tab
Posted: Thu 28 Sep 2006 01:34
by mem5922
Antaeus,
I followed all the instructions on the link you sent. Thx. I finally got D7 to load cleanly without dac70.bpl error. I then re-ran mydac7 and did install. However, the ONLY component that loaded on the DAC mySQL tab is MySQLMonitor. I do have the MySQL menu item up top though.
What did I do wrong this time??
Mike
Posted: Thu 28 Sep 2006 14:08
by Antaeus
Please check if you have installed any other component set that includes MySQLMonitor component. Possibly this component set conflicts with MyDAC. Try to uninstall MyDAC and component set that conflicts with it and install MyDAC only. If MyDAC will not appear on the component palette then call Component | Install Packages from main menu of IDE and check if you have installed MyDAC packages and they are enabled (tick must appear in box). Package names are following:
1) CoreLab Controls
2) Core Lab Data Access GUI related Components
3) Core Lab Data Access Components
4) MySQL Data Access Components
5) MySQL Data Access GUI related Components