mySQL Connection prompt

rahulmes · Post by **rahulmes** » Tue Jun 21, 2011 9:14 pm

I have created a report that retrieves data from a mySQL database. Everything is working fine, but the problem is that I am prompted to enter the user name and password each time I generate the report in ViewerFx. I have tried unchecking the 'Prompt User Name and Password' checkbox in the Edit connection dialog box, but if I do so, the connection is not being made and the report is not generating. If I check the box and say Test, enter the credentials in the prompt box, then the connection takes place and the report generates. How can I generate the report without entering the credentials each time? This is my connection string: Server=localhost;Port=3306;Database=crm;User=root; Password=webadmin123;

Thanks.

rahulmes · Post by **rahulmes** » Thu Jun 23, 2011 9:11 am

Any reply, please. Thanks.

Post by **Vladimir** » Fri Jun 24, 2011 8:14 am

Hello,

If you use the connection string with defined 'User' and 'Password' parameters without the 'Prompt User Name and Password' option, when used this specified values to connect to the database. If you set the 'Prompt User Name and Password' option, the user name and password will be asked for each generation of the report.

If you specified the correct user id and password and the connection does not occur correctly, please try to upgrade to the latest prerelease build.

As well make sure no extra spaces in the connection string (in your example, before a password parameter a space is present).

Thank you.

rahulmes · Post by **rahulmes** » Sun Jun 26, 2011 7:16 pm

Thanks, Vladimir. It was the extra space which was causing the problem. It is working fine now.

Post by **Andrew** » Sun Jun 26, 2011 10:11 pm

Hello,

Thank you for letting us about the issue solved.

Let us know if you have additional questions.
Thank you.