"Server Not Yet Opened" Using CR8, VB6 & RDC.. HELP!!

[NipsMG]

I'm totally baffled here.

I wrote a program that houses about 5 or 6 reports, all of which get their data from ADO Recordsets using Field Definition Files (TTX Files).

On the development machine, all of the reports load and run fine.. However, on ANY OTHER MACHINE, The reports do not load.. The report viewer form loads up, and says "Server has not yet been opened.".

I've tried copying over and registering all of the DLL's from the \program files\seagate software\Report Design Component\ files over to the target computer. I've also tried copying all of the dll's from the Crystal folder to the target machine, but I am still unable to open the reports, getting the same error.

Does anyone have any idea why this is happening and/or how to fix it?

By the way, both machines have VB6Sp3, Cr8 and MDAC2.5 installed.

Thanks in advance.

--NipsMG s-)

 

[Ruairi]

you were on the right track. all you have to do to make crystal reports work is copy and register EVERY #*%@ing dll on the development machine. I do mean every. I am going through the same problems, and i have been using crystal since VB5. Seems like with every new version the rules for how to Jerry rig this piece of #@$% change. Here are a couple of gems from the wonderful bastards' "support"(i use the term very, very, very llosely) site. They havent helped me get it working, but maybe your luck will be better.

************* Gem #1
Synopsis

A Microsoft Visual Basic application uses the Report Designer Component (RDC) as the reporting development tool.

When you attempt to preview a report that uses a SQL type database, the following error appears:

'Server has not yet been opened'


Solution

This error appears because the report object was declared incorrectly as:

Dim report as CRAXDDRT.Report

To resolve this error message, declare the report object as:

Dim report as CRAXDRT.Report

Note: =======

Craxddrt.dll is used to create reports at runtime while craxdrt.dll is used to view and alter existing reports.

===========
****************


i lied, just one gem. at first read i thought your problem was more similar to mine. Anyway, i hope this helps.

Ruairi

Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.

http://www.plccontroltechnologies.com