I have C#.net 2010 environment with Mysql server 5.1 and Crystal Report 10.
I'm trying to connect to mysql sever (A) from another host (B) where I should deploy my app.
The problem that I can't connect to mysql server through crystal report while my application is running,but my whole application can work with mysql server with no problem in connection.
The problem that I face is with crystal report connecting to mysql server.
note that I used ODBC connector, and I've tried ADO (xml) with the same problem.
every time crystal report gives an error : users access denied to root@localhost, if I switch mysql service in the 'host (B)' to on.
Thats because the application searching for the database from the localhost in host (b) with the local root username, but I want it to access directly to 'mysql server (A)' by firstname.lastname@example.org (the address of server(A)).
I wish Someone Can help...
Thanks in advance.