Error (424) Object Required- Reporting from ASP

[crystalprog]

Hi All:
I have a Windows 2000 server running Crystal 8.0. Whenever I try to preview my reports in the Smart viewer for Active X the viewer opens up bu I get a
Error (424) Object required. An error has occurred on the server in attempting to access the data source. And a "user session has expired" message in a message box.
I read thro' the crystal support and did everything possible. The rptserver.asp page is in the same directory as the asp pages. The database connectivity is returning nothing(I guess if the connection is successful it returns nothing- because for a while it was returning false and then when i applied the scr8_webregfix.exe it seems to return nothing).

Any ideas please?????????????

Thanks.

 

[synapsevampire]

Here's some potentially helpful reference material:

On closer inspection of the ASP code for the Smart Viewers, it was found that
they were not referencing the correct location of the Rptserver.asp file. This file
is required to create the report's encapsulated page files that are ultimately
served by the web server to the viewers in the browser. The Rptserver.asp file
should be located in the same directory as the ASP page that is calling the
report.

If the Smart Viewer for ActiveX is being used to preview the report in the
browser, the following two lines in the Web Broker section of its code must
correctly reference the location of the Rptserver.asp file.
CRViewer.ReportName = Location.Protocol + "//" + Location.Host
+&quot;/<application's virtual directory>/Rptserver.asp&quot;
webSource.URL = Location.Protocol + &quot;//&quot; + Location.Host + &quot;/<application's
virtual directory>/Rptserver.asp&quot;

http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr_user_session_has_expired.pdf

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q266621

-k

 

[crystalprog]

Thanks a lot for looking into the issue. I finally figured out the solution. It was a security issue. On your windows 2000 server got to start and under the run command type rededt32. Under HKEY_local_machine go to software->ODBC->ODBC.ini select the DSN you are using in the ASP application. Up to go to security menu and click permissions and check to see if Everyone and Internet guest account are granted access.

 

[crystalprog]

OOps!! it is regedt32.exe