Report with MS Sql datasource with Asp.net adapter

Stimulsoft Reports.JS discussion
felipemoreira
Posts: 38
Joined: Wed Mar 30, 2016 1:52 pm
Location: Brazil

Re: Report with MS Sql datasource with Asp.net adapter

Post by felipemoreira »

Looking this code inside Handle.cs:

Code: Select all

 var command = (CommandJson)new DataContractJsonSerializer(typeof(CommandJson)).ReadObject(HttpContext.Current.Request.InputStream);
At InputStream object, has already the following errors:

Code: Select all

ReadTimeout = 'HttpContext.Current.Request.InputStream.ReadTimeout' threw an exception of type 'System.InvalidOperationException'
WriteTimeout = 'HttpContext.Current.Request.InputStream.WriteTimeout' threw an exception of type 'System.InvalidOperationException'
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Report with MS Sql datasource with Asp.net adapter

Post by HighAley »

Hello.

Sorry, for delay with answer.
We have reproduced your issue now.
Please, check the database adapter that is available on GitHub now.

Thank you.
felipemoreira
Posts: 38
Joined: Wed Mar 30, 2016 1:52 pm
Location: Brazil

Re: Report with MS Sql datasource with Asp.net adapter

Post by felipemoreira »

Hi HighAley.

This time, i downloaded the entire project and load solution, but shows the same error.

My js code:

Code: Select all

StiOptions.WebServer.url = "http://localhost:10344/Handler.aspx";
var viewer = new Stimulsoft.Viewer.StiViewer(null, "StiViewer", false);
var report = new Stimulsoft.Report.StiReport();
report.loadFile("js/database1.mrt");
viewer.report = report;
viewer.renderHtml("report_designer");

Remembering that my js code is inside on another project, on a simple html page, not inside the default.aspx page like the example project. I do not know if this information is relavante.

My report is attached in this post.
Attachments
database1.mrt
My report that has Ms Sqlserver datasource.
(3.03 KiB) Downloaded 205 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Report with MS Sql datasource with Asp.net adapter

Post by HighAley »

Hello.

Please, check the MSSQLAdapter.cs file.
It should be changed yesterday. Compare this file:
https://github.com/stimulsoft/Samples-J ... Adapter.cs

Thank you.
felipemoreira
Posts: 38
Joined: Wed Mar 30, 2016 1:52 pm
Location: Brazil

Re: Report with MS Sql datasource with Asp.net adapter

Post by felipemoreira »

Thank you so much for your attention and patience HighAley !
Finally is working !
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Report with MS Sql datasource with Asp.net adapter

Post by HighAley »

Hello.

Great!.
We are always glad to help you.
Have a nice weekend.

Thank you.
Post Reply