Connection error when creating new database connection in de

Stimulsoft Reports.WEB discussion
Post Reply
adinac
Posts: 16
Joined: Mon Apr 22, 2013 11:59 am

Connection error when creating new database connection in de

Post by adinac »

Hello,

I am trying to integrate the designer in an MVC application. I am trying to add a new database connection to my 2008 sqlserver. I am using the following connection string "Data Source=adina-pc;Initial Catalog=NB;Integrated Security=True;MultipleActiveResultSets=True" (this is the same connection I am using this Entity framework, so it is working). When I try to test the connection, I get the following error "Connection error". I have also tried using a user/pwd combination and the same error. Am I missing something?

This is how my controller looks like:

"
....
public ActionResult GetReportTemplate() {

StiReport report = new StiReport();

return StiMvcDesigner.GetReportTemplateResult(report);

}
"

This is my Index.cshtml:

"
@using Stimulsoft.Report.Mvc;

@Html.Stimulsoft().StiMvcDesigner(new StiMvcDesignerOptions() {
ActionGetReportTemplate = "GetReportTemplate",
Width = 1000,
Height = 800
})
"


These are the assemblies which I am using

<add assembly="Stimulsoft.Base, Version=2013.1.1600.0, Culture=neutral, PublicKeyToken=ebe6666cba19647a"/>
<add assembly="Stimulsoft.Design, Version=2013.1.1600.0, Culture=neutral, PublicKeyToken=ebe6666cba19647a"/>
<add assembly="Stimulsoft.Database, Version=2013.1.1600.0, Culture=neutral, PublicKeyToken=ebe6666cba19647a"/>
<add assembly="Stimulsoft.Report, Version=2013.1.1600.0, Culture=neutral, PublicKeyToken=ebe6666cba19647a"/>
<add assembly="Stimulsoft.Report.Design, Version=2013.1.1600.0, Culture=neutral, PublicKeyToken=ebe6666cba19647a"/>
<add assembly="Stimulsoft.Report.Design.WebViewer, Version=2013.1.1600.0, Culture=neutral, PublicKeyToken=ebe6666cba19647a"/>
<add assembly="Stimulsoft.Report.Helper, Version=2013.1.1600.0, Culture=neutral, PublicKeyToken=ebe6666cba19647a"/>
<add assembly="Stimulsoft.Report.Mvc, Version=2013.1.1600.0, Culture=neutral, PublicKeyToken=ebe6666cba19647a"/>
adinac
Posts: 16
Joined: Mon Apr 22, 2013 11:59 am

Re: Connection error when creating new database connection i

Post by adinac »

I will response myself to the question.

What I was missing was to add an additional method in the controller:

public ActionResult DataProcessing() {
return StiMvcDesigner.DataProcessingResult(this.Request);
}
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Connection error when creating new database connection i

Post by HighAley »

Hello.

We are glad to work with such costumers.
Let us know if you will need any additional help.

Thank you.
Post Reply