Connecting Crystal 8.5 reports to Oracle 7 via a CTD 2.1 app

forum.centura.team.developer (1998-2005) & forum.sqlwindows (2000-2005)
Mark Davis

Connecting Crystal 8.5 reports to Oracle 7 via a CTD 2.1 app

Post by Mark Davis » 01 Mar 2005, 04:41

 Posted by:  Mark Davis 

Hi all,

I have managed to successfully integrate Crystal 8.5 reports with my CTD 2.1
application, using ActiveX. However, it only works when connecting the
report to the database which was used to originally develop the report
template.

The Crystal Report Designer Component documentation says to use the
Application object method, implemented in CTD with the following function
call:

oApplication.LogOnServer( 'pdsora7.DLL', 'server_name', vDatabase, vUser,
vPassword ).

It says that if you leave server_name as blank, it will use the value saved
in the report, otherwise it will use the value you provide. I have found
that neither is true: it will only work if I provide the exact same
database name that was used to develop the report template. Any other value
produces OLE error 80020009 - "server is not yet opened".

Does anyone know of a solution for this?

Regards,

Mark Davis
RISE Development
Melbourne, Aust.

Return to “forum.sqlwindows”

Who is online

Users browsing this forum: [Ccbot] and 0 guests