Liveware Publishing Support Forum

Do you have an activeX control that works with .NET? ____I have been trying to import the OCX from VB6 but have not had any success. The reason I am trying this is because we have designed a custom interface for our report system in .NET that currently shells out and runs rswrun.exe with a dynamically generated RSS file. If you run several reports back-to-back the rswrun.exe program gives an ODBC error stating that it cannot prepare the SQL statements. However, when I look at the generated RSS file it is fine. If I close out of the application and reopen it the problem goes away. Any ideas?____Thanks,__Gary

I have successfully added the OCX to my project. My question now is: Is it possible to specify an RSS file for the OCX to read or do I need to set all the RI_ parameters in the control itself?

The OCX is an alternate interface to the runtime engine. If you use the OCX you use its properties to set report parameters and then set the action to run the report. The OCX control is in place an RSS file.____Kathleen__R&R Support

Kathleen,__ Thanks for your reply. I have done testing with the OCX control and successfully have opened reports. However I have the same issue that I do if I just shell out and use the .EXE with and RSS file. Here is the problem:__If a user runs multiple reports they eventually get the following error:____DB access: {Microsoft][ODBC SQL Server Driver][SQL Server] some random message about invalid SQL statement.[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.____The heading for the message box that shows the error is "R&R SQL Report Viewer".____The "some random message about invalid SQL statement" changes depending upon the report that doesn^t run, and if I close down everything and run the application again the report will work just fine.____While testing the OCX control I had a managed debug agent in VS2005 that caught a COM exception from the activeX control. The error was a "context switch deadlock."____Any ideas?

Kathleen,__ I am still getting this error when using the runtime. Have you heard of anyone else having this problem? Is anyone else using .NET to start the RR runtime?____Thanks,__Gary