I've previously been able to make use of a 'CRViewer' (Crystal reports Viewer) component from a Delphi 5 application. This has always been against SQL Server 7.0 database tables up until now.
I have generated a report that runs against a Paradox Table (through an ODBC connection).
The report makes use of a number of parameters which are fed to the report file from the Delphi front-end.
The application and subsequent report work fine (passing parameters as required).
HOWEVER, as soon as I make use of a DataSet component (in this case a TQuery to list supplier codes), opening it and then closing it, if I then run the report I get a crash (at design time) and get the gray CPU panel (with codes displaying errors). Similarly I get 'Project ..... faulted with message 'access violation at .... Read of address ... Process stopped. Use Step or Run to continue'.
The report that previously did work fails if a TDataSet is used in the calling form (albeit opened and closed).
AND looking at the BDE Administrator - the PARADOX driver which was previously set as "ascii" ANSI has now been set to 'Borland ENU Latin-1'.
I have tried this on a number of machines.
The first 2 have Windows 2000 SP2 and present the errors as listed above.
One machine with Windows NT operates OK and generates the report in the above instances.
Another machine with Windows NT presents a different error '[Driver error]. Table is not of expected format.'
I am not passing any log-on information to the reports - is this my error ?
I think the fact that Service Pack 2 has recently been installed on the Windows 2000 machine is the fault as an application (that previously worked using the same principal against SQL Server) now presents a 'Server has not yet been opened' error.
Can anyone offer any pointers for this ?
Has someone who has generated reports on Windows 2000 SP2 machine against Paradox tables got any advice ?
Thanks in advance.
Steve
I have generated a report that runs against a Paradox Table (through an ODBC connection).
The report makes use of a number of parameters which are fed to the report file from the Delphi front-end.
The application and subsequent report work fine (passing parameters as required).
HOWEVER, as soon as I make use of a DataSet component (in this case a TQuery to list supplier codes), opening it and then closing it, if I then run the report I get a crash (at design time) and get the gray CPU panel (with codes displaying errors). Similarly I get 'Project ..... faulted with message 'access violation at .... Read of address ... Process stopped. Use Step or Run to continue'.
The report that previously did work fails if a TDataSet is used in the calling form (albeit opened and closed).
AND looking at the BDE Administrator - the PARADOX driver which was previously set as "ascii" ANSI has now been set to 'Borland ENU Latin-1'.
I have tried this on a number of machines.
The first 2 have Windows 2000 SP2 and present the errors as listed above.
One machine with Windows NT operates OK and generates the report in the above instances.
Another machine with Windows NT presents a different error '[Driver error]. Table is not of expected format.'
I am not passing any log-on information to the reports - is this my error ?
I think the fact that Service Pack 2 has recently been installed on the Windows 2000 machine is the fault as an application (that previously worked using the same principal against SQL Server) now presents a 'Server has not yet been opened' error.
Can anyone offer any pointers for this ?
Has someone who has generated reports on Windows 2000 SP2 machine against Paradox tables got any advice ?
Thanks in advance.
Steve