Server has not yet been opened (Crystal report viewer control)

[Delphin]

I am using CR 8.5 developer with the RDC control in VB6. The reports run fine on my computer and all other standalones. When installing on the network, however I get the server has not yet been opened when attempting to view the reports.
Crystal has not been installed on the deployment machines and the rest of the program works perfectly via the ODBC settings. I have been in contact with crystal for hours and have yet to have this problem resolved.
This program is supposed to be ready for production within 2 weeks as the reports are the only integration left. The connection needs to remain VIA the ODBC as there are different servers at each location.
I was hoping that the new setup program would work, but it seems to have no affect. Any Suggestions?
Billy Billy Ballard

For in the past, Lies the future.

 

[steve99999]

I too was having this problem, but have just solved it using this command:

Report.Database.Tables(1).SetLogOnInfo ODBC, , Username, Password

In the def for this it says servername, but this needs to be the ODBC name(first parameter) thats what caught me out.

 

[Delphin]

I tried that and now I get the VB program asking for the Crystal reports disk. Billy Ballard

For in the past, Lies the future.

 

[Freedom319]

Check your permissions on your Stored Procedures if you're using some. I haven't received that error in a while but I know that was one of my problems when I first started writing VB apps that use the RDC.

 

[Delphin]

Not using Stored procedures (needed to design for 3 different DB). Do I need to set the login for each subreport? Billy Ballard

For in the past, Lies the future.

 

[chelseatech]

You say you are using ODBC, but where is the data behind that? DO you need to install an upgrade of MDAC? Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[Delphin]

Data right now is SQL server. MdAC 2.7 (not cluster)Crystal said something about logging on for every subreport, not sure why as on my standalone, i have no problem. Billy Ballard

For in the past, Lies the future.