Re: [DUG]: Delphi and Crystal on NT4
-Original Message- From: Belding [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Date: Thursday, March 11, 1999 7:58 AM Subject: Re: [DUG]: Delphi and Crystal on NT4 Thanks Steve for your comments. I'm using the 16bit Dlls from CR ver 5.0.1.108. CR help replied within an hour to a request made at their WWW site with several things to try. Particularly doing a comparison of DLLs loaded on a PC when the reports run OK and on an NTWS4 box where the repoarts all fail. The tool to use for this is their DSX.EXE (16bit). Okay I wouldn't myself knowingly install or sell 16 bit software on NT :). **It would help to identify the database file format or server you are trying to report on**. From there we can list the minimum DLL's and known good versions. Crystal has an annoying tendency to load all dlls at the same base address which requires endless "rebasing". Some of the user defined dlls are a bit brittle and they can be loaded even when not called. So you need a minimalist \crystal directory. Also if say you are using oracle native (via SQLNet/Oracle Call Interface) Crystal will dump some of this stuff off its own CD in \system32 when there are perfectly good if not later versions in orant\bin. Guess which stuff gets loaded first? So dll pollution can be a problem. It is even worse if you have 16 bit Visual Basic installled coz then you will get the cut down version of Crystal sprayed in different places, some of which works with CR5 and some of which doesn't. Nice. If you are using BDE as middleware to your data, as you appear to be, then Crystal Reports usually 1.ships with an out of date BDE, at least 32 bit anyways. 2. It may blindly create a new BDE directory under its own crw32 directory and try and make this current. Sometimes it will append the path to this new BDE directory at the end of the path stored in the registry, creating havoc when the BDE goes looking for dlls. Try installing CR5 prior to any subsequent BDE installs.Try the NT registry? May not be important for 16 bit BDE. Unlike Rohit, I have found them pretty good although that might be due to the nice pen set air freighted by marketing after a particularly pleading email. The web portal is pretty crude but I have found that they will reply within 5 days usually and you need to give detailed technical posts to ensure it goes to software engineers first off. Gee, they have even been willing to share code from future releases (Excel export dll). As a developer tool its second to none in my opinion. Crystal Reports and big sister Crystal Info/Crystal Info SDK can do virtually anything. The next version will probably have VBA scripting chucked in as well. Stick with it. The most likely cause is a missing DLL, I think. Would you agree? At worst I could strip all the reports out into a D4 program, even if that meant installing two BDEs on a server. Yep missing, duplicated or inaccessible. I mean it works for millions of others, so its just a snag Cheers. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Delphi and Crystal on NT4
-Original Message- From: Belding [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Date: Wednesday, March 10, 1999 5:26 PM Subject: [DUG]: Delphi and Crystal on NT4 Hello team Anyone using Delphi with Crystal Reports on NT4? 32 bit Works well. If you have 16 bit tools Seagate Software will not help you if you are a Delphi developer either. You will likely have little joy with versions prior to 5.x.108 and anything other than 32 bit Delphi. The Seagate developed VCL wrapper around crpe32.dll for v5, 6 or 7 is more powerful than the COM/VB equivalents. With NT 4 (sp?) the reports won't run and I get an error "cannot open database" from the Crystal DLL. You will have to specify the database type, database version, Crystal Reports type, version, platform and the method you are using to interface with the Crystal Reports Print Engine DLL i.e OCX, CRPExx.dll imports, VCL (D2,3,4, CB1,3 with source) or the Automation Server, as well as the version of the BDE, ODBC, ADO, or native connection you are trying to hook up to Crystal Reports. Sounds like a configuration issue."Unable To Open Database File" is an OCX error which implies a Database verify may be required or the pathname is too long esp wih Access, or maybe some UNC pathing problems. If you are using an ActiveX bridge to Crystal Reports then there are a host of OS and Microsft DLL redistributables to factor in. Any insight would be hugely welcome. ftp.img.seagatesoftware.com/pub/crystal and /pub/seagate_crystal_reports is full of software samples, fixes, extensions etc. Http access gives you some of this: http://www.img.seagatesoftware.com/crystalreports/techsupp/ You may find benefit by consulting the newsgroups hosted at www.cogniza.com or the alternative Crystal Report VCL at www.suprasoft.com or end user info @ www.crystaluser.com ftp://ftp.img.seagatesoftware.com/pub/seagate_crystal_reports/delphi/crvclap p.exe is a handy test tool written in Delphi with source. Cheers, Steve Cooney Pacific Windows --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Delphi and Crystal on NT4
Thanks Steve for your comments. I'm using the 16bit Dlls from CR ver 5.0.1.108. CR help replied within an hour to a request made at their WWW site with several things to try. Particularly doing a comparison of DLLs loaded on a PC when the reports run OK and on an NTWS4 box where the repoarts all fail. The tool to use for this is their DSX.EXE (16bit). The most likely cause is a missing DLL, I think. Would you agree? At worst I could strip all the reports out into a D4 program, even if that meant installing two BDEs on a server. RB At 23:15 10/03/99 +1300, you wrote: -Original Message- From: Belding [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Date: Wednesday, March 10, 1999 5:26 PM Subject: [DUG]: Delphi and Crystal on NT4 Hello team Anyone using Delphi with Crystal Reports on NT4? 32 bit Works well. If you have 16 bit tools Seagate Software will not help you if you are a Delphi developer either. You will likely have little joy with versions prior to 5.x.108 and anything other than 32 bit Delphi. The Seagate developed VCL wrapper around crpe32.dll for v5, 6 or 7 is more powerful than the COM/VB equivalents. With NT 4 (sp?) the reports won't run and I get an error "cannot open database" from the Crystal DLL. You will have to specify the database type, database version, Crystal Reports type, version, platform and the method you are using to interface with the Crystal Reports Print Engine DLL i.e OCX, CRPExx.dll imports, VCL (D2,3,4, CB1,3 with source) or the Automation Server, as well as the version of the BDE, ODBC, ADO, or native connection you are trying to hook up to Crystal Reports. Sounds like a configuration issue."Unable To Open Database File" is an OCX error which implies a Database verify may be required or the pathname is too long esp wih Access, or maybe some UNC pathing problems. If you are using an ActiveX bridge to Crystal Reports then there are a host of OS and Microsft DLL redistributables to factor in. Any insight would be hugely welcome. ftp.img.seagatesoftware.com/pub/crystal and /pub/seagate_crystal_reports is full of software samples, fixes, extensions etc. Http access gives you some of this: http://www.img.seagatesoftware.com/crystalreports/techsupp/ You may find benefit by consulting the newsgroups hosted at www.cogniza.com or the alternative Crystal Report VCL at www.suprasoft.com or end user info @ www.crystaluser.com ftp://ftp.img.seagatesoftware.com/pub/seagate_crystal_reports/delphi/crvclap p.exe is a handy test tool written in Delphi with source. Cheers, Steve Cooney Pacific Windows --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Delphi and Crystal on NT4
While we are on the subject, is the latest version of Crystal able to use the BDE (32 bit) or must I have ODBC drivers installed - we use Interbase. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Delphi and Crystal on NT4
Russel, I use Crystal with Delphi. I have had absolutely no help from their support email address. I finally complained to the president after two weeks of continual email. That produced the help that I needed. It turns out that if you mis-fill their forms, they are just junked. And the beggars insist that no one else has any problems with the email support. There are various other issues such as misinformation in articles in various mags and I wouldnt recommend Crystal to anyone. I have already written to the editors in question asking them to stop doing their readers a dis-service by stopping any future articles on crystal. Your problem does sound like missing or mismatched DLLs. They are a mess with different version number working with each other etc... and they almost never complain about the mismatch of version numbers, instead you get starnge non-sensical messages. On 11 Mar 99 at 7:40, Belding wrote: Thanks Steve for your comments. I'm using the 16bit Dlls from CR ver 5.0.1.108. CR help replied within an hour to a request made at their WWW site with several things to try. Particularly doing a comparison of DLLs loaded on a PC when the reports run OK and on an NTWS4 box where the repoarts all fail. The tool to use for this is their DSX.EXE (16bit). The most likely cause is a missing DLL, I think. Would you agree? At worst I could strip all the reports out into a D4 program, even if that meant installing two BDEs on a server. RB At 23:15 10/03/99 +1300, you wrote: -Original Message- From: Belding [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Date: Wednesday, March 10, 1999 5:26 PM Subject: [DUG]: Delphi and Crystal on NT4 Hello team Anyone using Delphi with Crystal Reports on NT4? 32 bit Works well. If you have 16 bit tools Seagate Software will not help you if you are a Delphi developer either. You will likely have little joy with versions prior to 5.x.108 and anything other than 32 bit Delphi. The Seagate developed VCL wrapper around crpe32.dll for v5, 6 or 7 is more powerful than the COM/VB equivalents. With NT 4 (sp?) the reports won't run and I get an error "cannot open database" from the Crystal DLL. You will have to specify the database type, database version, Crystal Reports type, version, platform and the method you are using to interface with the Crystal Reports Print Engine DLL i.e OCX, CRPExx.dll imports, VCL (D2,3,4, CB1,3 with source) or the Automation Server, as well as the version of the BDE, ODBC, ADO, or native connection you are trying to hook up to Crystal Reports. Sounds like a configuration issue."Unable To Open Database File" is an OCX error which implies a Database verify may be required or the pathname is too long esp wih Access, or maybe some UNC pathing problems. If you are using an ActiveX bridge to Crystal Reports then there are a host of OS and Microsft DLL redistributables to factor in. Any insight would be hugely welcome. ftp.img.seagatesoftware.com/pub/crystal and /pub/seagate_crystal_reports is full of software samples, fixes, extensions etc. Http access gives you some of this: http://www.img.seagatesoftware.com/crystalreports/techsupp/ You may find benefit by consulting the newsgroups hosted at www.cogniza.com or the alternative Crystal Report VCL at www.suprasoft.com or end user info @ www.crystaluser.com ftp://ftp.img.seagatesoftware.com/pub/seagate_crystal_reports/delphi/crvclap p.exe is a handy test tool written in Delphi with source. Cheers, Steve Cooney Pacific Windows --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz Rohit == CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand PH(649) 489-2280 FX(649) 489-2290 email [EMAIL PROTECTED] or [EMAIL PROTECTED] == --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Delphi and Crystal on NT4
I must say that my experience has been completely the opposite. I have found that the level of suppport for Crstal has been the best of any product I have ever used. I would frequently send requests and get responses within an hour or two, the answer was allways correct and usefull, and we never had a service contract. The product is sometimes frustrating but it's the best standalone reporting tool that I have used and I've used a few. [EMAIL PROTECTED] (Rohit Gupta) on 11/03/99 21:13:47 Please respond to [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] cc:(bcc: Peter Jones/LogisticsInformation Technology/Christchurch/Foodstuffs) Subject: Re: [DUG]: Delphi and Crystal on NT4 Russel, I use Crystal with Delphi. I have had absolutely no help from their support email address. I finally complained to the president after two weeks of continual email. That produced the help that I needed. It turns out that if you mis-fill their forms, they are just junked. And the beggars insist that no one else has any problems with the email support. There are various other issues such as misinformation in articles in various mags and I wouldnt recommend Crystal to anyone. I have already written to the editors in question asking them to stop doing their readers a dis-service by stopping any future articles on crystal. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Delphi and Crystal on NT4
At 09:13 11/03/99, you wrote: Russel, I use Crystal with Delphi. I have had absolutely no help from their support email address. I finally complained to the president after two weeks of continual email. That produced the help that I needed. It turns out that if you mis-fill their forms, they are just junked. etc Hello Rohit I've been using Crystal for several years and my problem with NT4 is the first one I haven't solved in a day. Seagate-Crystal Reports is great otherwise as far as I am concerned. I'm still looking for a solution to my NT4 WS problem. Regards Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Delphi and Crystal on NT4
Russel, have you tried installing crystal on the WS using the WS setup "disk" that they put together ? One of the subdirectories under CRW is just that. Many of our problems disappeared when we started using the setup in there. I dont use 16bit anymore, the 32bit directory is called WKCSETUP. On 11 Mar 99 at 14:51, Belding wrote: I'm still looking for a solution to my NT4 WS problem. Rohit == CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand PH(649) 489-2280 FX(649) 489-2290 email [EMAIL PROTECTED] or [EMAIL PROTECTED] == --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
RE: [DUG]: Delphi and Crystal on NT4
Russel, I may wrap all the reports into a D4 program using CRW32 ver 5.0.1.108. I hope this task will be as simple as I think. It is not that difficult - just drop the VCL component on the form, set a few properties and you will be alright. Our EXE was only had 5 lines of code for the reporting part!. Do use the report distribution expert as that will put the right files into the right places. Dennis. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz