This is a migrated thread and some comments may be shown as answers.

Invocation error

2 Answers 48 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Steven
Top achievements
Rank 1
Steven asked on 10 Dec 2010, 06:51 AM

Hi, I am testing out the Q3 report tool in Silverlight. When I use a straight sql select, there is no problem. When I select a stored procedure and click next, it crashes with the error

"Exception has been thrown by the target of an invocation."



Image attached.

Also, I would appreciate an overview of the connection string. In the data source I have the connection string as follows
ReportLibrary.Properties.Settings.Generis_V26. But there is also the app.config with the connection strings.

Does the dll use the app.config? Can the app.config be access once the dll is in production? What connections tring gets passed to the dll?

My final question is thus. When I run the report in preview, I connect to the database without issue. When I compile and run the app and access the report, I get a connection error. For testing purposes, the app is set to connect to a different DB to the report. When I do a SQL Trace, I can see that the report is trying to access the same DB as the app. This suggests that the reports inherit the app's connection string. Could you please provide some clarity around this?

Many thanks

Steven
ps, ignore the image, i got the wrong one and cant seem to delete it. Please view the reply from me

 

2 Answers, 1 is accepted

Sort by
0
Steven
Top achievements
Rank 1
answered on 10 Dec 2010, 07:14 AM
Correct image.
0
Steve
Telerik team
answered on 15 Dec 2010, 04:41 PM
Hi Steven,

We were not able to reproduce the problem with stored procedures on our end (see attached video). Can you share what is the database you're binding to? You can see the officially supported ones (the ones we tested with) in the SqlDataSource Component, so if it not in the list, there might be possible problems.
As for the connectionString problem, please review the Using connectionStrings from configuration file KB article that elaborates on the matter.

Best wishes,
Steve
the Telerik team
Get started with Telerik Reporting with numerous videos and detailed documentation.
Tags
General Discussions
Asked by
Steven
Top achievements
Rank 1
Answers by
Steven
Top achievements
Rank 1
Steve
Telerik team
Share this question
or