How can I make an ODBC Connection with Applications Manager DB and then query it with crystal reports ?
You can make ODBC connection from localhost, that is you can make connection from the machine where Applications Manager is running. If you want to access mysql from remote machine, you have to give permission in user tables. Connect to mysql and execute following commands, INSERT INTO user (Host,User,Password) VALUES(‘host name with domain name’,’root’,PASSWORD(‘appmanager’)); GRANT ALL PRIVILEGES ON *.* TO ‘root’@’host name with domain name’; FLUSH PRIVILEGES; For eg., INSERT INTO user (Host,User,Password) VALUES(‘appmanager.adventnet.com’,’root’,PASSWORD(‘appmanager’)); GRANT ALL PRIVILEGES ON *.* TO ‘root’@’appmanager.adventnet.
