Hi,
Specification of my Intranet Application(ASP.NET) requires that my reporting module use Crystal 8.5 RDC Runtime library. Both windows and web version of the application ineracts with the same SQL Server 7 database. Windows application uses Visual Basic 6. The reports are located in the database and for reporting, the system uses a ActiveX dll made from CRAXDRT library to populate and preview the report.
My ASP.Net application uses the same user made ActiveX DLL for reporting. Even though Crystal for DotNet is there, we have to use the dll to keep compatibility with the windows version. Reporting works fine with this method in the windows application.
Now my problem is when I connect to the database I get "Server has not Yet been opened Error". I am connecting to SQL Server 7 database and my report is using P2SSQL.DLL.
I've tried ApplicationObject.LogOnServer , DataBaseObject.LogOnServer and SetLogOnInfo method of table objects. All return the same error. I removed the dbo reference of the table names, still it is not working.
Is there any settings to be done in the Web Server to connect to the database.
Please help me.
Thanks in advance
Adasoft
Specification of my Intranet Application(ASP.NET) requires that my reporting module use Crystal 8.5 RDC Runtime library. Both windows and web version of the application ineracts with the same SQL Server 7 database. Windows application uses Visual Basic 6. The reports are located in the database and for reporting, the system uses a ActiveX dll made from CRAXDRT library to populate and preview the report.
My ASP.Net application uses the same user made ActiveX DLL for reporting. Even though Crystal for DotNet is there, we have to use the dll to keep compatibility with the windows version. Reporting works fine with this method in the windows application.
Now my problem is when I connect to the database I get "Server has not Yet been opened Error". I am connecting to SQL Server 7 database and my report is using P2SSQL.DLL.
I've tried ApplicationObject.LogOnServer , DataBaseObject.LogOnServer and SetLogOnInfo method of table objects. All return the same error. I removed the dbo reference of the table names, still it is not working.
Is there any settings to be done in the Web Server to connect to the database.
Please help me.
Thanks in advance
Adasoft