Showing posts with label default. Show all posts
Showing posts with label default. Show all posts

Wednesday, March 21, 2012

Problems with Parameters (C#)

I am passing parameters from Bryan Keller's C# program that has been
mentioned here many times to my report. I get the following error:
Default value or value provided for the report parameter 'fromclient' is
not a valid value.
The execution log shows 'rsInvalidReportParameter'.
'fromclient is a string value and it is the 3rd parameter of seven. The
first two are boolean, and I pass them as "0" and "1".
I don't seem to get past this point. What am I doing wrong?
GerhardJust check the Report parameters and see what datatype is
set for FromClient.
May be its set to something else other than string
>--Original Message--
>I am passing parameters from Bryan Keller's C# program
that has been
>mentioned here many times to my report. I get the
following error:
> Default value or value provided for the report
parameter 'fromclient' is
>not a valid value.
>The execution log shows 'rsInvalidReportParameter'.
>'fromclient is a string value and it is the 3rd parameter
of seven. The
>first two are boolean, and I pass them as "0" and "1".
>I don't seem to get past this point. What am I doing wrong?
>Gerhard
>
>.
>|||It's string but it is from a query (dropdown box). Maybe that's the
problem?
Gerhard
"Ravi" <ravikantkv@.rediffmail.com> wrote in message
news:5a3301c491d9$db50e8a0$a601280a@.phx.gbl...
> Just check the Report parameters and see what datatype is
> set for FromClient.
> May be its set to something else other than string
> >--Original Message--
> >I am passing parameters from Bryan Keller's C# program
> that has been
> >mentioned here many times to my report. I get the
> following error:
> > Default value or value provided for the report
> parameter 'fromclient' is
> >not a valid value.
> >The execution log shows 'rsInvalidReportParameter'.
> >
> >'fromclient is a string value and it is the 3rd parameter
> of seven. The
> >first two are boolean, and I pass them as "0" and "1".
> >I don't seem to get past this point. What am I doing wrong?
> >Gerhard
> >
> >
> >.
> >

Monday, February 20, 2012

Problems when I install SQL Express SP1 (CTP)

Hi All,

I have installed "SQL Server 2005 180 days evaluation" on Windows XP as default instance one month before. It runs fine.

However, today I try to install "SQL Express SP1 (CTP) - SQLEXPR_ADV.EXE" as a new instance name "SQLExpress", It prompt me that it could not install "SQL Server 2005 Management Studio Express" as existing "SQL Server 2005 Management Studio" already installed. So I have to install "SQLEXPR_ADV.EXE" but uncheck "SQL Server 2005 Management Studio Express". When setup has completed, I found the original "SQL Server 2005 Management Studio" is missing.

I try to re-install "SQL Server 2005 180 days evaluation" but it prompt me it is already installed, and cannot find "SSMS" option. Then I try to use "Add/Remove Programs" as control panel to Change "Microsoft SQL Server 2005", I still cannot find "SSMS" option.

Also, there is no another Start Menu folder for "SQL Express", but "Microsoft SQL Server 2005".

From the "SQL Server Configuration Manager" --> SQL Server 2005 Services, I found following instance running properly,

SQL Server Integration Services

SQL Server FullText Search (MSSQLSERVER)

SQL Server FullText Search (SQLEXPRESS)

SQL Server (SQLEXPRESS)

SQL Server (MSSQLSERVER)

SQL Server Analysis Services (MSSQLSERVER)

SQL Server Reporting Services (MSSQLSERVER)

SQL Server Reporting Services (SQLEXPRESS)

SQL Server Browser

SQL Server Agent (MSSQLSERVER)

When I install "SQL Express SP1 (CTP)", I have not change installation path, so it is default to the same path as "SQL Server 2005" at "%windir%\Program Files\Microsoft SQL Server\".

It seems that "SQL Server 2005 Express" overwrite the previous installation of "SQL Server 2005".

My question is how to install the previous "SQL Server 2005 Management Studio" rather than "SSMS Express".

I will be very appreciated to Any idea to my problem.

cheers,

Stanley Qian

Hi Stanley,

It is expected that SSMS and SSMSE do not run on the same computer. The problem here is related to SQL Server's Upgrade logic with regards to common tools such as SSMS and the fact that you are using Eval and Express Advanced.

I'm going to move this to the Setup forum since the Upgrade logic is their area. Go ahead and file an issue on this in the MSDN Product Feedback Center at http://go.microsoft.com/fwlink/?LinkId=51684.


Regards,

Mike Wachal
SQL Express team