Question Locked

VB 6 & Crystal Reports 10

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hallo members.
I'm using crystal reports 10 to design reports, and run then from Vb 6 at runtime, with SQL Server 2005 backend. When I do so the reports are not updating the data that is added to the database. When I press the refress button, I get The error message: Login failed for user: sa. What should I do to get the data updated in the reports and to avoid the error message?

7 replies

by dr dij

going into the odbc setup (if that's what driver you're using) and test connection with this login.

Then ensure same connection info in your program connection string.

by lmarseng

Check to see if you can change the Datasource to use Windows Authentication or have the datasource remember the sa password.

by prosperychibuye

Hey things worked out. Will use Windows authentication.

Thanks a lot.

Also on program deployment. I want to delopy the same program to four computers. Did a deployment but system fails to install successfully on the other computers. It is only installing on my PC. Any suggestions?

by lmarseng

VB6 is horrible at deployment. Create a Setup package and list the DLLs that are needed with the program. You may have to copy the DLLs yourself into the System folder before the installation will properly work. Do you have a specific error message that comes up during the install?

Thx

by angelnefasto

Hi let me tell you, firstable when you design your report at Crystal reports designer you have to use the sa account and password and click in the integrate security box, check all your report and do this at any time it asks for password.

About the second question, there is a property for the creystal reports add at vb that names refresh, just use it as follows:
.refresh

by travelingsoldier

Hi I am a newbie to both VB 6 and CR 10.2
My task is to make changes in a report developed by earlier version of Crystal Reports. I edited the report using the Visual Studio 2005 IDE, but the edited report is not being recognised by the VB6 application . It throws an eror "Invalid TLV Record". Is there any way I can change my VB6 app to use CR 10.2. what dll's should I use to do this? Can you please send me a sample code of how did you use CR 10.2 report in the VB6 application? please help.

Thanks in advance,
Ramesh..

This discussion is closed to new replies.