BorlandTalk.com

doug · Guest

Hi Folks,
I would like my delphi app to tell Crystal (10) to log on to the
SQL database before I pull up any reports, and I want all of
the reports to use the resulting connection. Problem is that I
can't get LogonServer to LogOn. Works fine with DLLName =
pdssql.dll, but not with ADO (DLLName = crdb_ado.dll). I would
convert all of my reports to use pdssql.dll, but I don't know
how. Anyone know?

Here's what I am trying on FormShow:

i := Crpe1.LogOnServer.Add('SERVERNAME');
with Crpe1.LogOnServer[i] do
begin

DLLName := 'crdb_ado.dll';
UserID := 'user';
Password := 'password';
DatabaseName := 'dbname';
if LogOn then
ShowMessage('The Logged On')
else
ShowMessage('Error Logging on to Server');
end;

doug · Guest

Followup:

It appears that the LogOnServer functionality is not working
if crdb_ado.dll is specified either in VCL or in RDC
(Crystal 10). "Logon Failed" is the result either way.
The idea is to save time in the report init
(hopefully) by directing all subreports to a common session
that can be initiated before any reports are requested.

If anyone has this working, please let me know. Thanks,
Doug