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
Rank 1
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