Skip to Content
0
Sep 08, 2023 at 07:54 PM

Keep getting prompted to enter Login ID and password

227 Views

I'm using Visual Studio 2017, VB.NET 2017, MySQL, Crystal Reports 2016 and Windows 10. I have installed
MySQL Connector/ODBC 5.3. I built a 32 bit User DSN using the MySQL Connector/ODBC. When I click the
"Test" button to check the connection, "Connection Successful" is displayed. When the Crystal Reports
designer is displayed and I click on "Database Expert", I can see the DSN I created and I can select one
table in my MySQL database. I am attempting to display my report in a Crystal Reports Viewer control. I
have set the "ReportSource" property to the Crystal Report I want to display. When I run my program,
just before the report contents should appear in the viewer, a "Database Login" window appears prompting
me to enter a Login ID and a Password. Why is this window appearing when the Login info is stored in my
User DSN? I can access all tables in my MySQL database using VB.NET code. It is only with the Crystal Reports
Viewer control that I can't access my tables.