I'm running into a problem with reading a config file with my own custom
entries in it from within a delivery extension. I've tried putting it in the
ReportServer web.config and RSReportServer.config, and my code doesn't seem
to be able to find it.
When I use the configuration file .Net framework classes from within a
delivery extension, which config file is it looking at?
Thanks,
Mike SandwickMike,
Subscriptions are run in an unattended mode by the Report Server Windows
service (ReportingServicesService.exe) not the Report Server. So, try
putting your config settings in ReportingServicesService.exe.config.
--
Hope this helps.
----
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Mike Sandwick" <MikeSandwick@.discussions.microsoft.com> wrote in message
news:8BF4DD62-2EBE-491E-AB21-12BCFF53AA8E@.microsoft.com...
> I'm running into a problem with reading a config file with my own custom
> entries in it from within a delivery extension. I've tried putting it in
the
> ReportServer web.config and RSReportServer.config, and my code doesn't
seem
> to be able to find it.
> When I use the configuration file .Net framework classes from within a
> delivery extension, which config file is it looking at?
> Thanks,
> Mike Sandwick|||Hi Teo:
The delivery extension also has to provide GUI functionality in the
Report Server process, which will pull settings from
RSWebApplication.config. Depending on when the settings are used -
they might have to appear in both.
--
Scott
http://www.OdeToCode.com/
On Tue, 5 Oct 2004 21:57:50 -0400, "Teo Lachev [MVP]"
<teo.lachev@.nospam.prologika.com> wrote:
>Mike,
>Subscriptions are run in an unattended mode by the Report Server Windows
>service (ReportingServicesService.exe) not the Report Server. So, try
>putting your config settings in ReportingServicesService.exe.config.|||That was it, I put my configuration file entry in the
ReportingServicesService.exe.config, and it now works.
Thanks!
Mike
"Teo Lachev [MVP]" wrote:
> Mike,
> Subscriptions are run in an unattended mode by the Report Server Windows
> service (ReportingServicesService.exe) not the Report Server. So, try
> putting your config settings in ReportingServicesService.exe.config.
> --
> Hope this helps.
> ----
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ----
> "Mike Sandwick" <MikeSandwick@.discussions.microsoft.com> wrote in message
> news:8BF4DD62-2EBE-491E-AB21-12BCFF53AA8E@.microsoft.com...
> > I'm running into a problem with reading a config file with my own custom
> > entries in it from within a delivery extension. I've tried putting it in
> the
> > ReportServer web.config and RSReportServer.config, and my code doesn't
> seem
> > to be able to find it.
> >
> > When I use the configuration file .Net framework classes from within a
> > delivery extension, which config file is it looking at?
> >
> > Thanks,
> > Mike Sandwick
>
>|||Scott,
You are right. In general, a custom extension should store its config
settings in the Configuration element in the RSWebApplication.config. This
will allow the Report Server (or Report Manager) to push these settings to
the extension.
Perhaps, I should have started my reply with this side note. I assumed that
in Mike's case this wasn't acceptable. Thanks for pointing this out.
--
Hope this helps.
----
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Scott Allen" <bitmask@.[nospam].fred.net> wrote in message
news:6g07m0ttch61feklpro0dueks5a301o6d7@.4ax.com...
> Hi Teo:
> The delivery extension also has to provide GUI functionality in the
> Report Server process, which will pull settings from
> RSWebApplication.config. Depending on when the settings are used -
> they might have to appear in both.
> --
> Scott
> http://www.OdeToCode.com/
> On Tue, 5 Oct 2004 21:57:50 -0400, "Teo Lachev [MVP]"
> <teo.lachev@.nospam.prologika.com> wrote:
> >Mike,
> >
> >Subscriptions are run in an unattended mode by the Report Server Windows
> >service (ReportingServicesService.exe) not the Report Server. So, try
> >putting your config settings in ReportingServicesService.exe.config.
>
Showing posts with label config. Show all posts
Showing posts with label config. Show all posts
Thursday, March 22, 2012
Tuesday, March 20, 2012
accessing a config file from rdlc
How do I access information in a config file - web.config, app.config, etc. - from within an local report?
Thanks!
I accomplished this in a roundabout way by passing the info I wanted as a parameter.
Saturday, February 25, 2012
access sql server 2000
I am new to using .net. I am told that I need to setup a config file that
will be accessed by a VB.net dll. This vb.net dll will be setup to run every
5 to 10 minutes by a timer that is coded into the vb.net application.
A user will submit a request to obtain data from a HP mainframe.
This web config file needs to be able to do the following:
1. The user will submit the request to a sql server 2000 database (that
resides on a different that where the vb.net application will be running).
2.. The vb.net code will that submit the request for data to the hp
mainframe by using http and xml.
Thus my questions are:
1. How do you setup a connection and retrieve data from the sql server 2000
database that resides with the company's intranet? This will somehow need to
include a connection object and statements oh how to connect to the SQL
server 2000 database. The user name and password are suppose to be passed to
the sql server as part of the connection string.
2. How would I request to the HP mainframe using soap, http, and xml to wrap
up the request?
Thanks!Regarding the SQL Server part of your question, you can use System.Data
SqlConnection and SqlCommand objects to connect to SQL Server and execute
queries. The results can then be retrieved using a SqlDataAdapter
(disconnected) or SqlDataReader (connected).
The example below shows how you can accomplish the task using a
parameteritized SELECT statement. You can find details and many examples in
the Visual Studio reference.
Try
'Create connection
Dim conn As New SqlConnection( _
"Data Source=MyServer;Integrated Security=SSPI;Initial
Catalog=MyDatabase")
'Create command
Dim cmd As New SqlCommand( _
"SELECT MyData FROM MyTable WHERE MyKey = @.MyKey", conn)
cmd.CommandType = CommandType.Text
'Create input paramater for command
cmd.Parameters.Add("@.MyKey", SqlDbType.Int)
cmd.Parameters("@.MyKey").Direction = ParameterDirection.Input
cmd.Parameters("@.MyKey").Value = 1
cmd.Connection.Open()
Dim da As New SqlDataAdapter(cmd)
Dim dt As New DataTable
da.Fill(dt)
'process dt DataTable here
conn.Close()
Catch ex As SqlExcelption
'exception handling here
End Try
Hope this helps.
Dan Guzman
SQL Server MVP
"Wendy Elizabeth" <WendyElizabeth@.discussions.microsoft.com> wrote in
message news:1693FA1F-8530-4F22-B4D8-EBA89881C8B5@.microsoft.com...
>I am new to using .net. I am told that I need to setup a config file that
> will be accessed by a VB.net dll. This vb.net dll will be setup to run
> every
> 5 to 10 minutes by a timer that is coded into the vb.net application.
> A user will submit a request to obtain data from a HP mainframe.
> This web config file needs to be able to do the following:
> 1. The user will submit the request to a sql server 2000 database (that
> resides on a different that where the vb.net application will be running).
> 2.. The vb.net code will that submit the request for data to the hp
> mainframe by using http and xml.
> Thus my questions are:
> 1. How do you setup a connection and retrieve data from the sql server
> 2000
> database that resides with the company's intranet? This will somehow need
> to
> include a connection object and statements oh how to connect to the SQL
> server 2000 database. The user name and password are suppose to be passed
> to
> the sql server as part of the connection string.
> 2. How would I request to the HP mainframe using soap, http, and xml to
> wrap
> up the request?
> Thanks!
will be accessed by a VB.net dll. This vb.net dll will be setup to run every
5 to 10 minutes by a timer that is coded into the vb.net application.
A user will submit a request to obtain data from a HP mainframe.
This web config file needs to be able to do the following:
1. The user will submit the request to a sql server 2000 database (that
resides on a different that where the vb.net application will be running).
2.. The vb.net code will that submit the request for data to the hp
mainframe by using http and xml.
Thus my questions are:
1. How do you setup a connection and retrieve data from the sql server 2000
database that resides with the company's intranet? This will somehow need to
include a connection object and statements oh how to connect to the SQL
server 2000 database. The user name and password are suppose to be passed to
the sql server as part of the connection string.
2. How would I request to the HP mainframe using soap, http, and xml to wrap
up the request?
Thanks!Regarding the SQL Server part of your question, you can use System.Data
SqlConnection and SqlCommand objects to connect to SQL Server and execute
queries. The results can then be retrieved using a SqlDataAdapter
(disconnected) or SqlDataReader (connected).
The example below shows how you can accomplish the task using a
parameteritized SELECT statement. You can find details and many examples in
the Visual Studio reference.
Try
'Create connection
Dim conn As New SqlConnection( _
"Data Source=MyServer;Integrated Security=SSPI;Initial
Catalog=MyDatabase")
'Create command
Dim cmd As New SqlCommand( _
"SELECT MyData FROM MyTable WHERE MyKey = @.MyKey", conn)
cmd.CommandType = CommandType.Text
'Create input paramater for command
cmd.Parameters.Add("@.MyKey", SqlDbType.Int)
cmd.Parameters("@.MyKey").Direction = ParameterDirection.Input
cmd.Parameters("@.MyKey").Value = 1
cmd.Connection.Open()
Dim da As New SqlDataAdapter(cmd)
Dim dt As New DataTable
da.Fill(dt)
'process dt DataTable here
conn.Close()
Catch ex As SqlExcelption
'exception handling here
End Try
Hope this helps.
Dan Guzman
SQL Server MVP
"Wendy Elizabeth" <WendyElizabeth@.discussions.microsoft.com> wrote in
message news:1693FA1F-8530-4F22-B4D8-EBA89881C8B5@.microsoft.com...
>I am new to using .net. I am told that I need to setup a config file that
> will be accessed by a VB.net dll. This vb.net dll will be setup to run
> every
> 5 to 10 minutes by a timer that is coded into the vb.net application.
> A user will submit a request to obtain data from a HP mainframe.
> This web config file needs to be able to do the following:
> 1. The user will submit the request to a sql server 2000 database (that
> resides on a different that where the vb.net application will be running).
> 2.. The vb.net code will that submit the request for data to the hp
> mainframe by using http and xml.
> Thus my questions are:
> 1. How do you setup a connection and retrieve data from the sql server
> 2000
> database that resides with the company's intranet? This will somehow need
> to
> include a connection object and statements oh how to connect to the SQL
> server 2000 database. The user name and password are suppose to be passed
> to
> the sql server as part of the connection string.
> 2. How would I request to the HP mainframe using soap, http, and xml to
> wrap
> up the request?
> Thanks!
Access rights for surface configuration and managing sql services
If I need access rights to manage sql services(surface area config) in a
cluster server.
What kind rughts do I need? local admin?
Thanks
A SQL cluster and a regular SQL install require the same permissions and act
alike
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"mecn" <mecn2002@.yahoo.com> wrote in message
news:uNPSKbBtHHA.508@.TK2MSFTNGP02.phx.gbl...
> If I need access rights to manage sql services(surface area config) in a
> cluster server.
> What kind rughts do I need? local admin?
> Thanks
>
cluster server.
What kind rughts do I need? local admin?
Thanks
A SQL cluster and a regular SQL install require the same permissions and act
alike
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"mecn" <mecn2002@.yahoo.com> wrote in message
news:uNPSKbBtHHA.508@.TK2MSFTNGP02.phx.gbl...
> If I need access rights to manage sql services(surface area config) in a
> cluster server.
> What kind rughts do I need? local admin?
> Thanks
>
Subscribe to:
Posts (Atom)