ODBC Connection over network

[paul_aziz]

Hello everybody,

I have setup ODBC connection for my reports in my project. The reports pull data remotely from MySQL database server. Everything works well when the report is accessed on the server

But Crystal report keeps prompting for password when a client machine tries to run report even though I have setup ODBC DataSource Connection on each client.

Please find below ODBC DataSource Connection parameters for both server and clients

Server:

Data Source Name: MySQL Local Server

Description : MySQL Local Server

TCP/IP Server: localhost

Port:3306

User: xxxxxx

Password: xxxxxx

Database: xxxxxxxxx

Client:

Data Source Name: MySQL Local Server

Description : MySQL Local Server

TCP/IP Server: xxx.xxx.x.xx

Port:3306

User: xxxxxx

Password: xxxxxx

Database: xxxxxxxxx

Thanks in advance for your assistance

[DellSC · Accepted solution]

Crystal does not save the password with the report. Are you setting the password in your code? If not, you need to do so.

-Dell

[paul_aziz · Accepted solution]

No, the password is set in the DNS

[DellSC · Accepted solution]

Generally, the password that's set when configuring the DSN is only used for testing the connection in the ODBC Administrator tool - it isn't actually available to applications that use the ODBC DSN.

-Dell