Crystal 8.5 with CF MX 6.1

[Steven Haas]

We are trying to run a simple Crystal Report (built using version 8.5) using a CFREPORT tag in a Cold Fusion page. My understanding is that this should be relatively routine.

The tag reads: <CFREPORT report="D:\webroot\Reports\WD.rpt"></CFREPORT>

It is the only significant code in the BODY of the page (to keep the test simple).

When we try to run the page, we get the following error:
"An unexpected error occurred while using the Crystal Engine. Error number 599 ocurred (Cannot open SQL server.)."

We are running Windows 2000 Server with SP3, IIS, MDAC 2.6 SP 2, Crystal Reports 8.5 (loaded as recommended in cfmx_crystal85.htm on the MacroMedia site...Crystal loaded as Custom, adding Crystal SQL Designer to be loaded, checking that CRPE32.dll is in the system32 directory), and CF MX 6.1.

We defined the ODBC connection to our SQL server database and it verified. We ran a simple Cold Fusion test page that accessed that database and it worked. We ran the crystal report in crystal (using that database in the report) and it worked. When we try to run the crystal report from CFREPORT in CF, it fails with the error above.

Any suggestions?

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---