RDC through ASP Error: Server has not yet been opened. 2

[sdidomenico]

Hello,

After many, many days of trial and error I cannot get a Report to display using RDC and ASP using a SQL Server 2000 DB.

The examples I'm currently using are from a third party reference. I'm not going to mention the book, because I don't think I should in this forum. I can get the examples, using the Access DB, to work. I can even create a simple report using an Access DB to work. When I try a report written to use tables in SQL Server 2000, I get an error. The Viewer is displayed but then the following error is displayed and then no data:

CRAXDRT Error Occured on Server. –2147192184 : Server has not yet been opened.

I have followed the "Primary Steps to using the Crystal Reports RDC through ASP" in the Help from Crystal 8.5 Developer. Crystal Reports is installed on our Win 2000 Server. IIS 5 is working. SQL Server 2000 is working.

I have searched for days on the Web for a solution. Can anyone tell me what this error really means and how to fix it? Please do not point me to anymore examples, I have researched them all.

Thanks in advance for your time,

Steve DiDomenico
Nashua, NH

 

[vidru]

Have a look a this thread for a start: thread149-506382.

-dave

 

[sdidomenico]

Thanks Dave. I have already tried these suggestions and they did not help. I'm using ODBC in the Report, not SQL in the ASP.

 

[crystalreporting]

Crystal have a tech document that outlines the probable causes for this error message - it's pretty comprehensive from memory, and has helped me resolve problems a number of times. I'm working remotley, so I don't have the link, but I'm sure you'll find it if you search the knowledge base.

Peter Shirley

http://www.linkcorp.com

 

[vidru]

The link that Peter was suggesting is probably this:

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

Everything I could think to suggest is in this document.

-dave

 

[sdidomenico]

Thanks Dave and Peter.
I will cover this document word by word and
I'll let you know how I make out.

Steve

 

[sdidomenico]

Hi Dave and Peter,

Thanks for your help. The link to the Crystal document provided me with enough information to determine that the ASP code as failing when using ODBC DSN provided. The code on Page 5 to test the connectivity with SetLogonInfo was the key. The code we had was correct. The fix was in SQL Server and the ODBC DSN for the SQL Server Database:

1)Create a SQL Server ID with Administrator permissions
2)Update the ODBC DSN to use SQL Server Authentication
3)Update the ODBC DSN to use the SQL Server ID created in
step 1
4)Update the ODBC DSN to point it to the Database being
used in the Crystal Report .rpt file

I don't know if the rest of the development world does it like this, but in the network environment I'm working in, this works!

Thanks a million guys,

Steve DiDomenico
Software Developer
Nashua, NH