VB app using Crystal

[Guest_imported]

Good Day,
I have a VB application which runs a Crystal report, print certain pages and exports it as a .RTF to a dedicated drive. (use RDC) This application has been running happily now for 3 months on a Win 98 server.
I am now trying to run the exact same code off a Win 2000 Professional machine - and I get the dreaded
Error No:-2147192184 "Server has not yet been opened." error.
I installed Crystal Developer 8.5, I am using VB 6.0.
I have looked at most threads and papers on this error, but none seems to solve my problem.
Any ideas would be appreciated - it is getting critical (doesn't it always ;-) )

Best Regards,

 

[balves]

You're not connecting to the server for a variety of possible reasons including:

- new machine doesn't have MDAC kit installed
- you're using an ODBC DSN and it's not defined on the new machine
- missing DLL(s); maybe the Windows kit for your application didn't install perfectly on the new machine

 

[Guest_imported]

Thank you for your reply.
I have the ODBC DSN installed obviously (the report runs in Crystal)
For completeness sake I did register all relevant DLL's again.
As for MDAC - well, I will check that, but will be very surprised if that was the problem.
Any other suggestions will be greatly appreciated.

Rgds

 

[balves]

What version of Crystal do you have?

There are some updated DLLs for V8 on the Crystal web site, including P2SODBC.DLL.

 

[Guest_imported]

Referring to my first post, I am using Crystal Developer 8.5

 

[kenhamady]

Do you have a line of code in the app that connnects the report to the database, like LogOnServer or SetLogonInfo? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com