No full-text supported languages found in SQL Server Express with Advanced Services

I've downloaded SQL Server Express with Advanced Services from http://msdn.microsoft.com/vstudio/express/sql/download/ and installed all components. When I try to create a full-text catalog, I get the following message:

No full-text supported languages found.

select * from sys.fulltext_languages
returns no lines.

How

can neutral, English or maybe Hungarian word breakers be installed?

Thanks

Hello Peter

Are you sure you installed Full Text Support option when installing SQL Express?

Thanks,

|||

I have just installed SQL 2005 Express with Advanced Services to test this out and it returns me all the languages fine :

lcid name

-- --

2052 Simplified Chinese

1028 Traditional Chinese

1031 German

2057 British English

1033 English

3082 Spanish

1036 French

1040 Italian

1041 Japanese

1042 Korean

0 Neutral

1043 Dutch

1053 Swedish

1054 Thai

3076 Chinese (Hong Kong SAR, PRC)

5124 Chinese (Macau SAR)

4100 Chinese (Singapore)

(17 row(s) affected)

Just make sure you have install Full Text Search option.

|||It was surely installed because msftesql.exe was running.

I reinstalled Sql Server Express with the following changes and now full-text search works:
- I use default instance instead of named instance
- IIS was enabled during installation
- The installation folder was selected so that to be different from the folder of previous installations.

Maybe the Sql Server 2005 wasn't removed correctly before installing Express and some components had conflict with each other. I don't know what the real reason was of the problem. The important thing is that now it works.|||

Hi,

I Have the same problem, i execute the T-sql statement select * from sys.fulltext_languages and i get zero rows, i uninstalled and installed again and nothing happend i still have zero when executing that statement, i try another computer and there evrything went fine!.. i do have Microsoft Net framework, and everything but i still can get this to work! help please!!!

|||Hello everybody, I am facing the same issue. It's really frustrating.
I have removed and reinstalled SQL Express 3 times, changed the installation path, but no hope.
I can't set it as the default instance since I'm using MSDE as default instance.
Any idea please?|||

Are you sure you actually installed FTS; this feature is not installed by default, you must specifically select it from the feature list. Open up the SQL Configuration Manager and look at the Services node to verify that SQL Server FullText Search is listed and running.

If it's not listed, you didn't install it and you'll need to go into maintenance mode and select it from the feature list to get it installed.

Mike

|||

Hi,

I am having a similar problem. How do I go to maintenance mode? I also can't find anything called "SQL Configuration Manager".

cheers,

Bernie

|||

Hello Mike and thanks for the reply.
Of course I have installed FTS and it's listed in the configuration manager.
This problem is driving me crazy, it has taken 3 days from the tight timeframe of my project and I didn't find any solution.
I have removed MSDE, removed everything related to MsSql from the registry, deleted the installation directory, used "Windows install clean up" and reinstalled SQL Express with FTS as default instance may be more than 5 times and no hope.
Is there any way to install these damn languages manually? in the registry or whatever.
May be the problem is that SQL Express (without Advanced services) was installed previously and some trace is kept in the registry.
I don't know!
Any idea is really appreciated.

No full-text supported languages found in SQL Server Express with Advanced Services

I've downloaded SQL Server Express with Advanced Services from http://msdn.microsoft.com/vstudio/express/sql/download/ and installed all components. When I try to create a full-text catalog, I get the following message:

No full-text supported languages found.

select * from sys.fulltext_languages
returns no lines.

How can neutral, English or maybe Hungarian word breakers be installed?

Thanks

Hello Peter

Are you sure you installed Full Text Support option when installing SQL Express?

Thanks,

|||

I have just installed SQL 2005 Express with Advanced Services to test this out and it returns me all the languages fine :

lcid name

-- --

2052 Simplified Chinese

1028 Traditional Chinese

1031 German

2057 British English

1033 English

3082 Spanish

1036 French

1040 Italian

1041 Japanese

1042 Korean

0 Neutral

1043 Dutch

1053 Swedish

1054 Thai

3076 Chinese (Hong Kong SAR, PRC)

5124 Chinese (Macau SAR)

4100 Chinese (Singapore)

(17 row(s) affected)

Just make sure you have install Full Text Search option.

|||It was surely installed because msftesql.exe was running.

I reinstalled Sql Server Express with the following changes and now full-text search works:
- I use default instance instead of named instance
- IIS was enabled during installation
- The installation folder was selected so that to be different from the folder of previous installations.

Maybe the Sql Server 2005 wasn't removed correctly before installing Express and some components had conflict with each other. I don't know what the real reason was of the problem. The important thing is that now it works.
|||

Hi,

I Have the same problem, i execute the T-sql statement select*fromsys.fulltext_languages and i get zero rows, i uninstalled and installed again and nothing happend i still have zero when executing that statement, i try another computer and there evrything went fine!.. i do have Microsoft Net framework, and everything but i still can get this to work! help please!!!

|||Hello everybody, I am facing the same issue. It's really frustrating.
I have removed and reinstalled SQL Express 3 times, changed the installation path, but no hope.
I can't set it as the default instance since I'm using MSDE as default instance.
Any idea please?
|||

Are you sure you actually installed FTS; this feature is not installed by default, you must specifically select it from the feature list. Open up the SQL Configuration Manager and look at the Services node to verify that SQL Server FullText Search is listed and running.

If it's not listed, you didn't install it and you'll need to go into maintenance mode and select it from the feature list to get it installed.

Mike

|||

Hi,

I am having a similar problem. How do I go to maintenance mode? I also can't find anything called "SQL Configuration Manager".

cheers,

Bernie

|||

Hello Mike and thanks for the reply.
Of course I have installed FTS and it's listed in the configuration manager.
This problem is driving me crazy, it has taken 3 days from the tight timeframe of my project and I didn't find any solution.
I have removed MSDE, removed everything related to MsSql from the registry, deleted the installation directory, used "Windows install clean up" and reinstalled SQL Express with FTS as default instance may be more than 5 times and no hope.
Is there any way to install these damn languages manually? in the registry or whatever.
May be the problem is that SQL Express (without Advanced services) was installed previously and some trace is kept in the registry.
I don't know!
Any idea is really appreciated.

No full-text supported languages found in SQL Server Express with Advanced Services

I've downloaded SQL Server Express with Advanced Services from http://msdn.microsoft.com/vstudio/express/sql/download/ and installed all components. When I try to create a full-text catalog, I get the following message:

No full-text supported languages found.

select * from sys.fulltext_languages
returns no lines.

How

can neutral, English or maybe Hungarian word breakers be installed?

Thanks

Hello Peter

Are you sure you installed Full Text Support option when installing SQL Express?

Thanks,

|||

I have just installed SQL 2005 Express with Advanced Services to test this out and it returns me all the languages fine :

lcid name

-- --

2052 Simplified Chinese

1028 Traditional Chinese

1031 German

2057 British English

1033 English

3082 Spanish

1036 French

1040 Italian

1041 Japanese

1042 Korean

0 Neutral

1043 Dutch

1053 Swedish

1054 Thai

3076 Chinese (Hong Kong SAR, PRC)

5124 Chinese (Macau SAR)

4100 Chinese (Singapore)

(17 row(s) affected)

Just make sure you have install Full Text Search option.

|||It was surely installed because msftesql.exe was running.

I reinstalled Sql Server Express with the following changes and now full-text search works:
- I use default instance instead of named instance
- IIS was enabled during installation
- The installation folder was selected so that to be different from the folder of previous installations.

Maybe the Sql Server 2005 wasn't removed correctly before installing Express and some components had conflict with each other. I don't know what the real reason was of the problem. The important thing is that now it works.|||

Hi,

I Have the same problem, i execute the T-sql statement select * from sys.fulltext_languages and i get zero rows, i uninstalled and installed again and nothing happend i still have zero when executing that statement, i try another computer and there evrything went fine!.. i do have Microsoft Net framework, and everything but i still can get this to work! help please!!!

|||Hello everybody, I am facing the same issue. It's really frustrating.
I have removed and reinstalled SQL Express 3 times, changed the installation path, but no hope.
I can't set it as the default instance since I'm using MSDE as default instance.
Any idea please?|||

Are you sure you actually installed FTS; this feature is not installed by default, you must specifically select it from the feature list. Open up the SQL Configuration Manager and look at the Services node to verify that SQL Server FullText Search is listed and running.

If it's not listed, you didn't install it and you'll need to go into maintenance mode and select it from the feature list to get it installed.

Mike

|||

Hi,

I am having a similar problem. How do I go to maintenance mode? I also can't find anything called "SQL Configuration Manager".

cheers,

Bernie

|||

Hello Mike and thanks for the reply.
Of course I have installed FTS and it's listed in the configuration manager.
This problem is driving me crazy, it has taken 3 days from the tight timeframe of my project and I didn't find any solution.
I have removed MSDE, removed everything related to MsSql from the registry, deleted the installation directory, used "Windows install clean up" and reinstalled SQL Express with FTS as default instance may be more than 5 times and no hope.
Is there any way to install these damn languages manually? in the registry or whatever.
May be the problem is that SQL Express (without Advanced services) was installed previously and some trace is kept in the registry.
I don't know!
Any idea is really appreciated.

No full-text supported languages found in SQL Server Express with Advanced Services

I've downloaded SQL Server Express with Advanced Services from http://msdn.microsoft.com/vstudio/express/sql/download/ and installed all components. When I try to create a full-text catalog, I get the following message:

No full-text supported languages found.

select * from sys.fulltext_languages
returns no lines.

How can neutral, English or maybe Hungarian word breakers be installed?

Thanks

Hello Peter

Are you sure you installed Full Text Support option when installing SQL Express?

Thanks,

|||

I have just installed SQL 2005 Express with Advanced Services to test this out and it returns me all the languages fine :

lcid name

-- --

2052 Simplified Chinese

1028 Traditional Chinese

1031 German

2057 British English

1033 English

3082 Spanish

1036 French

1040 Italian

1041 Japanese

1042 Korean

0 Neutral

1043 Dutch

1053 Swedish

1054 Thai

3076 Chinese (Hong Kong SAR, PRC)

5124 Chinese (Macau SAR)

4100 Chinese (Singapore)

(17 row(s) affected)

Just make sure you have install Full Text Search option.

|||It was surely installed because msftesql.exe was running.

I reinstalled Sql Server Express with the following changes and now full-text search works:
- I use default instance instead of named instance
- IIS was enabled during installation
- The installation folder was selected so that to be different from the folder of previous installations.

Maybe the Sql Server 2005 wasn't removed correctly before installing Express and some components had conflict with each other. I don't know what the real reason was of the problem. The important thing is that now it works.
|||

Hi,

I Have the same problem, i execute the T-sql statement select*fromsys.fulltext_languages and i get zero rows, i uninstalled and installed again and nothing happend i still have zero when executing that statement, i try another computer and there evrything went fine!.. i do have Microsoft Net framework, and everything but i still can get this to work! help please!!!

|||Hello everybody, I am facing the same issue. It's really frustrating.
I have removed and reinstalled SQL Express 3 times, changed the installation path, but no hope.
I can't set it as the default instance since I'm using MSDE as default instance.
Any idea please?
|||

Are you sure you actually installed FTS; this feature is not installed by default, you must specifically select it from the feature list. Open up the SQL Configuration Manager and look at the Services node to verify that SQL Server FullText Search is listed and running.

If it's not listed, you didn't install it and you'll need to go into maintenance mode and select it from the feature list to get it installed.

Mike

|||

Hi,

I am having a similar problem. How do I go to maintenance mode? I also can't find anything called "SQL Configuration Manager".

cheers,

Bernie

|||

Hello Mike and thanks for the reply.
Of course I have installed FTS and it's listed in the configuration manager.
This problem is driving me crazy, it has taken 3 days from the tight timeframe of my project and I didn't find any solution.
I have removed MSDE, removed everything related to MsSql from the registry, deleted the installation directory, used "Windows install clean up" and reinstalled SQL Express with FTS as default instance may be more than 5 times and no hope.
Is there any way to install these damn languages manually? in the registry or whatever.
May be the problem is that SQL Express (without Advanced services) was installed previously and some trace is kept in the registry.
I don't know!
Any idea is really appreciated.

sql

No Email

Hello.
I have created a domain account, granted the account Administrator access on
the report server machine, have changed the two windows services to run as
that account, and have created an Exchange mailbox for the domain account.
I created a simple report that has no data source. I created a shared
calendar that runs every 1 minute. I subscribed to the report on that
schedule, no report.
The report is not being emailed.
Any thoughts?
Thanks in advance,
MikeAlso, SQL server instance is on a different machine.
I don't think that the report is even running. Does reporting services use
the SQL agent?
"mike" <milop@.slomins.com> wrote in message
news:Or03HXtuFHA.2076@.TK2MSFTNGP14.phx.gbl...
> Hello.
> I have created a domain account, granted the account Administrator access
> on the report server machine, have changed the two windows services to run
> as that account, and have created an Exchange mailbox for the domain
> account.
> I created a simple report that has no data source. I created a shared
> calendar that runs every 1 minute. I subscribed to the report on that
> schedule, no report.
> The report is not being emailed.
> Any thoughts?
> Thanks in advance,
> Mike
>|||No,Mike it does not.
"mike" wrote:
> Also, SQL server instance is on a different machine.
> I don't think that the report is even running. Does reporting services use
> the SQL agent?
> "mike" <milop@.slomins.com> wrote in message
> news:Or03HXtuFHA.2076@.TK2MSFTNGP14.phx.gbl...
> > Hello.
> >
> > I have created a domain account, granted the account Administrator access
> > on the report server machine, have changed the two windows services to run
> > as that account, and have created an Exchange mailbox for the domain
> > account.
> >
> > I created a simple report that has no data source. I created a shared
> > calendar that runs every 1 minute. I subscribed to the report on that
> > schedule, no report.
> >
> > The report is not being emailed.
> >
> > Any thoughts?
> >
> > Thanks in advance,
> >
> > Mike
> >
>
>|||As Per my knowledge an SQL Agent job is created for each schedule. SQL Server
Agent is very much required to run the Scheduled SRS Reports.
Ashish
"ProJester" wrote:
> No,Mike it does not.
>
> "mike" wrote:
> > Also, SQL server instance is on a different machine.
> >
> > I don't think that the report is even running. Does reporting services use
> > the SQL agent?
> >
> > "mike" <milop@.slomins.com> wrote in message
> > news:Or03HXtuFHA.2076@.TK2MSFTNGP14.phx.gbl...
> > > Hello.
> > >
> > > I have created a domain account, granted the account Administrator access
> > > on the report server machine, have changed the two windows services to run
> > > as that account, and have created an Exchange mailbox for the domain
> > > account.
> > >
> > > I created a simple report that has no data source. I created a shared
> > > calendar that runs every 1 minute. I subscribed to the report on that
> > > schedule, no report.
> > >
> > > The report is not being emailed.
> > >
> > > Any thoughts?
> > >
> > > Thanks in advance,
> > >
> > > Mike
> > >
> >
> >
> >sql

No disk in drive a:

Good morning
We ask for help please for the following:
From a Windows XP SP2 via Terminal Services (mstsc.exe) we were accessing a
Windows Server 2003 SP1/SQL 2000 SP4.
After remote instruction to be restarted the SQL Server Service, this
service aparentely stops OK, but does not start again
with an error on the master Database.
Note: in Task Manager the SQL Process was still active, not possible to
eliminate
After some attempts to restart the service, we note that other DBs were also
alocated. Allways working via Terminal.
When finally we went to the phisical Server, to restart the machine, we note
the dialog message: There is no disk in drive a:
Note: this dialog does not appear on the terminal side
When this msg was accepted the situation was reestablished.
Is this a known error?
How to solve?
How to be sure that the dialog msg is really mapped to the Terminal
environment?
Thanks
Regards
Rui MendonçaHi RM,
Have a look at this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;281345&sd=tech
Ray
"RM" wrote:
> Good morning
> We ask for help please for the following:
> From a Windows XP SP2 via Terminal Services (mstsc.exe) we were accessing a
> Windows Server 2003 SP1/SQL 2000 SP4.
> After remote instruction to be restarted the SQL Server Service, this
> service aparentely stops OK, but does not start again
> with an error on the master Database.
> Note: in Task Manager the SQL Process was still active, not possible to
> eliminate
> After some attempts to restart the service, we note that other DBs were also
> alocated. Allways working via Terminal.
>
> When finally we went to the phisical Server, to restart the machine, we note
> the dialog message: There is no disk in drive a:
> Note: this dialog does not appear on the terminal side
> When this msg was accepted the situation was reestablished.
>
> Is this a known error?
> How to solve?
> How to be sure that the dialog msg is really mapped to the Terminal
> environment?
> Thanks
> Regards
> Rui Mendonça
>
>|||Hello Rui,
I agree with Ray this issue is related to default error mode handling. Some
settings in terminal session blocks the error dialog which causes the
process of SQL Server to hang. You may want to check if you log on to
Windows with same domain user account and if the issue occurs with other
user account.
Also, please change the registry key ErrorMode Value = 2 to see if there is
any side effect. Usually this error message "There is no disk in drive a:"
does not cause real issue and can be ignored. You may still see the
information logged in event log though the dialog does not prompt.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||I Thank you all for the help.
I have posted a very urgent situation in "microsoft.public.sqlserver.server"
with the name "Event ID: 17052 Urgent"
Please Help
Thanks a lot
Rui Mendonça
""privatenews"" <petery@.online.microsoft.com> wrote in message
news:sJNUcJalGHA.5164@.TK2MSFTNGXA01.phx.gbl...
> Hello Rui,
> I agree with Ray this issue is related to default error mode handling.
> Some
> settings in terminal session blocks the error dialog which causes the
> process of SQL Server to hang. You may want to check if you log on to
> Windows with same domain user account and if the issue occurs with other
> user account.
> Also, please change the registry key ErrorMode Value = 2 to see if there
> is
> any side effect. Usually this error message "There is no disk in drive a:"
> does not cause real issue and can be ignored. You may still see the
> information logged in event log though the dialog does not prompt.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Rui,
Please note I'v replied in that in that thread. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.sql

No designer. Ouch!

We are about to propose to a client that they use Reporting Services instead
of such things like crystal Reports, but it is my understanding that they
would also have to buy VS.NET inorder to design new reports.
Is this correct or are Mirosoft going to be providing a standalone report
designer with Reporting Services, one that doesn't reply on VS?
Thanks in advanceToday you have to buy VS, any version. The cheapest way to do this is VB.Net
($100). As far as cost you are most likely still way ahead of alternatives.
With version 2 (hopefully late summer) it will ship with a version of VS
specifically for RS. I.e. RS designer is still an add-on to VS (they get to
leverage all the nice features of VS) but you won't have to purchase a
version of VS to use the designer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Gravy" <Gravy@.discussions.microsoft.com> wrote in message
news:9BBA50F5-6860-45BF-B7BB-45A3C09C12D2@.microsoft.com...
> We are about to propose to a client that they use Reporting Services
instead
> of such things like crystal Reports, but it is my understanding that they
> would also have to buy VS.NET inorder to design new reports.
> Is this correct or are Mirosoft going to be providing a standalone report
> designer with Reporting Services, one that doesn't reply on VS?
> Thanks in advance
>|||Here's a related question...
On our development machines, we have VS .NET 2003 loaded and use it to
create the reports solution/project and all the RDLs. We then need to copy
all the RDLs, RDSs, etc. to each of our customers' production computer. The
catch is that the reports may need to be modified on each customer's
computer.
So, we thought we would install VB .NET ($100) on each customer computer and
copy all the report files. The question is: Since we created the reports
solution, project, and RDLs in VS .NET 2003, will we be able to open the
solution, make changes to the RDLs, and deploy to the local Report Server
using the VB .NET that's loaded on the customer computer?
Hope that make sense.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OoLG8BVDFHA.2232@.TK2MSFTNGP14.phx.gbl...
> Today you have to buy VS, any version. The cheapest way to do this is
VB.Net
> ($100). As far as cost you are most likely still way ahead of
alternatives.
> With version 2 (hopefully late summer) it will ship with a version of VS
> specifically for RS. I.e. RS designer is still an add-on to VS (they get
to
> leverage all the nice features of VS) but you won't have to purchase a
> version of VS to use the designer.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Gravy" <Gravy@.discussions.microsoft.com> wrote in message
> news:9BBA50F5-6860-45BF-B7BB-45A3C09C12D2@.microsoft.com...
> > We are about to propose to a client that they use Reporting Services
> instead
> > of such things like crystal Reports, but it is my understanding that
they
> > would also have to buy VS.NET inorder to design new reports.
> >
> > Is this correct or are Mirosoft going to be providing a standalone
report
> > designer with Reporting Services, one that doesn't reply on VS?
> >
> > Thanks in advance
> >
> >
>|||Yes, you can do what you propose. However, VS.Net may not be necessary on
the customers' computers. Since RDL is XML, you can use any application
capable of editing XML to modify the reports. To deploy, you can write a
simple application which uses the RS SOAP API. There is some code in the
samples which does this.
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"MrBill" <mrbill@.nospam.com> wrote in message
news:#IwpmbWDFHA.3504@.TK2MSFTNGP12.phx.gbl...
> Here's a related question...
> On our development machines, we have VS .NET 2003 loaded and use it to
> create the reports solution/project and all the RDLs. We then need to
copy
> all the RDLs, RDSs, etc. to each of our customers' production computer.
The
> catch is that the reports may need to be modified on each customer's
> computer.
> So, we thought we would install VB .NET ($100) on each customer computer
and
> copy all the report files. The question is: Since we created the reports
> solution, project, and RDLs in VS .NET 2003, will we be able to open the
> solution, make changes to the RDLs, and deploy to the local Report Server
> using the VB .NET that's loaded on the customer computer?
> Hope that make sense.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OoLG8BVDFHA.2232@.TK2MSFTNGP14.phx.gbl...
> > Today you have to buy VS, any version. The cheapest way to do this is
> VB.Net
> > ($100). As far as cost you are most likely still way ahead of
> alternatives.
> > With version 2 (hopefully late summer) it will ship with a version of VS
> > specifically for RS. I.e. RS designer is still an add-on to VS (they get
> to
> > leverage all the nice features of VS) but you won't have to purchase a
> > version of VS to use the designer.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Gravy" <Gravy@.discussions.microsoft.com> wrote in message
> > news:9BBA50F5-6860-45BF-B7BB-45A3C09C12D2@.microsoft.com...
> > > We are about to propose to a client that they use Reporting Services
> > instead
> > > of such things like crystal Reports, but it is my understanding that
> they
> > > would also have to buy VS.NET inorder to design new reports.
> > >
> > > Is this correct or are Mirosoft going to be providing a standalone
> report
> > > designer with Reporting Services, one that doesn't reply on VS?
> > >
> > > Thanks in advance
> > >
> > >
> >
> >
>|||take a look at 90 degree software - they have exactly that.
"Gravy" wrote:
> We are about to propose to a client that they use Reporting Services instead
> of such things like crystal Reports, but it is my understanding that they
> would also have to buy VS.NET inorder to design new reports.
> Is this correct or are Mirosoft going to be providing a standalone report
> designer with Reporting Services, one that doesn't reply on VS?
> Thanks in advance
>|||Is your client using SQL 2000 or SQL 2005? If they are using SQL 2005 - then
they will already have a report designer INCLUDED and will not need to buy
from 90 degrees software. 90 degrees appears to have a nice report
designer - but it better be for 850 bucks!
=-Chris
"Tips" <Tips@.discussions.microsoft.com> wrote in message
news:68D157EC-75D1-41F1-BD0A-5B96F506880D@.microsoft.com...
> take a look at 90 degree software - they have exactly that.
> "Gravy" wrote:
>> We are about to propose to a client that they use Reporting Services
>> instead
>> of such things like crystal Reports, but it is my understanding that they
>> would also have to buy VS.NET inorder to design new reports.
>> Is this correct or are Mirosoft going to be providing a standalone report
>> designer with Reporting Services, one that doesn't reply on VS?
>> Thanks in advance
>>|||Plus, if someone is just getting into they should definitely go with RS
2005. The additional features and performance are worth it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris Conner" <Chris.Conner@.NOSPAMPolarisLibrary.com> wrote in message
news:e28sUlg%23GHA.3312@.TK2MSFTNGP02.phx.gbl...
> Is your client using SQL 2000 or SQL 2005? If they are using SQL 2005 -
> then they will already have a report designer INCLUDED and will not need
> to buy from 90 degrees software. 90 degrees appears to have a nice report
> designer - but it better be for 850 bucks!
> =-Chris
> "Tips" <Tips@.discussions.microsoft.com> wrote in message
> news:68D157EC-75D1-41F1-BD0A-5B96F506880D@.microsoft.com...
>> take a look at 90 degree software - they have exactly that.
>> "Gravy" wrote:
>> We are about to propose to a client that they use Reporting Services
>> instead
>> of such things like crystal Reports, but it is my understanding that
>> they
>> would also have to buy VS.NET inorder to design new reports.
>> Is this correct or are Mirosoft going to be providing a standalone
>> report
>> designer with Reporting Services, one that doesn't reply on VS?
>> Thanks in advance
>>
>

No Data Selected message back to .Net

Hi All
We have a .net application calling some reporting services reports and we
pass the parameters to the reports from the application.
When no data is selected, is there any way to pass a paramter or something
back to the .net application so that we can display a 'No data selected'
message within the .net application.
Thanks
PeteI don't know if you can hook into this at the report level, but the data
regions (table, subreport, matrix, etc.) have a NoRows property that can
display a message if the source data set is empty.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"P" <P@.discussions.microsoft.com> wrote in message
news:B52C45F6-E67A-42B9-8517-3107FA071C93@.microsoft.com...
> Hi All
> We have a .net application calling some reporting services reports and we
> pass the parameters to the reports from the application.
> When no data is selected, is there any way to pass a paramter or something
> back to the .net application so that we can display a 'No data selected'
> message within the .net application.
> Thanks
> Pete

No connection could be made because the target machine actively refused it

Hi,

I have successfully created a project (using VS.Net 2003 and SQL Server Analysis Services 2000) which is dynamically retrieving dimensions, levels, and members, and i generating and executing a query as per user needs and requirements. However when I tried to deploy the project on another machine, even though the apps is running fine, and the query getting generated, when its trying to show the data in the report-display page using ADOMD.Net, the following error was shown.

No connection could be made because the target machine actively refused it

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SocketException (0x274d): No connection could be made because the target machine actively refused it]

System.Net.Sockets.Socket.Connect(EndPoint remoteEP) +307

System.Net.Sockets.TcpClient.Connect(IPEndPoint remoteEP) +24

System.Net.Sockets.TcpClient.Connect(IPAddress address, Int32 port) +81

Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) +208

[AdomdConnectionException: A connection cannot be made. Ensure that the server is running.]

Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) +384

Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo) +51

Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) +398

Microsoft.AnalysisServices.AdomdClient.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection+IXmlaClientProviderEx.ConnectXmla() +124

Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) +144

Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() +601

cubicdimension.Reportdisp.Page_Load(Object sender, EventArgs e) in E:\Inetpub\wwwroot\cubicdimension\Reportdisp.aspx.vb:65

System.Web.UI.Control.OnLoad(EventArgs e) +67

System.Web.UI.Control.LoadRecursive() +35

System.Web.UI.Page.ProcessRequestMain() +731

May I mention here, that the computer where I tried deploying, has SQL Server 2000 as well as SQL Server 2005. I tried reinstalling MSXML, but the computer already has a higher version of MSXML.

Any help in this regard would be appreciated.

Best Wishes.

Check Programs/SQL Server 2005/ Configuration tools/SQL Server Surface Area Configuration.

In "Surface Area Configuration for services and connection", you click on the service and remote connections.

See that you have local and remote connections activated.

HTH

Thomas Ivarsson

No "Existing" word... How?

I am rendering an Association Rules on Report Services. How do I make to filter the word "Existing", just like example below? I want to show attribute name only.

Pneu ML Road = Existing, Sport-100 = Existing -> Road Tubo de Pneu = Existing

to

Pneu ML Road, Sport-100 -> Road Tubo de Pneu

By the way I am using this code:

SELECT NODE_DESCRIPTION,ROUND(NODE_PROBABILITY,2)AS Probabilidade,ROUND(MSOLAP_NODE_SCORE,2)AS Importancia
from [Association].CONTENT
where NODE_TYPE=8

NODE_DESCRIPTION is a string field generated by the algorithm. It contains predicates having the form "Attribute = value" which, in the case of nested table keys, translate to "Road Tubo = Existing".

The "Existing" keyword cannot be removed from the NODE_DESCRIPTION. However, it is coming from the server's string resources. That means, if you install a localized version of the server, you will get a localized version of Existing. Furthermore, the server will attempt to "localize" the Existing string to the thread locales of the client application, as long as the respective resources are available on the server side.

Now, to get rid completely of the Existing keyword, there are a few ways:

- write a server side stored procedure which: traverses the rules in the model content, extracts the node unique names for the itemsets as well as the attribute states, then generates a string which contains the attribute name but not the value (pretty much what the stored procedures used by the built-in viewer do).

Then, invoke the stored procedure with a CALL statement.

OR:

- write a very simple C# class library, containing a single function, Replace, which takes 3 strings as arguments

string Replace(string source, string oldValue, string newValue)

{

return source.Replace(oldValue, newValue);

}

Then, deploy the assembly on the server and change your query like below:

SELECT MyAssembly.Replace(NODE_DESCRIPTION, '= Existing', ''),ROUND(NODE_PROBABILITY,2)AS Probabilidade,ROUND(MSOLAP_NODE_SCORE,2)AS Importancia
from [Association].CONTENT
where NODE_TYPE=8

While not as reliable as the first solution, this is much easier to implement and will generally work correctly, as long as the only attributes in your model are the nested table keys .

|||

You did inspired me, but I found a better solution:

Just click right button on the table, click in "Expression" and change the code Fields!Regra.Value to =Replace(Fields!Regra.Value," = Existing","")

Thank you very much!

Next Version of Reporting Services

Hi,
Does anyone know when Microsoft is releasing next version of Reporting
Service with all the issues resolved
PonnurangamSorry, I have seen no date yet for SP2. But if you really mean "next
version", the answer is the first half of 2005; it's in SQL Server 2005.
hth
Eric
Ponnurangam wrote:
> Hi,
> Does anyone know when Microsoft is releasing next version of Reporting
> Service with all the issues resolved
> Ponnurangam

Next version availability

Hello
I'd like to know if the next version of Reporting Services, scheduled for
release along with SQL Server 2005, will be available for previous versions
of SQL Server, specifically, SQL Server 2000?This is my understanding of how it will work. You have to have a license for
SQL Server 2005 in order to run RS 2005. But, the databases used by RS can
reside on a SQL Server 2000 database. If that is not the case I will be
screaming as loud as anyone else.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Matan Holtzer" <MatanHoltzer@.discussions.microsoft.com> wrote in message
news:5FF5E9D1-D69E-482F-BCA9-B171D29FB26B@.microsoft.com...
> Hello
> I'd like to know if the next version of Reporting Services, scheduled for
> release along with SQL Server 2005, will be available for previous
> versions
> of SQL Server, specifically, SQL Server 2000?|||Thanks Bruce
Along with your answer, I took the time and installed RS from SS2005 (latest
Beta) using SS2000 as the database, and it works - at least up to the point
of finishing the installation and initializing. I still have to wait for the
Beta 2 of VS2005 to fully test it.
- Matan -
"Bruce L-C [MVP]" wrote:
> This is my understanding of how it will work. You have to have a license for
> SQL Server 2005 in order to run RS 2005. But, the databases used by RS can
> reside on a SQL Server 2000 database. If that is not the case I will be
> screaming as loud as anyone else.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Matan Holtzer" <MatanHoltzer@.discussions.microsoft.com> wrote in message
> news:5FF5E9D1-D69E-482F-BCA9-B171D29FB26B@.microsoft.com...
> > Hello
> > I'd like to know if the next version of Reporting Services, scheduled for
> > release along with SQL Server 2005, will be available for previous
> > versions
> > of SQL Server, specifically, SQL Server 2000?
>
>

next release or SP2 for Reporting services?

Hi cant seem to find any info on when SP2 or the next release is due? I know
SP1 was June 2004
Thanks Paulahh, just used the infamous "search" button ;)
"Paul" wrote:
> Hi cant seem to find any info on when SP2 or the next release is due? I know
> SP1 was June 2004
> Thanks Paul

Newspaper Columns

Does anyone know how to create Newspaper Columns in Reporting Services? I am
trying to create a company address and phone number directory.
Thanks for any help you can offer.In the Body section of the report, open your properties window. There is a
property under layout called columns. Set the number of columns here.
Then, if you want 2 3" columns w/ 1/2" between them, you would set your
report width to 6.5 and your body width to 3".
msflinx
"GR Pilot" wrote:
> Does anyone know how to create Newspaper Columns in Reporting Services? I am
> trying to create a company address and phone number directory.
> Thanks for any help you can offer.

newline in format string

Can I insert a newline character within a reporting services format string?
I guess \n doesn't work since it is interpreted as a VisualBasic format
string...? Is there an alternative?
Thanks,
Michael CarrvbNewLine
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:uOApiLweEHA.3200@.TK2MSFTNGP09.phx.gbl...
> Can I insert a newline character within a reporting services format
string?
> I guess \n doesn't work since it is interpreted as a VisualBasic format
> string...? Is there an alternative?
> Thanks,
> Michael Carr
>|||Hmm I think I may have located a bug...
1. If I use vbNewline in the FORMAT STRING, i.e. = "M/dd/yy" & vbNewline &
"h:mm tt", then the vbNewline gets rendered (using the HTML renderer, at
least) out to a linefeed in the HTML textfile which does NOT translate into
a linefeed in the browser.
2. On the other hand, if I use vbNewline in the VALUE itself, i.e. =Format(Fields!Date.Value, "M/dd/yy") & vbNewline & Format(Fields!Date.Value,
"h:mm tt"), then the vbNewline is rendered out as <br/>
This seems to be an inconsistency in the HTML renderer ... ?
Michael Carr
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:eXqVC9weEHA.3680@.TK2MSFTNGP11.phx.gbl...
> vbNewLine
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Michael Carr" <mcarr@.umich.edu> wrote in message
> news:uOApiLweEHA.3200@.TK2MSFTNGP09.phx.gbl...
> > Can I insert a newline character within a reporting services format
> string?
> >
> > I guess \n doesn't work since it is interpreted as a VisualBasic format
> > string...? Is there an alternative?
> >
> > Thanks,
> > Michael Carr
> >
> >
>|||Please clarify the steps to reproduce. I tried the first expression on SP1
and I get <br/>. Here's the expression I used: ="1/1/2004" & vbNewLine &
"12:00:00".
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:OhZEbx0eEHA.2604@.TK2MSFTNGP12.phx.gbl...
> Hmm I think I may have located a bug...
> 1. If I use vbNewline in the FORMAT STRING, i.e. = "M/dd/yy" & vbNewline &
> "h:mm tt", then the vbNewline gets rendered (using the HTML renderer, at
> least) out to a linefeed in the HTML textfile which does NOT translate
into
> a linefeed in the browser.
> 2. On the other hand, if I use vbNewline in the VALUE itself, i.e. => Format(Fields!Date.Value, "M/dd/yy") & vbNewline &
Format(Fields!Date.Value,
> "h:mm tt"), then the vbNewline is rendered out as <br/>
> This seems to be an inconsistency in the HTML renderer ... ?
> Michael Carr
>
> "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
> news:eXqVC9weEHA.3680@.TK2MSFTNGP11.phx.gbl...
> > vbNewLine
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > "Michael Carr" <mcarr@.umich.edu> wrote in message
> > news:uOApiLweEHA.3200@.TK2MSFTNGP09.phx.gbl...
> > > Can I insert a newline character within a reporting services format
> > string?
> > >
> > > I guess \n doesn't work since it is interpreted as a VisualBasic
format
> > > string...? Is there an alternative?
> > >
> > > Thanks,
> > > Michael Carr
> > >
> > >
> >
> >
>|||Ravi,
Please see the report below (and attached) for an example. Note that this
renders correctly in the Report Editor Preview, but does not render
correctly in the Report Manager.
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Table Name="table1">
<Height>0.75in</Height>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
�Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>5</ZIndex>
<rd:DefaultName>textbox1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Date</Value>
�/Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
�Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>textbox2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Date</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="Date">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<Format>= "M/d/yyyy" & vbNewline & "h:mm tt"</Format>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>Date</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!Date.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Date_1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>Date_1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Format(Fields!Date.Value, "M/d/yyyy") & vbNewline &
Format(Fields!Date.Value, "h:mm tt")</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Details>
<DataSetName>DataSet1</DataSetName>
<Top>0.5in</Top>
<Width>4.33333in</Width>
<Footer>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>textbox7</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>textbox8</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Footer>
<Left>1.125in</Left>
<TableColumns>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Style />
<Height>2in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="SkyScheduler">
<rd:DataSourceID>6617abfe-bebd-49ae-a365-417ab349c748</rd:DataSourceID>
<DataSourceReference>SkyScheduler</DataSourceReference>
</DataSource>
</DataSources>
<Width>6.5in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="Date">
<DataField>Date</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>SkyScheduler</DataSourceName>
<CommandText>SELECT CONVERT(smalldatetime, '1/1/2000 3:00pm') AS
Date</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>6c9977cc-7283-416b-a107-65d98a0c8dd2</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:ODeNfFnfEHA.708@.TK2MSFTNGP09.phx.gbl...
> Please clarify the steps to reproduce. I tried the first expression on SP1
> and I get <br/>. Here's the expression I used: ="1/1/2004" & vbNewLine &
> "12:00:00".
begin 666 BRExample.rdl
M/#]X;6P@.=F5R<VEO;CTB,2XP(B!E;F-O9&EN9STB=71F+3@.B/SX-"CQ297!O
M<G0@.>&UL;G,](FAT=' Z+R]S8VAE;6%S+FUI8W)O<V]F="YC;VTO<W%L<V5R
M=F5R+W)E<&]R=&EN9R\R,# S+S$P+W)E<&]R=&1E9FEN:71I;VXB('AM;&YS
M.G)D/2)H='1P.B\O<V-H96UA<RYM:6-R;W-O9G0N8V]M+U-13%-E<G9E<B]R
M97!O<G1I;F<O<F5P;W)T9&5S:6=N97(B/@.T*(" \4FEG:'1-87)G:6X^,6EN
M/"]2:6=H=$UA<F=I;CX-"B @./$)O9'D^#0H@.(" @./%)E<&]R=$ET96US/@.T*
M(" @.(" @./%1A8FQE($YA;64](G1A8FQE,2(^#0H@.(" @.(" @.(#Q(96EG:'0^
M,"XW-6EN/"](96EG:'0^#0H@.(" @.(" @.(#Q3='EL92 O/@.T*(" @.(" @.(" \
M2&5A9&5R/@.T*(" @.(" @.(" @.(#Q486)L95)O=W,^#0H@.(" @.(" @.(" @.(" \
M5&%B;&52;W<^#0H@.(" @.(" @.(" @.(" @.(#Q(96EG:'0^,"XR-6EN/"](96EG
M:'0^#0H@.(" @.(" @.(" @.(" @.(#Q486)L94-E;&QS/@.T*(" @.(" @.(" @.(" @.
M(" @.(#Q486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @.(" \4F5P;W)T271E
M;7,^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT8F]X($YA;64](G1E>'1B
M;W@.Q(CX-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4W1Y;&4^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9TQE9G0^,G!T/"]0861D:6YG3&5F
M=#X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT06QI9VX^3&5F=#PO
M5&5X=$%L:6=N/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F="
M;W1T;VT^,G!T/"]0861D:6YG0F]T=&]M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @./%!A9&1I;F=4;W ^,G!T/"]0861D:6YG5&]P/@.T*(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=2:6=H=#XR<'0\+U!A9&1I;F=2:6=H
M=#X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \+U-T>6QE/@.T*(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(#Q:26YD97@.^-3PO6DEN9&5X/@.T*(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(#QR9#I$969A=6QT3F%M93YT97AT8F]X,3PO<F0Z1&5F875L
M=$YA;64^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./$-A;D=R;W<^=')U93PO
M0V%N1W)O=SX-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \5F%L=64^1&%T93PO
M5F%L=64^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#PO5&5X=&)O>#X-"B @.(" @.
M(" @.(" @.(" @.(" @.(#PO4F5P;W)T271E;7,^#0H@.(" @.(" @.(" @.(" @.(" @.
M/"]486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @./%1A8FQE0V5L;#X-"B @.
M(" @.(" @.(" @.(" @.(" @.(#Q297!O<G1)=&5M<SX-"B @.(" @.(" @.(" @.(" @.
M(" @.(" @./%1E>'1B;W@.@.3F%M93TB=&5X=&)O>#(B/@.T*(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(#Q3='EL93X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q0
M861D:6YG3&5F=#XR<'0\+U!A9&1I;F=,969T/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @./%1E>'1!;&EG;CY,969T/"]497AT06QI9VX^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9T)O='1O;3XR<'0\+U!A9&1I;F="
M;W1T;VT^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9U1O<#XR
M<'0\+U!A9&1I;F=4;W ^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D
M9&EN9U)I9VAT/C)P=#PO4&%D9&EN9U)I9VAT/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(#PO4W1Y;&4^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%I);F1E
M>#XT/"]:26YD97@.^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./')D.D1E9F%U
M;'1.86UE/G1E>'1B;W@.R/"]R9#I$969A=6QT3F%M93X-"B @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" \0V%N1W)O=SYT<G5E/"]#86Y'<F]W/@.T*(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(#Q686QU93Y$871E/"]686QU93X-"B @.(" @.(" @.(" @.
M(" @.(" @.(" @./"]497AT8F]X/@.T*(" @.(" @.(" @.(" @.(" @.(" @./"]297!O
M<G1)=&5M<SX-"B @.(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;#X-"B @.(" @.
M(" @.(" @.(" @./"]486)L94-E;&QS/@.T*(" @.(" @.(" @.(" @./"]486)L95)O
M=SX-"B @.(" @.(" @.(" \+U1A8FQE4F]W<SX-"B @.(" @.(" @./"](96%D97(^
M#0H@.(" @.(" @.(#Q$971A:6QS/@.T*(" @.(" @.(" @.(#Q486)L95)O=W,^#0H@.
M(" @.(" @.(" @.(" \5&%B;&52;W<^#0H@.(" @.(" @.(" @.(" @.(#Q(96EG:'0^
M,"XR-6EN/"](96EG:'0^#0H@.(" @.(" @.(" @.(" @.(#Q486)L94-E;&QS/@.T*
M(" @.(" @.(" @.(" @.(" @.(#Q486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @.
M(" \4F5P;W)T271E;7,^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT8F]X
M($YA;64](D1A=&4B/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q3='EL93X-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q0861D:6YG3&5F=#XR<'0\+U!A
M9&1I;F=,969T/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./$9O<FUA=#X]
M(")-+V0O>7EY>2(@.)F%M<#L@.=F).97=L:6YE("9A;7 [(")H.FUM('1T(CPO
M1F]R;6%T/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%1E>'1!;&EG;CY,
M969T/"]497AT06QI9VX^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D
M9&EN9T)O='1O;3XR<'0\+U!A9&1I;F=";W1T;VT^#0H@.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" \4&%D9&EN9U1O<#XR<'0\+U!A9&1I;F=4;W ^#0H@.(" @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9U)I9VAT/C)P=#PO4&%D9&EN
M9U)I9VAT/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#PO4W1Y;&4^#0H@.(" @.
M(" @.(" @.(" @.(" @.(" @.(" @./%I);F1E>#XQ/"]:26YD97@.^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @./')D.D1E9F%U;'1.86UE/D1A=&4\+W)D.D1E9F%U
M;'1.86UE/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q#86Y'<F]W/G1R=64\
M+T-A;D=R;W<^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%9A;'5E/CU&:65L
M9',A1&%T92Y686QU93PO5F%L=64^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#PO
M5&5X=&)O>#X-"B @.(" @.(" @.(" @.(" @.(" @.(#PO4F5P;W)T271E;7,^#0H@.
M(" @.(" @.(" @.(" @.(" @./"]486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @.
M/%1A8FQE0V5L;#X-"B @.(" @.(" @.(" @.(" @.(" @.(#Q297!O<G1)=&5M<SX-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @./%1E>'1B;W@.@.3F%M93TB1&%T95\Q(CX-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4W1Y;&4^#0H@.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" \4&%D9&EN9TQE9G0^,G!T/"]0861D:6YG3&5F=#X-"B @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT06QI9VX^3&5F=#PO5&5X=$%L
M:6=N/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=";W1T;VT^
M,G!T/"]0861D:6YG0F]T=&]M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.
M/%!A9&1I;F=4;W ^,G!T/"]0861D:6YG5&]P/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @./%!A9&1I;F=2:6=H=#XR<'0\+U!A9&1I;F=2:6=H=#X-"B @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" \+U-T>6QE/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(#QR9#I$969A=6QT3F%M93Y$871E7S$\+W)D.D1E9F%U;'1.86UE
M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q#86Y'<F]W/G1R=64\+T-A;D=R
M;W<^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%9A;'5E/CU&;W)M870H1FEE
M;&1S(41A=&4N5F%L=64L(")-+V0O>7EY>2(I("9A;7 [('9B3F5W;&EN92 F
M86UP.R!&;W)M870H1FEE;&1S(41A=&4N5F%L=64L(")H.FUM('1T(BD\+U9A
M;'5E/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" \+U1E>'1B;W@.^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" \+U)E<&]R=$ET96US/@.T*(" @.(" @.(" @.(" @.(" @.(#PO
M5&%B;&5#96QL/@.T*(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;',^#0H@.(" @.
M(" @.(" @.(" \+U1A8FQE4F]W/@.T*(" @.(" @.(" @.(#PO5&%B;&52;W=S/@.T*
M(" @.(" @.(" \+T1E=&%I;',^#0H@.(" @.(" @.(#Q$871A4V5T3F%M93Y$871A
M4V5T,3PO1&%T85-E=$YA;64^#0H@.(" @.(" @.(#Q4;W ^,"XU:6X\+U1O<#X-
M"B @.(" @.(" @./%=I9'1H/C0N,S,S,S-I;CPO5VED=&@.^#0H@.(" @.(" @.(#Q&
M;V]T97(^#0H@.(" @.(" @.(" @./%1A8FQE4F]W<SX-"B @.(" @.(" @.(" @.(#Q4
M86)L95)O=SX-"B @.(" @.(" @.(" @.(" @./$AE:6=H=#XP+C(U:6X\+TAE:6=H
M=#X-"B @.(" @.(" @.(" @.(" @./%1A8FQE0V5L;',^#0H@.(" @.(" @.(" @.(" @.
M(" @./%1A8FQE0V5L;#X-"B @.(" @.(" @.(" @.(" @.(" @.(#Q297!O<G1)=&5M
M<SX-"B @.(" @.(" @.(" @.(" @.(" @.(" @./%1E>'1B;W@.@.3F%M93TB=&5X=&)O
M>#<B/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q3='EL93X-"B @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(#Q0861D:6YG3&5F=#XR<'0\+U!A9&1I;F=,969T
M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=";W1T;VT^,G!T
M/"]0861D:6YG0F]T=&]M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A
M9&1I;F=4;W ^,G!T/"]0861D:6YG5&]P/@.T*(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @./%!A9&1I;F=2:6=H=#XR<'0\+U!A9&1I;F=2:6=H=#X-"B @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" \+U-T>6QE/@.T*(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(#Q:26YD97@.^,SPO6DEN9&5X/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.
M(#QR9#I$969A=6QT3F%M93YT97AT8F]X-SPO<F0Z1&5F875L=$YA;64^#0H@.
M(" @.(" @.(" @.(" @.(" @.(" @.(" @./$-A;D=R;W<^=')U93PO0V%N1W)O=SX-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \5F%L=64@.+SX-"B @.(" @.(" @.(" @.
M(" @.(" @.(" @./"]497AT8F]X/@.T*(" @.(" @.(" @.(" @.(" @.(" @./"]297!O
M<G1)=&5M<SX-"B @.(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;#X-"B @.(" @.
M(" @.(" @.(" @.(" \5&%B;&5#96QL/@.T*(" @.(" @.(" @.(" @.(" @.(" @./%)E
M<&]R=$ET96US/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" \5&5X=&)O>"!.86UE
M/2)T97AT8F]X."(^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%-T>6QE/@.T*
M(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=,969T/C)P=#PO4&%D
M9&EN9TQE9G0^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9T)O
M='1O;3XR<'0\+U!A9&1I;F=";W1T;VT^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" \4&%D9&EN9U1O<#XR<'0\+U!A9&1I;F=4;W ^#0H@.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" \4&%D9&EN9U)I9VAT/C)P=#PO4&%D9&EN9U)I9VAT
M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#PO4W1Y;&4^#0H@.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @./%I);F1E>#XR/"]:26YD97@.^#0H@.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @./')D.D1E9F%U;'1.86UE/G1E>'1B;W@.X/"]R9#I$969A=6QT
M3F%M93X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \0V%N1W)O=SYT<G5E/"]#
M86Y'<F]W/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q686QU92 O/@.T*(" @.
M(" @.(" @.(" @.(" @.(" @.(" \+U1E>'1B;W@.^#0H@.(" @.(" @.(" @.(" @.(" @.
M(" \+U)E<&]R=$ET96US/@.T*(" @.(" @.(" @.(" @.(" @.(#PO5&%B;&5#96QL
M/@.T*(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;',^#0H@.(" @.(" @.(" @.(" \
M+U1A8FQE4F]W/@.T*(" @.(" @.(" @.(#PO5&%B;&52;W=S/@.T*(" @.(" @.(" \
M+T9O;W1E<CX-"B @.(" @.(" @./$QE9G0^,2XQ,C5I;CPO3&5F=#X-"B @.(" @.
M(" @./%1A8FQE0V]L=6UN<SX-"B @.(" @.(" @.(" \5&%B;&5#;VQU;6X^#0H@.
M(" @.(" @.(" @.(" \5VED=&@.^,BXQ-C8V-VEN/"]7:61T:#X-"B @.(" @.(" @.
M(" \+U1A8FQE0V]L=6UN/@.T*(" @.(" @.(" @.(#Q486)L94-O;'5M;CX-"B @.
M(" @.(" @.(" @.(#Q7:61T:#XR+C$V-C8W:6X\+U=I9'1H/@.T*(" @.(" @.(" @.
M(#PO5&%B;&5#;VQU;6X^#0H@.(" @.(" @.(#PO5&%B;&5#;VQU;6YS/@.T*(" @.
M(" @./"]486)L93X-"B @.(" \+U)E<&]R=$ET96US/@.T*(" @.(#Q3='EL92 O
M/@.T*(" @.(#Q(96EG:'0^,FEN/"](96EG:'0^#0H@.(#PO0F]D>3X-"B @./%1O
M<$UA<F=I;CXQ:6X\+U1O<$UA<F=I;CX-"B @./$1A=&%3;W5R8V5S/@.T*(" @.
M(#Q$871A4V]U<F-E($YA;64](E-K>5-C:&5D=6QE<B(^#0H@.(" @.(" \<F0Z
M1&%T85-O=7)C94E$/C8V,3=A8F9E+6)E8F0M-#EA92UA,S8U+30Q-V%B,S0Y
M8S<T.#PO<F0Z1&%T85-O=7)C94E$/@.T*(" @.(" @./$1A=&%3;W5R8V52969E
M<F5N8V4^4VMY4V-H961U;&5R/"]$871A4V]U<F-E4F5F97)E;F-E/@.T*(" @.
M(#PO1&%T85-O=7)C93X-"B @./"]$871A4V]U<F-E<SX-"B @./%=I9'1H/C8N
M-6EN/"]7:61T:#X-"B @./$1A=&%3971S/@.T*(" @.(#Q$871A4V5T($YA;64]
M(D1A=&%3970Q(CX-"B @.(" @.(#Q&:65L9',^#0H@.(" @.(" @.(#Q&:65L9"!.
M86UE/2)$871E(CX-"B @.(" @.(" @.(" \1&%T849I96QD/D1A=&4\+T1A=&%&
M:65L9#X-"B @.(" @.(" @.(" \<F0Z5'EP94YA;64^4WES=&5M+D1A=&54:6UE
M/"]R9#I4>7!E3F%M93X-"B @.(" @.(" @./"]&:65L9#X-"B @.(" @.(#PO1FEE
M;&1S/@.T*(" @.(" @./%%U97)Y/@.T*(" @.(" @.(" \1&%T85-O=7)C94YA;64^
M4VMY4V-H961U;&5R/"]$871A4V]U<F-E3F%M93X-"B @.(" @.(" @./$-O;6UA
M;F1497AT/E-%3$5#5"!#3TY615)4*'-M86QL9&%T971I;64L("<Q+S$O,C P
M," S.C P<&TG*2!!4R!$871E/"]#;VUM86YD5&5X=#X-"B @.(" @.(" @./')D
M.E5S94=E;F5R:6-$97-I9VYE<CYT<G5E/"]R9#I5<V5'96YE<FEC1&5S:6=N
M97(^#0H@.(" @.(" \+U%U97)Y/@.T*(" @.(#PO1&%T85-E=#X-"B @./"]$871A
M4V5T<SX-"B @./$QE9G1-87)G:6X^,6EN/"],969T36%R9VEN/@.T*(" \<F0Z
M4VYA<%1O1W)I9#YT<G5E/"]R9#I3;F%P5&]'<FED/@.T*(" \<F0Z1')A=T=R
M:60^=')U93PO<F0Z1')A=T=R:60^#0H@.(#QR9#I297!O<G1)1#XV8SDY-S=C
M8RTW,C@.S+30Q-F(M83$P-RTV-60Y.&$P8SAD9#(\+W)D.E)E<&]R=$E$/@.T*
M(" \0F]T=&]M36%R9VEN/C%I;CPO0F]T=&]M36%R9VEN/@.T*(" \3&%N9W5A
>9V4^96XM55,\+TQA;F=U86=E/@.T*/"]297!O<G0^
`
end|||Ravi,
Did you get a chance to look at the example I posted?
Michael Carr
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:uBDHDenfEHA.3676@.TK2MSFTNGP12.phx.gbl...
> Ravi,
> Please see the report below (and attached) for an example. Note that this
> renders correctly in the Report Editor Preview, but does not render
> correctly in the Report Manager.|||I will look into this today.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:eOjzh9ShEHA.3864@.TK2MSFTNGP10.phx.gbl...
> Ravi,
> Did you get a chance to look at the example I posted?
> Michael Carr
> "Michael Carr" <mcarr@.umich.edu> wrote in message
> news:uBDHDenfEHA.3676@.TK2MSFTNGP12.phx.gbl...
> > Ravi,
> >
> > Please see the report below (and attached) for an example. Note that
this
> > renders correctly in the Report Editor Preview, but does not render
> > correctly in the Report Manager.
>|||I have logged this as a bug in HTML renderer which may be fixed in a future
release. Thanks for reporting this issue.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:OXh8fEThEHA.3916@.TK2MSFTNGP11.phx.gbl...
> I will look into this today.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Michael Carr" <mcarr@.umich.edu> wrote in message
> news:eOjzh9ShEHA.3864@.TK2MSFTNGP10.phx.gbl...
> > Ravi,
> >
> > Did you get a chance to look at the example I posted?
> >
> > Michael Carr
> >
> > "Michael Carr" <mcarr@.umich.edu> wrote in message
> > news:uBDHDenfEHA.3676@.TK2MSFTNGP12.phx.gbl...
> > > Ravi,
> > >
> > > Please see the report below (and attached) for an example. Note that
> this
> > > renders correctly in the Report Editor Preview, but does not render
> > > correctly in the Report Manager.
> >
> >
>

Newbie: what kind of "cube" is this?

1. In sql 2005 Analysis services how can I tell what kind of "cube" I'm viewing -- ROLAP, HOLAP, or MOLAP?

2. During cube creation where do I specify the type of "cube" I want to create

TIA,

Barkingdog

The cube wizard will not ask you for the storage settings that you want to use. After you have run the wizard and created the cube, go to the "Partitions" tab of the cube editor. You will then see information for your partitions. You can click on a partition and then click on the "Storage Settings..." link to specify MOLAP, HOLAP or ROLAP.

HTH,

- Steve

|||Cube and dimensions will initially be MOLAP when creating cubes and databases with Cube or Dimension wizards.

Newbie: what kind of "cube" is this?

1. In sql 2005 Analysis services how can I tell what kind of "cube" I'm viewing -- ROLAP, HOLAP, or MOLAP?

2. During cube creation where do I specify the type of "cube" I want to create

TIA,

Barkingdog

The cube wizard will not ask you for the storage settings that you want to use. After you have run the wizard and created the cube, go to the "Partitions" tab of the cube editor. You will then see information for your partitions. You can click on a partition and then click on the "Storage Settings..." link to specify MOLAP, HOLAP or ROLAP.

HTH,

- Steve

|||Cube and dimensions will initially be MOLAP when creating cubes and databases with Cube or Dimension wizards.

Newbie: please help with NS 2000 runtime error

We have a new big project coming, which will use Notification Services.

So, I bought a book: "Microsoft SQL Server 2000 Notification Services" by Shyam Pather and did all steps including installing NS, setting up the environment, and creating the first sample NS application (Chapter03). Every single step was successful, no errors. I am pretty sure I didn't miss anything.

All went well until I copied a sampla data file into the EventsWatchDirectory.

At this point, the file name almost immediately changes to EventData.xml.20060908-160948.370.err (digits are different at every attempt, but please note the extension).

I open this file using Notepad, and it is the exact copy of the original .xml file:

<eventData>
<StockPriceChange>
<StockSymbol>XYZ</StockSymbol>
<StockPrice>55.55</StockPrice>
</StockPriceChange>
<StockPriceChange>
<StockSymbol>PQS</StockSymbol>
<StockPrice>95.3</StockPrice>
</StockPriceChange>
<StockPriceChange>
<StockSymbol>JKL</StockSymbol>
<StockPrice>15.0</StockPrice>
</StockPriceChange>
</eventData>

The EventViewer has the following message:

<NotificationServicesEvent>

<Description>

The SQL XML Bulk Loader could not be initialized. Ensure that it is installed or repair its installation.

</Description>

<Context>

</Context>

<Description>

Retrieving the COM class factory for component with CLSID {1DB51355-B2CA-43CB-B045-1FAA42A724B2} failed due to the following error: 80040154.

</Description>

<Instance>Chapter03</Instance>

<ApplicationName>Stock</ApplicationName>

<Component>Event collection</Component>

<Thread>16</Thread>

</NotificationServicesEvent>

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

The link did not have info on this error.

My environment is as follows:

XP Pro SP2; SQL Server 2000 Dev SP4; SQL Server NS 2.0 SP1; SQLXML3.0 SP3.

Could someone kindly point me to the right direction as to what's wrong, please?

To my great regret, I found (by trial and error all over the past weekend) what was conflicting with the NS:

it's the .NET Framework 2.0.

As soon as I uninstalled it, the sample application started working as expected (that is, the file's extension in the Notifications directory changes to ".done").

...which means I won't be able to use VS 2005 and SQL Server 2005 on the same dev machine with NS 2000.

|||

Although I don't doubt what you observed, you should be able to run a SQLNS instance on a machine that has v2.0 of the .NET framework installed.

Try this post and see if it helps...

http://groups.google.com/group/microsoft.public.sqlserver.notificationsvcs/browse_frm/thread/aa48d73a8ed227a1/19cdd27c687ca70d?lnk=gst&q=framework+&rnum=2#19cdd27c687ca70d

HTH...

Joe

|||

Joe, thank you very much!

I followed your advice, and got it to work.

Newbie: please help with NS 2000 runtime error

We have a new big project coming, which will use Notification Services.

So, I bought a book: "Microsoft SQL Server 2000 Notification Services" by Shyam Pather and did all steps including installing NS, setting up the environment, and creating the first sample NS application (Chapter03). Every single step was successful, no errors. I am pretty sure I didn't miss anything.

All went well until I copied a sampla data file into the EventsWatchDirectory.

At this point, the file name almost immediately changes to EventData.xml.20060908-160948.370.err (digits are different at every attempt, but please note the extension).

I open this file using Notepad, and it is the exact copy of the original .xml file:

<eventData>
<StockPriceChange>
<StockSymbol>XYZ</StockSymbol>
<StockPrice>55.55</StockPrice>
</StockPriceChange>
<StockPriceChange>
<StockSymbol>PQS</StockSymbol>
<StockPrice>95.3</StockPrice>
</StockPriceChange>
<StockPriceChange>
<StockSymbol>JKL</StockSymbol>
<StockPrice>15.0</StockPrice>
</StockPriceChange>
</eventData>

The EventViewer has the following message:

<NotificationServicesEvent>

<Description>

The SQL XML Bulk Loader could not be initialized. Ensure that it is installed or repair its installation.

</Description>

<Context>

</Context>

<Description>

Retrieving the COM class factory for component with CLSID {1DB51355-B2CA-43CB-B045-1FAA42A724B2} failed due to the following error: 80040154.

</Description>

<Instance>Chapter03</Instance>

<ApplicationName>Stock</ApplicationName>

<Component>Event collection</Component>

<Thread>16</Thread>

</NotificationServicesEvent>

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

The link did not have info on this error.

My environment is as follows:

XP Pro SP2; SQL Server 2000 Dev SP4; SQL Server NS 2.0 SP1; SQLXML3.0 SP3.

Could someone kindly point me to the right direction as to what's wrong, please?

To my great regret, I found (by trial and error all over the past weekend) what was conflicting with the NS:

it's the .NET Framework 2.0.

As soon as I uninstalled it, the sample application started working as expected (that is, the file's extension in the Notifications directory changes to ".done").

...which means I won't be able to use VS 2005 and SQL Server 2005 on the same dev machine with NS 2000.

|||

Although I don't doubt what you observed, you should be able to run a SQLNS instance on a machine that has v2.0 of the .NET framework installed.

Try this post and see if it helps...

http://groups.google.com/group/microsoft.public.sqlserver.notificationsvcs/browse_frm/thread/aa48d73a8ed227a1/19cdd27c687ca70d?lnk=gst&q=framework+&rnum=2#19cdd27c687ca70d

HTH...

Joe

|||

Joe, thank you very much!

I followed your advice, and got it to work.

Newbie: Object name 'ProductSubCategory' is not valid.

Hi all,
I have just installed Reporting Services in a W2003 server (without VS.Net).
and SQL Server 2000.
I have run the Report Administrator, and after inserting my the windows
admin user and its password, looks like it works.
Then I load the example file Company Sales.rdl which is in the
Samples\Reports folder. looks like it loads perfectly.
But when I click on it in order to see the file, gives me that error:
Error while processing report(rsProcessingAborted). Query execution error
for Sales dataset (rsErrorExecutingCommand).
The object name 'ProductSubCategory' is not valid.
What am I doing wrong?
Any help/hint or whatever will be wellcome.
Thanks in advance,
Ibai Peña"Ibai Peña" <IbaiPea@.discussions.microsoft.com> wrote in message
news:5AB26ADF-387C-4588-AD49-0202DC75D34E@.microsoft.com...
<cut>
> Then I load the example file Company Sales.rdl which is in the
> Samples\Reports folder. looks like it loads perfectly.
> But when I click on it in order to see the file, gives me that error:
> Error while processing report(rsProcessingAborted). Query execution error
> for Sales dataset (rsErrorExecutingCommand).
> The object name 'ProductSubCategory' is not valid.
>
Have you created the Datasource yet? You need to create a data source for
the sample reports to run. The Books Online explains how to and what
settings to use.
Kaisa|||Thank you for your replay.
I was just to post that I have found that the datasource wasn´t defined.
What leads me to the next question:
Is is possible to set a default datasource for all reports?
Thanks,
Ibai Peña
"Kaisa M. Lindahl" wrote:
> "Ibai Peña" <IbaiPea@.discussions.microsoft.com> wrote in message
> news:5AB26ADF-387C-4588-AD49-0202DC75D34E@.microsoft.com...
> <cut>
> > Then I load the example file Company Sales.rdl which is in the
> > Samples\Reports folder. looks like it loads perfectly.
> >
> > But when I click on it in order to see the file, gives me that error:
> >
> > Error while processing report(rsProcessingAborted). Query execution error
> > for Sales dataset (rsErrorExecutingCommand).
> > The object name 'ProductSubCategory' is not valid.
> >
> Have you created the Datasource yet? You need to create a data source for
> the sample reports to run. The Books Online explains how to and what
> settings to use.
> Kaisa
>
>|||RSConfig.exe file. Sorry, sometimes it is better to spend some time before
asking.
Regards,
Ibai Peña
"Ibai Peña" wrote:
> Thank you for your replay.
> I was just to post that I have found that the datasource wasn´t defined.
> What leads me to the next question:
> Is is possible to set a default datasource for all reports?
> Thanks,
> Ibai Peña
> "Kaisa M. Lindahl" wrote:
> > "Ibai Peña" <IbaiPea@.discussions.microsoft.com> wrote in message
> > news:5AB26ADF-387C-4588-AD49-0202DC75D34E@.microsoft.com...
> > <cut>
> > > Then I load the example file Company Sales.rdl which is in the
> > > Samples\Reports folder. looks like it loads perfectly.
> > >
> > > But when I click on it in order to see the file, gives me that error:
> > >
> > > Error while processing report(rsProcessingAborted). Query execution error
> > > for Sales dataset (rsErrorExecutingCommand).
> > > The object name 'ProductSubCategory' is not valid.
> > >
> >
> > Have you created the Datasource yet? You need to create a data source for
> > the sample reports to run. The Books Online explains how to and what
> > settings to use.
> > Kaisa
> >
> >
> >