Multi value Parameter

Hi,

In my report i have a multi valued parameter, when i view my report in the Web application with Report Viewer, The multi valued parameter is displaying in light color.Can we able to change this.

Thanks in advance

Mahima,

You can go to your Reporting Service\ReportManager\Style directory, this is were your "CSS" reporting service stylesheets are located. I believe the file you looking for is RSWebParts.css

Ham

|||

Hi,

Thanks for the reply.Can we able to change the width and Height of the multi valued parameter.Now it is of fixed size and displaying the horizantal and vertical scroll bars.

Thanks

Multi value parameter

In our project we are using reporting service web service calls to get report
paramaeters and report data.
We are passing an array of parameter values to webservice method
GetReportData() as an input parameter to render the output bytes.This
parameter values array consists of each controls's selected value.
Now in case of multivalue parameters, how to pass these multivalues to
webservice method GetReportData()?
Suppose for the control if we select the multiple values, how to send them
to array along with the other control's values to parametervalues collection.
please give suggestions on these.
Thanx
sriramI got the answer for this multivalue parameter
We have to send the multivalue parmaeters with same parameter name but with
different selected values in to parameter values array as below:
Here Foo is a multivalue parameter
<ParameterValues>
<ParameterValue>
<Name>Foo</Name>
<Value>1</Value>
</ParameterValue>
<ParameterValue>
<Name>Foo</Name>
<Value>2</Value>
</ParameterValue>
<ParameterValue>
<Name>Bar</Name>
<Value>NorthWest</Value>
</ParameterValue>
</ParameterValues>
"SRIRAM" wrote:
> In our project we are using reporting service web service calls to get report
> paramaeters and report data.
> We are passing an array of parameter values to webservice method
> GetReportData() as an input parameter to render the output bytes.This
> parameter values array consists of each controls's selected value.
> Now in case of multivalue parameters, how to pass these multivalues to
> webservice method GetReportData()?
> Suppose for the control if we select the multiple values, how to send them
> to array along with the other control's values to parametervalues collection.
> please give suggestions on these.
> Thanx
> sriramsql

Multi Server/Database Nightmare

We have a setup with a web server and multiple databases, and a live, stage, and dev environment. We use SQL Server standard 2005 and use the ASP.NET ReportView control. I have spent countless hours now trying to get this to work and am about to give this up and go back to Crystal.

First I wanted a report that would work from dev to stage to live without modification, so we set up shared data sources on each environment to point to the appropriate database. No problem, I can publish it to each environment and it works, though sometimes I have to go into Report Manager and fix the data source.

Next I wanted to be able to work with multiple databases, identical in structure. For this we did a hidden parameter with the database name and used a formula for the query string. This works pretty well.

Next I wanted to be able to run against multiple database servers from a single web server. This has been nearly impossible. I've read a million posts about this, and nothing seems to work well. I've tried a dynamic connection string, and passing the server in as a parameter, but this doesn't work, because I can't get the credentials set on the ReportViewer.ServerReport, so it doesn't work from dev to stage. You can't programatically change the shared data source - that would make it too easy. Linked servers are not an option.

I guess I need to either publish a copy of the report for each database server, or set up an instance of SQL on the web server for each database server.

Any other reasonable options out there. I just can't imagine my setup is all that unique.

Have you explored the possibility of using Synonyms?

(Even dyanmically creating them when necessary.)

|||Whats a Synonym?

MSXML6.CAB

Hi,

I am currently using msxml4.dll as part of my web application, but my project manager requested that I update to MSXML6. That makes sense, but I cannot find a corresponding msxml6.cab file that I can download and distribute. The only thing that I web search turned up is MSXML6 SP1 MSI, which does not help web installations and cross operating system compatibility.

1. Is there an msxml6.cab? If so how can I get it?

2. Is it legal to redistribute msxml6.cab, if it exists? If not, can I redistribute msxml4.cab?

Thanks in advance,

Sarah M. Weinberger
ButterflyVista
http://www.butterflyvista.com/

Don′t know if that is still valid, but did you see the Blog from the XMLTeam of MS ?

http://blogs.msdn.com/xmlteam/archive/2006/10/23/using-the-right-version-of-msxml-in-internet-explorer.aspx

"Hi Andrew, right now we don't support CAB installation for MSXML6. But we've heard from a bunch of folks now that this is an important scenario so we're looking at wrapping our existing installer. "

Maybe you can come along with the MSI package and can create a boostrapper ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

MSXML in Win Server 2003

Hi,

I have been using 'MSXML2.ServerXMLHttp.4.0' to make web requests from SQL server with no problems for about 6 months now (on Win2K Servers).

Now trying to move the databases onto a new 2003 server and getting the well known 'Access denied' error message. I beleive I have sorted out the following:

- Execute permissions on the master database for sp_OACreate, sp_OAGetErrorInfo,....
- Allowed 'All unkown ISAPI Extensions' - not that I'm happy about that!!
- Uninstalled the 'Internet Explorer Enhanced Security Configuration'
- I have enabled 'Submit nonencrypted form data' for the relevant zones in IE Security Settings

But none of these seem to have had an effect. I have also tried using WinHTTP.WinHTTPRequest.5.1 as suggested in a MS KB article, but this is not suitable as I need to pass authenitication parameters with each request, and it seems as though the response size is limited.

If anyone has any tips/checklists for getting this going I would be very interested.

TIASolved it!

My inablility to read MS Info, for others here is a very stripped down version:

exec @.hr = sp_OACreate 'WinHTTP.WinHTTPRequest.5.1', @.obj OUT

IF @.hr <> 0
BEGIN
EXEC sp_OAGetErrorInfo @.obj, @.src OUT, @.desc OUT
goto eh
END

exec @.hr = sp_OAMethod @.obj, 'open', NULL, "GET", @.sUr

IF @.hr <> 0
BEGIN
EXEC sp_OAGetErrorInfo @.obj, @.src OUT, @.desc OUT
goto eh
END

exec @.hr = sp_OAMethod @.obj, 'SetCredentials', NULL, 'USERNAME', 'PASSWORD', '0'

exec @.hr = sp_OAMethod @.obj, 'send'
IF @.hr <> 0
BEGIN
EXEC sp_OAGetErrorInfo @.obj, @.src OUT, @.desc OUT
goto eh
END

exec @.hr = sp_OAMethod @.obj, 'status', @.status OUT
IF @.hr <> 0
BEGIN
EXEC sp_OAGetErrorInfo @.obj, @.src OUT, @.desc OUT
goto eh
END

IF @.status <> 200
BEGIN
SET @.desc = 'HTTP request failed. Server returned status of ' +cast(@.status as varchar) + '.'
goto eh
END

exec @.hr = sp_OAGetProperty @.obj, 'responseText', @.response OUT
IF @.hr <> 0
BEGIN
EXEC sp_OAGetErrorInfo @.obj, @.src OUT, @.desc OUT
goto eh
END

exec @.hr = sp_OADestroy @.obj
return 0

eh:
exec @.hr = sp_OADestroy @.obj
Raiserror(@.desc, 16, 1)sql

MSTDC and windows domain

Hi,
i have this scenario :
a have web application (NT4) that use a MSTDC service on my application
server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
The service MSTDC on application server and db server start with the same
domain administration account (administrator)
Now i have install a new domain windwos 2003 and a new cluster SQL2000/MSTDC
on 2 windows 2003 server and try to modify my application to point to new
windows 2003 cluster but when i try to test it a error appared :
Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction. OLE/DB provider returned
message: New transaction cannot enlist in the specified transaction
coordinator.
and found a kb article and make the modify adding a network service into
MSDTC service on cluster 2003 but the problem is not resoleved! :-(
This is because are 2 different domain and network service on 2003 isn't any
account on NT4 domain ?
If i try to trust a windows 2003 and NT4 domain i resolved it ?
The trust is only one solution or exist other solution ?
Thanks in advance.
make sure you are ussing the cluster version of DTC. On each node you
should have run comclust.exe.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
SQL2000/MSTDC
> on 2 windows 2003 server and try to modify my application to point to new
> windows 2003 cluster but when i try to test it a error appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
any
> account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>
|||Hi,
yes ai use DTC cluster .
But on windows2003 for clustering DTC i don't type comclust but i must
create it manuallty ,
are you sure ?
Thanks.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23C7I0Pp5EHA.2572@.tk2msftngp13.phx.gbl...
> make sure you are ussing the cluster version of DTC. On each node you
> should have run comclust.exe.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> <io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> SQL2000/MSTDC
> 'SQLOLEDB'
> any
>
|||Hi,
i foun a solutiontoi my problem , the solution is :
- Trust 2 way from NT4 and 2K3
- Modify lmhost/host file for all server that are involved (i try for 2
hour first found the the optimal configuration of this file)
I habve used dctping.exe and dctester.exe for troubleshooting
And now work
Other solution instead trust is :
http://support.microsoft.com/default...b;en-us;827805
Thanks !
this is happy day!
:-)
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
> SQL2000/MSTDC on 2 windows 2003 server and try to modify my application to
> point to new windows 2003 cluster but when i try to test it a error
> appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
> 'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
> any account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>

MSTDC and windows domain

Hi,
i have this scenario :
a have web application (NT4) that use a MSTDC service on my application
server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
The service MSTDC on application server and db server start with the same
domain administration account (administrator)
Now i have install a new domain windwos 2003 and a new cluster SQL2000/MSTDC
on 2 windows 2003 server and try to modify my application to point to new
windows 2003 cluster but when i try to test it a error appared :
Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction. OLE/DB provider returned
message: New transaction cannot enlist in the specified transaction
coordinator.
and found a kb article and make the modify adding a network service into
MSDTC service on cluster 2003 but the problem is not resoleved! :-(
This is because are 2 different domain and network service on 2003 isn't any
account on NT4 domain ?
If i try to trust a windows 2003 and NT4 domain i resolved it ?
The trust is only one solution or exist other solution ?
Thanks in advance.make sure you are ussing the cluster version of DTC. On each node you
should have run comclust.exe.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
SQL2000/MSTDC
> on 2 windows 2003 server and try to modify my application to point to new
> windows 2003 cluster but when i try to test it a error appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
any
> account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>|||Hi,
yes ai use DTC cluster .
But on windows2003 for clustering DTC i don't type comclust but i must
create it manuallty ,
are you sure ?
Thanks.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23C7I0Pp5EHA.2572@.tk2msftngp13.phx.gbl...
> make sure you are ussing the cluster version of DTC. On each node you
> should have run comclust.exe.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> <io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> i have this scenario :
>> a have web application (NT4) that use a MSTDC service on my application
>> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
>> The service MSTDC on application server and db server start with the same
>> domain administration account (administrator)
>> Now i have install a new domain windwos 2003 and a new cluster
> SQL2000/MSTDC
>> on 2 windows 2003 server and try to modify my application to point to new
>> windows 2003 cluster but when i try to test it a error appared :
>> Server: Msg 7391, Level 16, State 1, Line 2
>> The operation could not be performed because the OLE DB provider
> 'SQLOLEDB'
>> was unable to begin a distributed transaction. OLE/DB provider returned
>> message: New transaction cannot enlist in the specified transaction
>> coordinator.
>> and found a kb article and make the modify adding a network service into
>> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
>> This is because are 2 different domain and network service on 2003 isn't
> any
>> account on NT4 domain ?
>> If i try to trust a windows 2003 and NT4 domain i resolved it ?
>> The trust is only one solution or exist other solution ?
>> Thanks in advance.
>>
>|||Hi,
i foun a solutiontoi my problem , the solution is :
- Trust 2 way from NT4 and 2K3
- Modify lmhost/host file for all server that are involved (i try for 2
hour first found the the optimal configuration of this file)
I habve used dctping.exe and dctester.exe for troubleshooting
And now work
Other solution instead trust is :
http://support.microsoft.com/default.aspx?scid=kb;en-us;827805http://support.microsoft.com/default.aspx?scid=kb;en-us;827805
Thanks !
this is happy day!
:-)
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
> SQL2000/MSTDC on 2 windows 2003 server and try to modify my application to
> point to new windows 2003 cluster but when i try to test it a error
> appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
> 'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
> any account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>

MSSQLSERVER Error 17830

Hi,
Please help me with this before I get crazy....

I have VS 2005 and SQL server 2005 installed on XP ( with SP2 ) I create a new web project. Make a SQL connection to my database and configure the advanced options. Drag gridview component to my form and configure it to use the connection with edit option checked. When I run my form I can scroll and view the data with no problem at all. Even edit works fine BUT the changes to the row NEVER gets to the database. No error messages what so ever. XP:s Event View reports this:

Type: Error
Source: MSSQLSERVER
Class: Logon
Code: 17830

A network error occurred while establishing a connection; the connection has been closed. This may have been caused by client or server login timeout expiration. Time spent during login: total 31 ms, enqueued 1 ms, network writes 1 ms, network reads 30 ms, establishing SSL 29 ms, negotiating SSPI 0 ms, validating login 0 ms. [CLIENT: <local machine>]

Any ideas what is wrong?

Regards, Jarmo

Is it possible that in the connection string in the client application you've specified the option to require encryption?

If this is the case and the server doesn't have an SSL certificate configured from a trusted authority then the client driver may be dropping the connection during the SSL handshake because it doesn't trust the server's SSL certificate.

Hope this helps,
Vaughn

mssql web pages

people, can anybody tell me some good links,
mssql good links, where are bols,
some months ago i used web page like %mssqlteam%
but now i cant to find this web page,
thanks !http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp&
- for updated books online.
http://www.sql-server-performance.com
- for performance related tips and information
http://www.sqlteam.com
- the one you've asked for.|||thanks

MsSQL Software

is there any free web apps out there that can interface with an SQL Server in real time, like add, edit, delete, update and search the DB?Ummm yeah, any ideas?|||There's always Query Analyzer, the free query tool that ships with MS-SQL Server. Free to use as long as the server you connect to is licensed.

If you're looking for a non-MS tool, just google 'SQL Query tool' and you'll find lots of stuff or check tucows.|||Originally posted by loach
There's always Query Analyzer, the free query tool that ships with MS-SQL Server. Free to use as long as the server you connect to is licensed.

If you're looking for a non-MS tool, just google 'SQL Query tool' and you'll find lots of stuff or check tucows.

Thats not what I am talkin about, I dont want to find an SQL Query tool, I want a full GUI interface to control the DB. All the programs I found in google to view and export data. I dont want a program that just lets you control the DB via SQL statements alone...|||I guess I don't really understand what you're looking for. What is it that you're looking for that Enterprise Manager does not do?|||Originally posted by sabastious
Thats not what I am talkin about, I dont want to find an SQL Query tool, I want a full GUI interface to control the DB. All the programs I found in google to view and export data. I dont want a program that just lets you control the DB via SQL statements alone...

Hello.

See if this help... I have not tried it myself yet.

http://www.msde.biz/msdequery/download.htm|||Originally posted by sabastious
is there any free web apps out there that can interface with an SQL Server in real time, like add, edit, delete, update and search the DB?

myLittleAdmin : http://www.myLittleTools.net/mla_sql

This is a web-based GUI for MS Sql.

best regards|||You can link to your SQL Server database via a Microsoft Access database Access Data Project (.adp file extension) and control many things such as table, view, and procedure creation as well as data manipulation. It acts like a stripped down Enterprise Manager.

But again, why not just use Enterprise Manager?

blindman

mssql manager based on web application

hi to all,
i have looked in the forum whit no success and hoping that this is the right place to ask :
i am looking for a tool - application to manage mssql server , is anybody new a good system.
thanks oriYou could try out Microsoft'sSQL Server Web Data Administrator.