Looking for simple example or tutorial

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
mem5922
Posts: 4
Joined: Sat 23 Sep 2006 04:22
Location: CA, USA

Looking for simple example or tutorial

Post by mem5922 » Sat 23 Sep 2006 04:28

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

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Mon 25 Sep 2006 11:16

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.

mem5922
Posts: 4
Joined: Sat 23 Sep 2006 04:22
Location: CA, USA

Error on compiling/running demo

Post by mem5922 » Mon 25 Sep 2006 16:12

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'

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Tue 26 Sep 2006 08:53

> 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.

mem5922
Posts: 4
Joined: Sat 23 Sep 2006 04:22
Location: CA, USA

Missing the other components on DAC mySQL tab

Post by mem5922 » Thu 28 Sep 2006 01:34

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

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Thu 28 Sep 2006 14:08

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

Post Reply