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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
