[web Service] Rename a Report

i try to rename a report with web services.
i used ReportingService2005.SetProperties Method but when
i try with
Property.Name = "Name";
Property.Value = "myNewName"
i can't update the report name => RS2005 say the property 'name' is readonly
this method is ok with property "description"
How todo to rename report ?On Mar 16, 3:55 am, jeff <j...@.discussions.microsoft.com> wrote:
> i try to rename a report with web services.
> i used ReportingService2005.SetProperties Method but when
> i try with
> Property.Name = "Name";
> Property.Value = "myNewName"
> i can't update the report name => RS2005 say the property 'name' is readonly
> this method is ok with property "description"
> How todo to rename report ?
There are a couple of different ways to do it. Either change it in the
Properties tab in the Report Manager -or- change it at the file level.
So programmatically (option 2), you could do something like this in a
stored prcoedure that the report is using, etc:
exec xp_cmdshell 'rename c:\OriginalReportName.rdl NewReportName.rdl'
Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||i wouldlike use Webservice ..... ( i create a soft that manage reporting
services 2005 with webservices )
"EMartinez" wrote:
> On Mar 16, 3:55 am, jeff <j...@.discussions.microsoft.com> wrote:
> > i try to rename a report with web services.
> >
> > i used ReportingService2005.SetProperties Method but when
> > i try with
> > Property.Name = "Name";
> > Property.Value = "myNewName"
> > i can't update the report name => RS2005 say the property 'name' is readonly
> > this method is ok with property "description"
> >
> > How todo to rename report ?
> There are a couple of different ways to do it. Either change it in the
> Properties tab in the Report Manager -or- change it at the file level.
> So programmatically (option 2), you could do something like this in a
> stored prcoedure that the report is using, etc:
> exec xp_cmdshell 'rename c:\OriginalReportName.rdl NewReportName.rdl'
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>

[TCP/IP Sockets] Specified SQL Server not found

Connections, using ODBC (version 3.520) and from a couple web apps, to one of
my SQL Server 2000 systems (with SP3) had been fine until a couple days ago.
Suddenly some of my systems (but not all) are unable to connect to that one
server. The message when ODBC attempts to login into the SQL Server is:
Connection failed:
SQLState: '01000', SQL Server Error: 11001, [TCP/IP Sockets]ConnectionOpen
(Connect())
SQLState: '08001', SQL Server Error: 6, [TCP/IP Sockets]Specified SQL Server
not found
My web apps (including a web service) display a similar (though abbreviated)
message when the user is trying to connect to the SQL server to
login/authenticate.
From that same system that can't get to the first SQL Server, I can use ODBC
to connect to a different SQL Server with no trouble. I've tried Named Pipes
with no success. Enterprise Manager connects fine from other systems. I am
certain that MDAC 2.8 has been installed on all systems but, regardless, I
hadn't done any Windows updates on any systems for at least a week and no
MDAC/ODBC updates for a couple months.
What can I check or fix?
Thanks.
Jon
jlimmer@.gmbeverage.com
On the surface it sounds like a name resoultion problem. What happens if
you ping the SQL Server name from the web server. Does it return? Als try
ping -a <ip address of the SQL Server machine>. Does it return the correct
server name?
Can you connect from a DSN using the ip address of the SQL Server as the
server name?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Very interesting, Rand.
I can ping the SQL server both using the server name and using the -a switch
(which does resolve the server name).
I also can sucessfully use the IP address in the SQL Server instance name in
the DSN to connect.
So, what does that indicate is the problem, if DNS is working?
Jon

[TCP/IP Sockets] Specified SQL Server not found

Connections, using ODBC (version 3.520) and from a couple web apps, to one o
f
my SQL Server 2000 systems (with SP3) had been fine until a couple days ago.
Suddenly some of my systems (but not all) are unable to connect to that one
server. The message when ODBC attempts to login into the SQL Server is:
Connection failed:
SQLState: '01000', SQL Server Error: 11001, [TCP/IP Sockets]ConnectionOp
en
(Connect())
SQLState: '08001', SQL Server Error: 6, [TCP/IP Sockets]Specified SQL Se
rver
not found
My web apps (including a web service) display a similar (though abbreviated)
message when the user is trying to connect to the SQL server to
login/authenticate.
From that same system that can't get to the first SQL Server, I can use ODBC
to connect to a different SQL Server with no trouble. I've tried Named Pipe
s
with no success. Enterprise Manager connects fine from other systems. I am
certain that MDAC 2.8 has been installed on all systems but, regardless, I
hadn't done any Windows updates on any systems for at least a week and no
MDAC/ODBC updates for a couple months.
What can I check or fix?
Thanks.
Jon
jlimmer@.gmbeverage.comOn the surface it sounds like a name resoultion problem. What happens if
you ping the SQL Server name from the web server. Does it return? Als try
ping -a <ip address of the SQL Server machine>. Does it return the correct
server name?
Can you connect from a DSN using the ip address of the SQL Server as the
server name?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Very interesting, Rand.
I can ping the SQL server both using the server name and using the -a switch
(which does resolve the server name).
I also can sucessfully use the IP address in the SQL Server instance name in
the DSN to connect.
So, what does that indicate is the problem, if DNS is working?
Jon

[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item

Hi,

I have two problems with Toggle Items when I render my Reports using the RS Web Service.

First, the URL when I click on the + / - image will redirect me to the Report Server URL

ex :

The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True

Is there a solution to this problem ? (with a replace ?)

Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...

Here's a sample of my code :

string ShowHideToggle = null;

// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)

ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];

bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);

Encoding oEnc = System.Text.Encoding.UTF8;

string sHTMLFlow = oEnc.GetString(bResult);

// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");

Any Help would be appreciated :)
That thing is killing me :(

Thanks for your help

You didn't say what version of SRS you're using.
On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report

Thanks
Tudor|||

Tudor

Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.

Any tips would be much appreciated.

Thank you.

mike

|||

Call LoadReport only when ShowHideToggle is null.

after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.

for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.

|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?

Thanks,
Paul

[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item

Hi,

I have two problems with Toggle Items when I render my Reports using the RS Web Service.

First, the URL when I click on the + / - image will redirect me to the Report Server URL

ex :

The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True

Is there a solution to this problem ? (with a replace ?)

Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...

Here's a sample of my code :

string ShowHideToggle = null;

// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)

ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];

bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);

Encoding oEnc = System.Text.Encoding.UTF8;

string sHTMLFlow = oEnc.GetString(bResult);

// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");

Any Help would be appreciated :)
That thing is killing me :(

Thanks for your help

You didn't say what version of SRS you're using.
On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report

Thanks
Tudor|||

Tudor

Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.

Any tips would be much appreciated.

Thank you.

mike

|||

Call LoadReport only when ShowHideToggle is null.

after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.

for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.

|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?

Thanks,
Paul

[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item

Hi,

I have two problems with Toggle Items when I render my Reports using the RS Web Service.

First, the URL when I click on the + / - image will redirect me to the Report Server URL

ex :

The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True

Is there a solution to this problem ? (with a replace ?)

Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...

Here's a sample of my code :

string ShowHideToggle = null;

// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)

ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];

bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);

Encoding oEnc = System.Text.Encoding.UTF8;

string sHTMLFlow = oEnc.GetString(bResult);

// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");

Any Help would be appreciated :)
That thing is killing me :(

Thanks for your help

You didn't say what version of SRS you're using.
On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report

Thanks
Tudor|||

Tudor

Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.

Any tips would be much appreciated.

Thank you.

mike

|||

Call LoadReport only when ShowHideToggle is null.

after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.

for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.

|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?

Thanks,
Paul

[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item

Hi,

I have two problems with Toggle Items when I render my Reports using the RS Web Service.

First, the URL when I click on the + / - image will redirect me to the Report Server URL

ex :

The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True

Is there a solution to this problem ? (with a replace ?)

Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...

Here's a sample of my code :

string ShowHideToggle = null;

// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)

ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];

bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);

Encoding oEnc = System.Text.Encoding.UTF8;

string sHTMLFlow = oEnc.GetString(bResult);

// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");

Any Help would be appreciated :)
That thing is killing me :(

Thanks for your help

You didn't say what version of SRS you're using.
On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report

Thanks
Tudor|||

Tudor

Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.

Any tips would be much appreciated.

Thank you.

mike

|||

Call LoadReport only when ShowHideToggle is null.

after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.

for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.

|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?

Thanks,
Paul

[ODBC SQL Server Driver]Communication link failure

This error is being generated from a SQLServer2000 database being accessed
via ASP over the web, any suggestions for fixing it?
THANKS
--
John9 times out of 10 this is a NIC/Hub/Switch issue...can you have the network
guys stress test the connection (or are you the network guy?)
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"JohnB" <JohnB@.discussions.microsoft.com> wrote in message
news:185061E8-C62F-4E79-94EC-699844BE67D2@.microsoft.com...
> This error is being generated from a SQLServer2000 database being accessed
> via ASP over the web, any suggestions for fixing it?
> THANKS
> --
> John

[ODBC SQL Server Driver]Communication link failure

This error is being generated from a SQLServer2000 database being accessed
via ASP over the web, any suggestions for fixing it?
THANKS
John
9 times out of 10 this is a NIC/Hub/Switch issue...can you have the network
guys stress test the connection (or are you the network guy?)
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"JohnB" <JohnB@.discussions.microsoft.com> wrote in message
news:185061E8-C62F-4E79-94EC-699844BE67D2@.microsoft.com...
> This error is being generated from a SQLServer2000 database being accessed
> via ASP over the web, any suggestions for fixing it?
> THANKS
> --
> John

[Microsoft][ODBC SQL Server Driver]Timeout expired

I keep getting the above error when i run a sql from my web page. The query runs fine in enterprise manager. What is worng . Please help.

sql="SELECT top 1 * FROM V_ISSUE WHERE ISSUE_ID=" & issueid & " order by issue_id"

if Session("rs").State = 1 then Session("rs").Close
Session("rs").Open sql,Session("MyConn")Please Try this Code

sql="SELECT top 1 * FROM V_ISSUE WHERE ISSUE_ID=" & issueid & " order by issue_id"

Session("rs").Open sql,Session("MyConn")

Session("rs").close
Set Session("rs")=Nothing

[Microsoft][ODBC SQL Server Driver]Timeout expired

Hi,
Our web applications are using COM objects to call sps in
SQL server. We are getting a lot of timeout errors. If
you know why this happens and any fixes pls let me know.
The error looks like following:
[Microsoft][ODBC SQL Server Driver]Timeout expiredhi
I also face to that prob.At last i found the solution for the "timeout
expired" problem. what we
have to do is, we have to edit two windows files calld
,"c:\winnt\system32\drives\ect\hosts.txt"
and "c:\winnt\system32\drives\ect\Lhosts.txt"
we should enter sql server IP and name like this
169.192.2.100 sqlserverName
in both files
Thanks,
indika
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).

We are randomly experiencing this error when connecting to SQL W2K from web
servers using ODBC. I see numerous links on the web but real answers.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).
Hi Brent,
I would make a network trace on the client and the server. I'll bet you
can't reproduce this if the client and server are on the same machine.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).

We are randomly experiencing this error when connecting to SQL W2K from web
servers using ODBC. I see numerous links on the web but real answers.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (se
nd()).Hi Brent,
I would make a network trace on the client and the server. I'll bet you
can't reproduce this if the client and server are on the same machine.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

[help] How do I have Asp.net kick off an SSIS Package on a different server?

Hello, I was wondering if someone can help me with an ASP.NET question. We have been having troubles with our web server, and I don't know where else to turn.

We are running an asp.net (vb.net) with IIS on ourWebServer.

We are running Sql Server 2005 / SSIS on ourDatabaseServer.

SQL Server and IIS are running on separate machines. This is by design.

We are trying to get our Asp.net to kick off an SSIS package, but we are unable to do this since the software is on separate servers.

(If both are installed on the web server, we can directly call the SSIS package. If both are installed on the Database Server, we can implement a web service on the Database Server, and call that web service from the Web Server.)

Thank you,

~Le

How are you trying to do that?

|||

>>How are you trying to do that?

Currently we are not doing it, which is why I am here.

On development, we are able to call the SSIS directly from Asp.net, as long as IIS and Integration Services is on the same machine.

In a different development environment, IIS is installed on the Machine01 and ISS + Integration Services is installed on Machine02. The Asp.net page runs off of Machine01 and calls a Web Service that is running on Machine02. That Web Service is able to activate the SSIS since Integration Services is on the same machine.

On our production server, we will not have either luxury. IIS is installed on the Web Server and Integration Services is installed on the Database Server.

So, how can we run it in our production environment?

~Le

|||

Sorry for the late reply, but I still dont understand that what will change in new development environment.

Currently you have SSIS on database server and asp.net(with IIS) on different machine and later its going to be the same. You can have the webservice running either on your asp.net machine or on Machine02, whichever you prefer.

[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network do

Hello all,

We have a Windows 2003 Web Edition server serving a site through IIS. It connects to a Windows 2003 Standard Edition server running SQL 2000 SP3a.

This site receives the following error as seen in the topic:
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.

We've configured the server network utility to only allow TCP/IP connections. The connection string for the site is as follows:

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
MM_connSpankMSSQL_STRING = "Provider=sqloledb;Data Source=SERVER_IP,1433;Network Library=DBMSSOCN;Initial Catalog=ourmaindb_1;User ID=ourmaindb_1;Password=hotcookies;"
%>

Any ideas or tips on solving this issue? We've noticed it is due to larger queries as smaller ones do work with no problems.

The servers are behind a BSD box running iptables, has 1433,1434 along with standard web ports wide open. Anything outbound is allowed.

Some further testing via ODBC on the IIS server improved things. No more connection pooling for the SQL Server driver allows for 1/3 of the query to run. Still 2/3s of it doesn't show up, and that general network error message appears.

Should have 330 rows if it works right.See if this webcast can help you any:

http://support.microsoft.com/servicedesks/webcasts/seminar/shared/asp/view.asp?url=/servicedesks/webcasts/en/WC072804/manifest.xml

[2.0] web service method to list the reports ?

Hello,

I'd like to use the Reporting Services 2005 Web Service to list all the reports on the server, but I don't know which method to use ?
I found many web methods to do all sort of things but not to get a list of reports.

Any idea ?

Ok I found the method of the Reporting Web Service : ListChildren(...)

But when I make a call to the WS on my web app, I got the error :HTTP status 401: Access Denied.

My Web App use Form authentication.
My ASPNET user is member of the ReportinsServicesWebServiceUser role so it should work.

I try to use impersonation, but still the same result...

|||

Have you tried allowing anonymous access to the site in IIS and adding

service.Credentials = System.Net.CredentialCache.DefaultCredentials

in code?

|||

I tried this and it's ok !

There was another security problem with RS which make a DCOM access to NetMan component with Network Services account.

Weird but it seems ok now, thanks.