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

[former_member11696]

Try SP 31:

https://blogs.sap.com/2020/10/30/upgrading-a-visual-studio-2008-2019-.net-project-with-the-latest-cr...

As Dell noted we don't read the password from the DSN so you need to set it in code.

Or use a file DSN but that can be a security issue.

Don

[former_member11696]

What SDK are you using?

What version of Crystal Reports are you using?

Is your app using 32 or 64 bit platform, ODBC client must use the same platform for your App to connect.

[paul_aziz]

I am using 32 bit

[paul_aziz]

CRforVS13SP30 and I am using 32 bit

[paul_aziz]

I have finally got my report working thanks to your suggestion.

I did fresh install of my app as well as MySQL ODBC driver and then set up DSN and that's it. It run without prompt for password.

Thanks so much.

Paul