maheshmehta
IS-IT--Management
I'm working on a web reporting system (ASP based system) and I get the following error: CRAXDRT error occurred on server. -2147192179: Server Has Not Yet Been Opened.
I'm using Windows 2000 server and SQL Server 2000. The Problem is When I Call a Crystal Report File throught an asp page the browser doesn't shows any thing accept the blank activex viewer screen. When i clicks on the referesh button in the toolbar of activex viewer following error is shown "CRAXDRT error occurred on server. -2147192179: Server Has Not Yet Been Opened" When I clicks ok the browser closes its own.
I m creating a recordset in asp page and then i pass this recordset to the crystal report file. The fields in the recordsets are matched to the fileds in the crystal report using the autosetunbound field method of crystal report object.
But when I create a report which saves the data with crystal report and call that report in the browser that report is displayed perfectly without any error.
This shows that there may be following causes of report not running when passing recordset at run time:
1. Either report is not able to connect to SQL at run time.
2. Either security setting of IIS is not permitting Crystal Report to connet SQL and get data from it.
I have searched whole documents related to security in IIS and SQL (authentication mode viz., mixed and windows) but nothing seems to solve the problem.
Is anyone can help me to point out where the problem could be. I have fad up with the problem.
The reports run absolutely fine on my machine but when i install it on a remote server then the problem arises.
Can anyone tell me what are the settings that i m not able to catch up are really causing the problem.
Mahesh
I'm using Windows 2000 server and SQL Server 2000. The Problem is When I Call a Crystal Report File throught an asp page the browser doesn't shows any thing accept the blank activex viewer screen. When i clicks on the referesh button in the toolbar of activex viewer following error is shown "CRAXDRT error occurred on server. -2147192179: Server Has Not Yet Been Opened" When I clicks ok the browser closes its own.
I m creating a recordset in asp page and then i pass this recordset to the crystal report file. The fields in the recordsets are matched to the fileds in the crystal report using the autosetunbound field method of crystal report object.
But when I create a report which saves the data with crystal report and call that report in the browser that report is displayed perfectly without any error.
This shows that there may be following causes of report not running when passing recordset at run time:
1. Either report is not able to connect to SQL at run time.
2. Either security setting of IIS is not permitting Crystal Report to connet SQL and get data from it.
I have searched whole documents related to security in IIS and SQL (authentication mode viz., mixed and windows) but nothing seems to solve the problem.
Is anyone can help me to point out where the problem could be. I have fad up with the problem.
The reports run absolutely fine on my machine but when i install it on a remote server then the problem arises.
Can anyone tell me what are the settings that i m not able to catch up are really causing the problem.
Mahesh