troubleshooting Question

Strange behavior Crystal Reports 7 with SQL2000 Stored P. on VB6

Avatar of JohnP_Realini
JohnP_RealiniFlag for Argentina asked on
Crystal ReportsProgrammingVisual Basic Classic
20 Comments2 Solutions367 ViewsLast Modified:
Hi guys

The scenario:

VB6 application which prints a report (CR7), which connects to a SQL2000 Stored Procedure, sending two parameters. The application connectos to the server via a UDL file

If I try testing the report from CR Designer, I get the data. When I run the report from VB6, I get 0 (it won't print, and I get an error in Windows Event Viewer that says it could not print because there was 0Kb information to print).

Important Info: A couple of weeks ago we set a password for the user the application was configured to connect with to the server. Then, when the report error was informed, I opened the report, and reconfigured it with the new logon information (usins MS Ole DB for SQL drivers)

Thanks for your help
ASKER CERTIFIED SOLUTION
JohnP_Realini

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 20 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 20 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros