Avatar of ROB MCCONNELL
ROB MCCONNELL
 asked on

DB Connection error to Crystal Report

I have a number of Crystal reports from the same VB.net program that are not accepting / transferring / referencing the database details for the connection.  Attached is the screen shot of the error message and the code that is used to populate the connection.

Can someone please shed some light on the issue?
DBConnection.PNG
DBCode.PNG
Visual Basic.NETDatabasesCrystal Reports

Avatar of undefined
Last Comment
ROB MCCONNELL

8/22/2022 - Mon
Mike McCracken

I don't see the error.

What changed recently?

Did the database password change?  expire?

mlmcc
ROB MCCONNELL

ASKER
The error is that within the code it is assigning all the relevant data to the variable to open the connection to the database. Now as you may see with the connection when loading the Crystal report there is no Table name and no password.

Nothing has changed other than updates to the PC.

Database Password hasn't changed or expired
ASKER CERTIFIED SOLUTION
Mike McCracken

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Mike McCracken

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ROB MCCONNELL

ASKER
mlmcc,

Thanks for the response. I have followed the article and all the links to other opinions etc,  Still no joy. Im at the point now that I will be rewriting the reports and then the software to see if that there is anything in there.  That is if anyone doesnt have any better ideas