Crystal Reports / Delphi 3 problem

[Janet Miller]

Hello -

Any one have experience with Crystal Reports VCL component for Delphi 3?

I get:
"Error: 599. Cannot open SQL server. Method: Execute <StartPrintJob>"
when trying to run a CR7 report on an Oracle database from Delphi 3.
The Crystal error codes say 599 means invalid log on information, such
as not specifying the server name, but I've tried all the valid server
information I can think of.

I've moved from CR6 to CR7 to take advantage of knowing the name of
parameters and formulas. I know the reports worked at one time, but
don't remember the last time I checked them and what has happened to my
machine in the mean time. I'm using the most recent CrystalVCL.dpc
(7.3.0.25), Oracle 7.3, Delphi 3, Win95.

I've tried both useConnect and useLogOnInfo, but both produce the same
error. I've tried creating a new, very simple report and the report can
be previewed from CR just fine; previewing from Delphi starts to show
the preview screen then creates error.

Anyone have an idea of other things to try?

Thanks.
jMiller
cojm...@ihc.com

[tmiller]

It would help to know your Oracle info and
exactly which server parameters you are
putting in which property.

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Application FrameWork
BSS VCL Pack

http://www.bss-software.com

[Janet Miller]

I was able to back up to Crystal Reports version 7.3.0.10 and things are
working again. I'm not sure if a default value has changed, or a new
property has been introduced that I need to set, or if crpe has a bug.

I don't know what Oracle information is important to the Crystal
component. I use a TDatabase component that is already connected to the
Oracle database and pull out the information from Params. It's Oracle7
Server Release 7.3.2.3.0.

Crpe1.ConnectMethod := useConnect;

Crpe1.Connect.ServerName := Database1.Params.Values['SERVER NAME'];
Crpe1.Connect.UserID := Database1.Params.Values['USER NAME'];
Crpe1.Connect.Password := Database1.Params.Values['PASSWORD'];
Crpe1.Connect.Propagate := True;

[tmiller]

I think you have your Crystal and Oracle versions
confused. Why are you setting Propagate to True?
If you don't have sub reports, leave it false.