David Carnley
Top achievements
Rank 1
Rank 1
David Carnley
asked on 09 Apr 2008, 04:39 AM
I have structured my solution so that I have a web app and a class library for reports. The reports are based on table adapters. the table adapters have connection strings.
in the table adapter properties it has
connection name = SCREENINGWEBConnectionString (Settings)
that name matches up to the web.config on the web site. Also defined in myreports.dll.config
The table adapters in my web site have
connection name = SCREENINGWEBConnectionString (Web.config)
Is this the correct way to connect reports in a class library to the web site's data source? My reports throw a SQL server connection error. (Still trying to figure out the best way to capture those errors)
in the table adapter properties it has
connection name = SCREENINGWEBConnectionString (Settings)
that name matches up to the web.config on the web site. Also defined in myreports.dll.config
The table adapters in my web site have
connection name = SCREENINGWEBConnectionString (Web.config)
Is this the correct way to connect reports in a class library to the web site's data source? My reports throw a SQL server connection error. (Still trying to figure out the best way to capture those errors)
1 Answer, 1 is accepted
0
Hi David Carnley,
The problem you are faced with seems to be very similar to what we have done in the Telerik Reporting sample solutions - both C# and VB.NET.
Please, examine carefully how the typed data sets we use for the report data sources are configured - do not be afraid to open the XSDs as XML files and find how the connection string from the project settings is referenced.
The second step is the project Settings itself and the last thing to remember is to add the connection string to the web.config as we have done.
I hope this information helps.
Greetings,
Svetoslav
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
The problem you are faced with seems to be very similar to what we have done in the Telerik Reporting sample solutions - both C# and VB.NET.
Please, examine carefully how the typed data sets we use for the report data sources are configured - do not be afraid to open the XSDs as XML files and find how the connection string from the project settings is referenced.
The second step is the project Settings itself and the last thing to remember is to add the connection string to the web.config as we have done.
I hope this information helps.
Greetings,
Svetoslav
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center