Greetings.
I have set up a test platform for an intranet server. I installed Win2k Server which comes with IIS 5.0. I performed a complete install of Crystal Reports 8.0 Developer on the server. I also installed Pervasive's 32-bit client for P.SQL 7.0. In production, this intranet server would be connecting to a Macola database on another server for Crystal Reports.
On the server, I created a very simple report from a Btrieve table using Crystal Reports' Btrieve drivers. I tested the report from the server and it ran fine. I saved the report in the same directory where some of the sample reports are kept, "General Business".
From another machine, I can connect to the intranet server and run the sample reports. I used the following URL: However, when I run my report I get the message "Error detected by database DLL. [Connecting to Page Server: testintra]".
In effort to troubleshoot, I set up and ODBC DSN for SQL Server (we have an MS SQL Server as well). From the intranet server, I created a Crystal Report using the ODBC connection. I tested the report from the server and it ran fine. I saved the report under the "General Business" folder as before.
From the other machine, connected to intranet server using the same URL (I used the same file name for this report). I was presented with a login prompt (something that needs be addressed later as this should be intrinsic to the report) and entered the 'sa' account info. The report was displayed in my browser.
My conclusion: The ActiveX component on the browser works. However, for whatever reason, Btrieve-based reports are problematic. That's not to say that other databases aren't a problem, but when the SQL/ODBC report works and the sample reports work, I have to assume there is something about the Btrieve setup. It can't be the Btrieve connnection on the server because, as I said before, I created and tested the report from the intranet server and it works beautiful.
Any ideas out there? I've searched on this issue and I haven't found any solution yet.
Thanks in advance...
-Rusty
I have set up a test platform for an intranet server. I installed Win2k Server which comes with IIS 5.0. I performed a complete install of Crystal Reports 8.0 Developer on the server. I also installed Pervasive's 32-bit client for P.SQL 7.0. In production, this intranet server would be connecting to a Macola database on another server for Crystal Reports.
On the server, I created a very simple report from a Btrieve table using Crystal Reports' Btrieve drivers. I tested the report from the server and it ran fine. I saved the report in the same directory where some of the sample reports are kept, "General Business".
From another machine, I can connect to the intranet server and run the sample reports. I used the following URL: However, when I run my report I get the message "Error detected by database DLL. [Connecting to Page Server: testintra]".
In effort to troubleshoot, I set up and ODBC DSN for SQL Server (we have an MS SQL Server as well). From the intranet server, I created a Crystal Report using the ODBC connection. I tested the report from the server and it ran fine. I saved the report under the "General Business" folder as before.
From the other machine, connected to intranet server using the same URL (I used the same file name for this report). I was presented with a login prompt (something that needs be addressed later as this should be intrinsic to the report) and entered the 'sa' account info. The report was displayed in my browser.
My conclusion: The ActiveX component on the browser works. However, for whatever reason, Btrieve-based reports are problematic. That's not to say that other databases aren't a problem, but when the SQL/ODBC report works and the sample reports work, I have to assume there is something about the Btrieve setup. It can't be the Btrieve connnection on the server because, as I said before, I created and tested the report from the intranet server and it works beautiful.
Any ideas out there? I've searched on this issue and I haven't found any solution yet.
Thanks in advance...
-Rusty