Viewing Crystal Report from different host.

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 root@192.168.1.100 (the address of server(A)).

I wish Someone Can help...

Thanks in advance.