VB6.0 - CR8.0 How to distribute?

[Corinne]

SO sorry to repost this but I forgot the Subject

Hello,
I'm having some problems with packaging my application and having the crystal report being shown within the application. I'm using: VB6.0, Crystal 8.0 RDC, SQL7, NT I think that's all the imformation you might need at this point to help me with my question. I've finished the application and beginning to move toward user acceptance testing. I wanted to put the compiled VB app on the client machine but I am having some problems. When I run the .exe on the client machine the program runs fine but when I click to show the report the RDC viewer box comes up on my screen just like in design but I get a message box that says "Server has noy yet been opened." What have I missed when creating the package? I'm assuming that I missed some sort of .DEP or .DSR file but I'm really unfamiliar at this point. I had thought that by including the correct file in the package that it was easy to install just the setup on the client machines. Do I have to set up DSN's on all the client machines?
I'm at a loss and information or direction anyone could give me would be appreciated.

Thank you,
Corinne

 

[balves]

"Server has not yet been opened" means that you did not connect to the database.

How are you connecting in VB for the Crystal Report? Are you using .LogonServer or .SetLogonInfo? If so, are they referencing an ODBC DSN that you have not defined on the client PC? Brian J. Alves
Terrier Consulting, Inc.
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer
(Currently available for consulting in Chicago)

 

[Corinne]

Hello,

Thanks for responding. I have not used either .LogonServer or .SetLogonInfo to connect VB to the crystal report. I'm unsure of what you mean that it hasn't connected to the database yet. At the point of the viewer popping on my screen I have a recordset from the database which is open. I'm very confused. If you respond back please give me some more background on how they relate together.

Thank you,
Corinne

 

[Guest_imported]

As for Brian J. Alves the reports which r supposed to retrive the data are not connected to the database. When not connected this error comes. Plz try out this..

AppObject.LogOnServer Dllname,LogOnServerName,connect_string, User id,Password

This should do..

 

[badgujar]

I have added a .dsr file in vb project. I am trying to call that file from a vb form. But it is giving me error as "server not opened yet". If it is called from outside i.e. if .rpt file is called then it opens the report.
I am very confused.