When I was assigning the Database statement to Session("oRpt"
(StoredProcedure and Parameter), the report displayed correctly in Netscape.(After executing the same SP three times).
But when I am using the Visual Basic Component in the middle tier and getting a record set and assigning for Crystal Report in Session("oRpt", the report is not working in netscape browser. But the same is working in IE.
I have a real 3-tier application. My IIS Server cannot connect to the database directly. IIS Server will execute the COM method in the Application Server, and the Application Server will execute the SP in the
database Server and return a Record Set to IIS Server. IIS server should display the result in the netscape browser using SmartViewerJava.asp and rptserver.asp. But if I am connecting the database Server without the component , by directly assigning the Query statement(SP with param), the report is working in netscape. But the same thing is not working with COM Component.
When I am analyzing the data flow using the SQL Profiler, I found that,first time Stored Procedure was executed successfully. But the second and third time a string "rptserver.asp" is appended with the parameter and
tried to executed the stored procedure. Then Netscape is not responding.
I ran the SP and gave the record set to Crystal. Then
1. Why it is trying to execute the SP again and again?
2. Why in the second and third time My parameters (some portion) is replaced by a string "rptserver.asp"?
(StoredProcedure and Parameter), the report displayed correctly in Netscape.(After executing the same SP three times).But when I am using the Visual Basic Component in the middle tier and getting a record set and assigning for Crystal Report in Session("oRpt"
, the report is not working in netscape browser. But the same is working in IE.I have a real 3-tier application. My IIS Server cannot connect to the database directly. IIS Server will execute the COM method in the Application Server, and the Application Server will execute the SP in the
database Server and return a Record Set to IIS Server. IIS server should display the result in the netscape browser using SmartViewerJava.asp and rptserver.asp. But if I am connecting the database Server without the component , by directly assigning the Query statement(SP with param), the report is working in netscape. But the same thing is not working with COM Component.
When I am analyzing the data flow using the SQL Profiler, I found that,first time Stored Procedure was executed successfully. But the second and third time a string "rptserver.asp" is appended with the parameter and
tried to executed the stored procedure. Then Netscape is not responding.
I ran the SP and gave the record set to Crystal. Then
1. Why it is trying to execute the SP again and again?
2. Why in the second and third time My parameters (some portion) is replaced by a string "rptserver.asp"?
