Devart Forums

Im trying to understand "triggers" but its hard to get until where i can learn this. A lot of obstacels block me:

So i run The demos in Mydac. Problem number one is to install the demoSQL


(1) Where is the file.

MyDacDemo tells me to manually install "InstallDemoObjects" thas should be in the "MyDacDemo" folder. Its not its one level up.


(2) What database

There is no information in the SQL file about what database to use, so i manually create databse "test" and use this. Is this correct?


(3) InstallDemoObjects

I have MYSQL on another machine. When i run the installer i get this error:

-- Project MyDacDemo raised exeption class EMysqlException with message

-- #420000 Access denied for user 'root'@'% to database 'test'.


I dident have this problem before when i used "localhost" but i dont want to use localhost... I do have ROOT access so why cant mydac acess it?

Most (maybe all) tables are added in step 3 above, but still the "cant access" comes.

When i debug with DBmon i get this: (or this is the ending part)

Complete
2007-06-06 22:42:59 0:0.47 SQL Execute: CREATE TABLE MYDAC_Text (
UID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
Name VARCHAR(50),
TextField TEXT
)
Complete
2007-06-06 22:42:59 n/a SQL Execute: /*!50001
CREATE PROCEDURE `test`.`sel_from_emp`()
BEGIN
SELECT * FROM emp;
END
*/;
Pending

------------------

The "pending" i dont like...

Im using Delphi 7, Mydac 1,7 and 5.0.41 MySQL / Windows XP Home

MyDacDemo tells me to manually install "InstallDemoObjects" thas should be in the "MyDacDemo" folder.

MyDAC asks to to use the InstallDemoObjects file if there are errors when executing its own script. Often this error happen if there are objects with the same name in the database. You can remove such objects from your test database using the Drop button in MyDacDemo. Then try to create them once again using the Create button.

Its not its one level up.

Yes, this is a misprint. Thank you for information, we will fix it.

There is no information in the SQL file about what database to use, so i manually create databse "test" and use this. Is this correct?

Yes, this is correct. You can use any test database for MyDacDemo.

I dident have this problem before when i used "localhost" but i dont want to use localhost... I do have ROOT access so why cant mydac acess it?

MySQL considers a user connecting from different hosts (`localhost` and `my_host_name`) as two different users (`root@localhost` and `root@my_host_name`). So you should setup privileges for the `root@my_host_name` user.