You might be in trouble. I fought with this myself about a year ago for a project. I learned at that time that Crystal NO LONGER supports CFReport. They have gone their own way, and they want you to use THEIR system. I can only offer you sympathy and a hardy Good Luck. I never did get it to work, and we ended up rolling our own CF - RTF report system.
-------------- Ian Skinner Web Programmer BloodSource Sacramento, CA -----Original Message----- From: Josh Remus [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 11:21 AM To: CF-Talk Subject: Bloody CFReport Okay - I've seen in many cases out there while googling for help that many people have been unable to get CFReport to work at all. I believe I have installed it correctly, however I must be doing some slight thing wrong that is keeping me from my goal. I have tried several different things, including: 1. Moving the report in question from ODBC to Native, etc. 2. Trying a simple report (with no database fields involved) - this worked fine. But as soon as I added even one database field, it failed. 3. Combinations of username and password, no user name, no password, all of the above. The error that I'm getting most of the time is: "An unexpected error occurred while using the Crystal Engine. Error number 599 occurred (Cannot open SQL server.)." I believe the call is getting to Crystal, just not getting back. My RESPONSE.INI file has the following lines in it: [ReportStatus] ReportSucceeded=0 ReportErrNumber=599 ReportLibInfo=<P>Crystal Library = C:\WINNT\System32\CRPE32.DLL (2/10/2001 1:43) <BR>DLL Version = 8.80, Engine Version = 8.80 The code for the page in question is this: <cfreport report="c:\Inetpub\wwwroot\crm_production_tree\PEPs\test.rpt" username="#Request.UserName#" password="#Request.Password#" type="microsoft"> </cfreport> The file does exist, I can open it, verify the database, refresh data, etc., from the server machine successfully. Request.UserName & Password are correct. I've also tried hard-coding them in. I've tried it with and without the type="microsoft". I'm hoping that someone will have some new idea on what to try. I appreciate any help I can get! Thanks! --- Josh Remus Network Manager ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
