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?
Installing and acessing demobase
Add to previous
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
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
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.MyDacDemo tells me to manually install "InstallDemoObjects" thas should be in the "MyDacDemo" folder.
Yes, this is a misprint. Thank you for information, we will fix it.Its not its one level up.
Yes, this is correct. You can use any test database for MyDacDemo.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?
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.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?