Item vs. System Level Security

I am trying to deploy RS in a corporate environment. I have folders set up at
different organizational levels. I would like to allow certain users only
within those organization levels to create linked reports and deploy them
within their respective organizational levels. I thought that by granting
those users full item-level security they could achieve this. Unfortunately,
when I tried this it did not work.
1. Which task allows users to view report properties and create linked
reports? I'm assuming this is a system-level task.
2. Is there any way that I can assign this task to a role which restricts
the user to only exercising that authority only within a certain folder. I
obviously don't want to give the user the ability to create linked reports
site wide but only in the respective organizational folder.
3. Is there anyway to combine system-level and item-level tasks into a
single role or to customize security configurations?
Any help would be greatly appreciated.
Thanks,
TedCreating linked reports is an item level task. In report manager go to the
site settings tab and then the 'Configure item-level roledefinitions' link.
From here you can create roles as you see fit. One of the tasks you can
assign is 'Create Linked reports'. You can not combine system and
item-level task, but then again you shouldn't need to.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ted" <Ted@.discussions.microsoft.com> wrote in message
news:287C4AA6-65EC-411A-9E93-4C1CDA463AE2@.microsoft.com...
> I am trying to deploy RS in a corporate environment. I have folders set up
at
> different organizational levels. I would like to allow certain users only
> within those organization levels to create linked reports and deploy them
> within their respective organizational levels. I thought that by granting
> those users full item-level security they could achieve this.
Unfortunately,
> when I tried this it did not work.
> 1. Which task allows users to view report properties and create linked
> reports? I'm assuming this is a system-level task.
> 2. Is there any way that I can assign this task to a role which restricts
> the user to only exercising that authority only within a certain folder. I
> obviously don't want to give the user the ability to create linked reports
> site wide but only in the respective organizational folder.
> 3. Is there anyway to combine system-level and item-level tasks into a
> single role or to customize security configurations?
> Any help would be greatly appreciated.
> Thanks,
> Ted

Item not linked to dataset, and "table1" issue

Hi--

I have a report project in VS (2003). I have a report in that project that was working properly. I copied objects from that report to a new one and created a new dataset for the new report (under it's Data tab). Though both datasets (for each of the reports) seem healthy, i.e., they produce data when run, I am now experiencing the following problems:

1. In both reports, the datasets seem to be unlinked, somehow. I know this by right clicking on a field of the report, going to expressions, then selecting the Fields node. Instead of listing fields, as used to be the case, it now says "Report item not linked to a dataset."

2. If I attempt to preview either of the reports, I get an error that reads, "The table 'table1' refers to an invalid dataset name 'MedMgmt.' MedMgmt is the dataset name of the first report. I changed it to another name, but I still get the same message.

I have clicked and right-clicked everywhere and have not found a way to re-link the dataset to the report. Why Reporting Services can't figure out that the dataset in the report's Data tab is the dataset to link to is a point of deep annoyance, but whatever... If anyone can please help me solve these problems, I would be very grateful! Thank you!

I have exactly the same problem. Only way around it (for me) so far has been to build the report all over and let the wizard link it, then copy the elements 1 by 1 from original... real pain...

There's GOT to be a better way?

|||

I think i know what it is. What is this object you are looking to link? If its a table, List, or Matrix : Right click the object (make sure the whole object is selected and click properties. if properties slides out Scroll down to "Dataset Name", there should be a drop down which all the datasets in your report. Select the one you are grabbing you attributes from. The reason your getting that error is, the object is linked to dataset names from your other report (since you copied them over). So you need to change the dataset names for each object. This is why it shows the name of your dataset from your other report.

IF the properties box opens up for the table/matrix/list , then you should see (3 textboxes down) "Dataset Name". if its empty or has something in it...i would click the dropdown anyways, and make sure the right dataset it selected.

I hope this helps!

Item not linked to dataset, and "table1" issue

Hi--

I have a report project in VS (2003). I have a report in that project that was working properly. I copied objects from that report to a new one and created a new dataset for the new report (under it's Data tab). Though both datasets (for each of the reports) seem healthy, i.e., they produce data when run, I am now experiencing the following problems:

1. In both reports, the datasets seem to be unlinked, somehow. I know this by right clicking on a field of the report, going to expressions, then selecting the Fields node. Instead of listing fields, as used to be the case, it now says "Report item not linked to a dataset."

2. If I attempt to preview either of the reports, I get an error that reads, "The table 'table1' refers to an invalid dataset name 'MedMgmt.' MedMgmt is the dataset name of the first report. I changed it to another name, but I still get the same message.

I have clicked and right-clicked everywhere and have not found a way to re-link the dataset to the report. Why Reporting Services can't figure out that the dataset in the report's Data tab is the dataset to link to is a point of deep annoyance, but whatever... If anyone can please help me solve these problems, I would be very grateful! Thank you!

I have exactly the same problem. Only way around it (for me) so far has been to build the report all over and let the wizard link it, then copy the elements 1 by 1 from original... real pain...

There's GOT to be a better way?

|||

I think i know what it is. What is this object you are looking to link? If its a table, List, or Matrix : Right click the object (make sure the whole object is selected and click properties. if properties slides out Scroll down to "Dataset Name", there should be a drop down which all the datasets in your report. Select the one you are grabbing you attributes from. The reason your getting that error is, the object is linked to dataset names from your other report (since you copied them over). So you need to change the dataset names for each object. This is why it shows the name of your dataset from your other report.

IF the properties box opens up for the table/matrix/list , then you should see (3 textboxes down) "Dataset Name". if its empty or has something in it...i would click the dropdown anyways, and make sure the right dataset it selected.

I hope this helps!

item master and office stock details (was "Query Problem")

Hi,

I am having problem in getting result out of two table, one table is Item Mater which stores global items for all offices and other is stock file which stores office wise stock items as follows:

ITEM MASTER
-----
NCODE ITEMNAME
1 A
2 B
3 C
4 D
5 E

STOCKDETAILS
-----------
NCODE ITEMCODE OFFICEID
1 1 1
2 2 1
3 3 1
4 1 2
5 2 2
6 4 2
7 5 3

I want office wise stock details which inludes items found in stock file and remaining itmes from item master. example for office 1

--------------
FOR OFFICE - 1
--------------
ITEMCODE ITEMNAME OFFICEID
--------------
1 A 1
2 B 1
3 C 1
4 D NULL
5 E NULL

i want a single view from which i can select data like i shown above, any kind of help is highly appriciated, what i tried is , i created union of both tables and tried to get data out of union view but result is not up to desire.

Thanks in advanceWelcome to the Forum.
Check this...

SELECT dbo.[ITEM MASTER].NCODE,
BB.ITEMNAME,
BB.OFFICEID
FROM dbo.[ITEM MASTER]
INNER JOIN
(SELECT dbo.[ITEM MASTER].ITEMNAME,
AA.OFFICEID
FROM
dbo.[ITEM MASTER] LEFT JOIN
(SELECT * FROM STOCKDETAILS
WHERE dbo.STOCKDETAILS.OFFICEID = '1') AA
ON AA.NCODE = [ITEM MASTER].NCODE) BB ON
dbo.[ITEM MASTER].ITEMNAME = BB.ITEMNAME|||select M.ncode as itemcode
, M.itemname
, S.officeid
from ItemMaster as M
left outer
join StockDetails as S
on S.itemcode = M.ncode
and S.officeid = 1|||Hi Rudra !

how to get such all result in view and then i will query for officeid to get my desired output.|||Hi r937 !

I am getting result through posting by Rudra but i want all data in view and then i want to query my view for office wise to get desired output. How to acheive this ?|||Hi r937 !

I am getting result through posting by Rudra but i want all data in view and then i want to query my view for office wise to get desired output. How to acheive this ?
Why don't you use stored proc and pass parameter using OFFICEID ? I think that would be a better way to deal with your problem.But I am not sure what your requirement is...|||select M.ncode as itemcode
, M.itemname
, S.officeid
from ItemMaster as M
left outer
join StockDetails as S
on S.itemcode = M.ncode
and S.officeid = 1

hmm,always ahead...;)|||Hi Rudra !
i want to gether itemmaster and stockdetails data in to one view and then i want to query the view through office id, is this possible ?

if i use SP then how to return o/p rows of query from SP?
if i return Table with data from SP as o/p paramater then it wil be catechble in .net or dataset ?

my first preference is to gether all data in view then query the view for office,
what if we union itemmaster and office wise stock file and then queryfor office ?|||Hi Rudra !
i want to gether itemmaster and stockdetails data in to one view and then i want to query the view through office id, is this possible ?

if i use SP then how to return o/p rows of query from SP?
if i return Table with data from SP as o/p paramater then it wil be catechble in .net or dataset ?

my first preference is to gether all data in view then query the view for office,
what if we union itemmaster and office wise stock file and then queryfor office ?

I suggest you to use stored proc,its always good to use stored proc
in your case.Just write this...

CREATE PROCEDURE dbo.StockView(
@.officeid VARCHAR(20)

AS

--Use mine or Rudy's one
--this is mine
SELECT dbo.[ITEM MASTER].NCODE,
BB.ITEMNAME,
BB.OFFICEID
FROM dbo.[ITEM MASTER]
INNER JOIN
(SELECT dbo.[ITEM MASTER].ITEMNAME,
AA.OFFICEID
FROM
dbo.[ITEM MASTER] LEFT JOIN
(SELECT * FROM STOCKDETAILS
WHERE dbo.STOCKDETAILS.OFFICEID = @.officeid) AA
ON AA.NCODE = [ITEM MASTER].NCODE) BB ON
dbo.[ITEM MASTER].ITEMNAME = BB.ITEMNAME

--OR use Rudy's one

select M.ncode as itemcode
, M.itemname
, S.officeid
from ItemMaster as M
left outer
join StockDetails as S
on S.itemcode = M.ncode
and S.officeid = @.officeid

Go

And check BOL to use Stored proc in dataset .Its very easy man and better to use in many respect
Hope this will help you.sql

Item Description in Shorthand

Hi,
If you browse to Amazon and drill down through categories until a pagedlisting appears, you will see in each item of the listing that thedescription rendered as Book Description, is a cutdown version of thefull description, with a ... and "Read More" hyperlink. How isthis achieved programatically? I dont know if thre is an efficient wayin SQL Server to do this, or whether it would be easier to have aShortHand field and a Description field, both of which are teh fulldescription when shown in the Details page, but the ShortHand is thefield rendered in listings. This seems like a simplistic solutionand I am thinking there may be programmatic means of doing the same -has anybody got any experience in this area?
Thanks!
jr.
Well, its just a substring from the complete description. In SQL you could simply return this from your stored procedure - lets say the first 100 chars with SubString and append the '...' to it. The same can be done from code. Both uses the SubString function.|||Hi Sonu,
I have used this as my technique, but Amazon is neat because they havewhole words at the end. Just using 1-100 means I could getincomplete words back, which doesnt look as professional. I agreethis is a simple solution though.
jr.
|||Does it matter if they have whole words at the end or not? In either case, you would append the "...", right?
Doesnt that look good?
"This is some test and I want to ment..."|||Hi,
Yeh it does to me - I think it looks better and cleaner. I didthe first job of cutting down the text in the DB, and then used C#before rendering to substring to the last space, which works nicely.
Thanks,
jr.

Item counts...

I have a group w/ two fields, such as:

INCIDENT TYPE; NUMBER OF EVENTS
Burglary; 1
Burglary; 1
Burglary; 1
Arrest; 1
Citation Issued; 1

However, I need it to do the following:

INCIDENT TYPE; NUMBER OF EVENTS
Burglary; 3
Arrest; 1
Citation Issued; 1

I have set the INCIDENT TYPE fields to 'suppress on duplications'; however, how do I get the field in the NUMBER OF EVENTS field to successfully "count" the same type of events in the INCIDENT TYPE fields if I do this?

Sorry, I haven't used Crystal Reports (now using version 11) since my VB6.0 days (been awhile).I'm no guru myself, but try this:

Suppress the detail line and make a group footer with two fields, field1 (incident type from your example), and a formula field that is Sum(field2, field1). If you didn't have a group on field1, make one.

Good Luck,
Larry

Item count in collapsed region

Initially I have collapsed regions on my report with drill-down possibility.
How can I show the number of items that are directly beneath that region?
Something like:
+ Beverages (4)
+ Cigarettes (6)
...I didnt try this, but maybe something like:
=Fields!beverages.Value & " (" &
count(Fields!sub-beverages.Value,"Group-sub-beverages") & ")"
"Marcus Phass" wrote:
> Initially I have collapsed regions on my report with drill-down possibility.
> How can I show the number of items that are directly beneath that region?
> Something like:
> + Beverages (4)
> + Cigarettes (6)
> ...
>
>|||It always says that "the scope parameter must be set to name of containing
group..." error. If I omit the scope, it counts the total number of items
below "Beverages", but I want to display only the number of items in the
level directly below (not all levels below). Countrows gives the same error.
"NI" <NI@.discussions.microsoft.com> wrote in message
news:699E0462-CDC7-4FFA-8C61-2C631672A5F4@.microsoft.com...
> I didnt try this, but maybe something like:
> =Fields!beverages.Value & " (" &
> count(Fields!sub-beverages.Value,"Group-sub-beverages") & ")"
>
> "Marcus Phass" wrote:
> > Initially I have collapsed regions on my report with drill-down
possibility.
> > How can I show the number of items that are directly beneath that
region?
> >
> > Something like:
> >
> > + Beverages (4)
> > + Cigarettes (6)
> > ...
> >
> >
> >|||Try CountDistinct. It worked I tried.
= Fields!Beverages.Value & "(" & CountDistinct(Fields!sub-beverages.Value) &
")"
"Marcus Phass" wrote:
> It always says that "the scope parameter must be set to name of containing
> group..." error. If I omit the scope, it counts the total number of items
> below "Beverages", but I want to display only the number of items in the
> level directly below (not all levels below). Countrows gives the same error.
>
> "NI" <NI@.discussions.microsoft.com> wrote in message
> news:699E0462-CDC7-4FFA-8C61-2C631672A5F4@.microsoft.com...
> > I didnt try this, but maybe something like:
> >
> > =Fields!beverages.Value & " (" &
> > count(Fields!sub-beverages.Value,"Group-sub-beverages") & ")"
> >
> >
> >
> > "Marcus Phass" wrote:
> >
> > > Initially I have collapsed regions on my report with drill-down
> possibility.
> > > How can I show the number of items that are directly beneath that
> region?
> > >
> > > Something like:
> > >
> > > + Beverages (4)
> > > + Cigarettes (6)
> > > ...
> > >
> > >
> > >
>
>|||Yep, it works! Thanks!
"NI" <NI@.discussions.microsoft.com> wrote in message
news:23233751-33C6-4AB8-9905-66251FBD7640@.microsoft.com...
> Try CountDistinct. It worked I tried.
> = Fields!Beverages.Value & "(" & CountDistinct(Fields!sub-beverages.Value)
&
> ")"
> "Marcus Phass" wrote:
> > It always says that "the scope parameter must be set to name of
containing
> > group..." error. If I omit the scope, it counts the total number of
items
> > below "Beverages", but I want to display only the number of items in the
> > level directly below (not all levels below). Countrows gives the same
error.
> >
> >
> > "NI" <NI@.discussions.microsoft.com> wrote in message
> > news:699E0462-CDC7-4FFA-8C61-2C631672A5F4@.microsoft.com...
> > > I didnt try this, but maybe something like:
> > >
> > > =Fields!beverages.Value & " (" &
> > > count(Fields!sub-beverages.Value,"Group-sub-beverages") & ")"
> > >
> > >
> > >
> > > "Marcus Phass" wrote:
> > >
> > > > Initially I have collapsed regions on my report with drill-down
> > possibility.
> > > > How can I show the number of items that are directly beneath that
> > region?
> > > >
> > > > Something like:
> > > >
> > > > + Beverages (4)
> > > > + Cigarettes (6)
> > > > ...
> > > >
> > > >
> > > >
> >
> >
> >

Item count for Full-text Catalog is zero

After creating several full-text indexes from tables to a Full-text
Catalog, I can see the names of the tables for those indexes. However,
when double-clicking the Full-text Catalog, the the item count was still
zero.
I am sure the Microsoft Search Service started and there was a Full-Text
Search in EM's Support Services folder. My SQL Server databses is the
back-end database for a front-end SharePoint Services server.
Is something wrong with the configuration on my SQL Server databases, or
the SharePoint Services server?
TIA,
Jeffrey
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Jeffrey,
Most likely as this is a FAQ in this newsgroup... Review all of the
following KB articles:
317746 (Q317746) PRB: SQL Server Full-Text Search Does Not Populate Catalogs
http://support.microsoft.com/default...b;en-us;317746
277549 (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
Services]
http://support.microsoft.com/default...B;EN-US;277549
837367 How to turn on full-text search (FTS) in WSS (SharePoint) on a
Windows SBS 2003-based computer
http://support.microsoft.com/?kbid=837367
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Jeffrey Wang" <cjeffwang@.gmail.com> wrote in message
news:#ABhKdSIFHA.1528@.TK2MSFTNGP09.phx.gbl...
> After creating several full-text indexes from tables to a Full-text
> Catalog, I can see the names of the tables for those indexes. However,
> when double-clicking the Full-text Catalog, the the item count was still
> zero.
> I am sure the Microsoft Search Service started and there was a Full-Text
> Search in EM's Support Services folder. My SQL Server databses is the
> back-end database for a front-end SharePoint Services server.
> Is something wrong with the configuration on my SQL Server databases, or
> the SharePoint Services server?
> TIA,
> Jeffrey
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

Item Count 0; Gathering hung?

Douglas,
Basically, the FT Catalog is not being properly populated for some reason
and we need to discover that reason, correct it and then you should be good
to go... There may be a post-SP3a issue here, depending upon if this server
was upgraded from SQL Server 7.0 or this SQL 2000 server is a named instance
with a SQL Server 7.0 default installation. Checkout KB article - "814035
(Q814035) FIX: A Full-Text Population Fails After You Apply SQL Server 2000
Service Pack 3" at:
http://support.microsoft.com/default...b;en-us;814035
When you changed the account under which SQL is running, did you do this
via the Enterprise Manager's server security tab? If not, then you must
"re-change" the changed the account under which SQL is running via the EM.
Checkout KB article - "277549 (Q277549) PRB: Unable to Build Full-Text
Catalog After You Modify MSSQLServer Logon Account Through [NT4.0) Control
Panel [or Win2K Component Services]" at
http://support.microsoft.com/default...B;EN-US;277549
Regards,
John
"Douglas Steen" <dug@.pobox.com> wrote in message
news:#lzgWozFEHA.3372@.TK2MSFTNGP09.phx.gbl...
> I use a simple test server with SQL and MSSearch for development work and
up
> until recently it was handling full-text searching just fine. I updated
the
> box to Win2K3, and still no problems. But then I modified noise.eng, and
in
> the process rebuilt the catalog. Now whenever I try to populate the
catalog
> I am permanently stuck "in progress" with an item count of 0, a catalog
size
> of 1 MB, and a unique key count of 1.
> Here's what I've tried:
> - I have tried full & incemental populations, starting, stopping services
&
> rebooting
> - I've waited for hours for any sort of progress beyond item count 0, but
to
> no avail
> - the Application event log shows nothing but the standard start/stop
> messages. If I stop the population myself, I do get warnings, but they're
> of the "user stopped process" variety
> - similarly, the gather logs show only start/stop and "user stopped
process"
> messages
> - I've installed SQL Server SP3a
> - I've changed the account under which SQL is running, moving it to a
system
> account and then back to the original account, starting & stopping SQL and
> MSSearch as described in
> http://support.microsoft.com/default...b;en-us;295051 (I've done
> this twice now)
> I'm at the end of the line here; any help would be appreciated.
> Sincerely,
> Douglas R. Steen
>
John -
Thanks for the response.
Unfortunately, we're using SQL 2000, so I'm not sure this applies. And
yes, I did use Enterprise Manager to change the account, so I don't think
that's it either.
Here's some more information that might affect what happened:
The change that was made was to update the noise.eng file with a noise.eng
file that had been manually edited & emailed around for a while. Is it
possible that permissions on that file are confusing the service? I tried
setting correct permissions by clicking the checkbox on the security tab for
the containing folder that says "Apply security settings to all children",
so now the permissions are the same for all files in the Config folder, but
still no luck.
Also, we're now seeing this same problem on another sql server installation.
We have two identical databases (one is a test database) on that sql server:
in one case, we didn't delete and rebuild the catalog and it's working fine;
in the other, we did have to delete and rebuild the catalog and it's broken.
And it was the case on both that server and my own that we had not rebuilt
the catalog after upgrading to Win2003 (from Win2000) until just yesterday,
when this problem started occurring.
Unfortunately, the new sql server installation & database where we're
seeing this problem is our production server/database, so the problem has
moved to urgent priority. Any more thoughts you might have would be
welcome; and thanks for the help you've given already.
Douglas R. Steen
"John Kane" <jt-kane@.comcast.net> wrote in message
news:OEXzSy0FEHA.2208@.TK2MSFTNGP09.phx.gbl...
> Douglas,
> Basically, the FT Catalog is not being properly populated for some reason
> and we need to discover that reason, correct it and then you should be
good
> to go... There may be a post-SP3a issue here, depending upon if this
server
> was upgraded from SQL Server 7.0 or this SQL 2000 server is a named
instance
> with a SQL Server 7.0 default installation. Checkout KB article - "814035
> (Q814035) FIX: A Full-Text Population Fails After You Apply SQL Server
2000
> Service Pack 3" at:
> http://support.microsoft.com/default...b;en-us;814035
> When you changed the account under which SQL is running, did you do this
> via the Enterprise Manager's server security tab? If not, then you must
> "re-change" the changed the account under which SQL is running via the
EM.
> Checkout KB article - "277549 (Q277549) PRB: Unable to Build Full-Text
> Catalog After You Modify MSSQLServer Logon Account Through [NT4.0) Control
> Panel [or Win2K Component Services]" at
> http://support.microsoft.com/default...B;EN-US;277549
> Regards,
> John
>
> "Douglas Steen" <dug@.pobox.com> wrote in message
> news:#lzgWozFEHA.3372@.TK2MSFTNGP09.phx.gbl...
and
> up
> the
and
> in
> catalog
> size
services
> &
but
> to
they're
> process"
> system
and
done
>
|||You're welcome, Douglas,
First of all, both KB articles apply to SQL Server 2000 as well. Secondly,
the noise.* files are just text files and there should not be any permission
issues. Although, changing the file permissions and "clicking the checkbox
on the security tab for the containing folder that says "Apply security
settings to all children" has me a bit concerned. On another server where
SQL Server 2000 is installed, could you confirm the modified folder has the
same permissions (and owner) as the un-modified folder?
I now *believe* that there might be some issue caused by the upgrading to
Win2003 from Win2000 as this upgrade also affects the MSSearch service as
well as the OS-supplied wordbreaker dll's. If so, then the complexity of
this, has just gone up a notch or two..
Were any other changes made to the SQL Servers? Specifically, any changes to
BUILTIN\Administrator ? If so, what were those changes?
As for your production server/database, you might want to consider calling
Microsoft PSS SQL Server support as and get their help in resolving this
more urgent issue as newsgroups are not the best place to get
production-level support.
Regards,
John
"Douglas Steen" <dug@.pobox.com> wrote in message
news:efN7P$0FEHA.4084@.TK2MSFTNGP11.phx.gbl...
> John -
> Thanks for the response.
> Unfortunately, we're using SQL 2000, so I'm not sure this applies. And
> yes, I did use Enterprise Manager to change the account, so I don't think
> that's it either.
> Here's some more information that might affect what happened:
> The change that was made was to update the noise.eng file with a noise.eng
> file that had been manually edited & emailed around for a while. Is it
> possible that permissions on that file are confusing the service? I tried
> setting correct permissions by clicking the checkbox on the security tab
for
> the containing folder that says "Apply security settings to all children",
> so now the permissions are the same for all files in the Config folder,
but
> still no luck.
> Also, we're now seeing this same problem on another sql server
installation.
> We have two identical databases (one is a test database) on that sql
server:
> in one case, we didn't delete and rebuild the catalog and it's working
fine;
> in the other, we did have to delete and rebuild the catalog and it's
broken.
> And it was the case on both that server and my own that we had not rebuilt
> the catalog after upgrading to Win2003 (from Win2000) until just
yesterday,
> when this problem started occurring.
> Unfortunately, the new sql server installation & database where we're
> seeing this problem is our production server/database, so the problem has
> moved to urgent priority. Any more thoughts you might have would be
> welcome; and thanks for the help you've given already.
> Douglas R. Steen
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:OEXzSy0FEHA.2208@.TK2MSFTNGP09.phx.gbl...
reason
> good
> server
> instance
"814035
> 2000
this
> EM.
Control
> and
updated
> and
catalog
> services
> but
> they're
> and
> done
>
|||John -
As it turns out, our production issues were solved by using QueryAnalyzer
instead of the Enterprise Manager to do the creation/population/etc.
Unfortunately, I wasn't so lucky: it hasn't worked for me. No idea why one
would work and not the other, but it is feeling like it has something to do
with the Win2K3 upgrade and permissions.
This is just a dev machine, so if all else fails (though I'd hate to do
it), I can reinstall everything (starting with SQL server). I'm going to
let it stew for a while & see if any other ideas come up. In the meantime,
I've gotta get back to work. Thanks for your efforts.
"John Kane" <jt-kane@.comcast.net> wrote in message
news:eVo7QR1FEHA.3568@.tk2msftngp13.phx.gbl...
> You're welcome, Douglas,
> First of all, both KB articles apply to SQL Server 2000 as well. Secondly,
> the noise.* files are just text files and there should not be any
permission
> issues. Although, changing the file permissions and "clicking the checkbox
> on the security tab for the containing folder that says "Apply security
> settings to all children" has me a bit concerned. On another server where
> SQL Server 2000 is installed, could you confirm the modified folder has
the
> same permissions (and owner) as the un-modified folder?
> I now *believe* that there might be some issue caused by the upgrading to
> Win2003 from Win2000 as this upgrade also affects the MSSearch service as
> well as the OS-supplied wordbreaker dll's. If so, then the complexity of
> this, has just gone up a notch or two..
> Were any other changes made to the SQL Servers? Specifically, any changes
to
> BUILTIN\Administrator ? If so, what were those changes?
> As for your production server/database, you might want to consider calling
> Microsoft PSS SQL Server support as and get their help in resolving this
> more urgent issue as newsgroups are not the best place to get
> production-level support.
> Regards,
> John
>
>
> "Douglas Steen" <dug@.pobox.com> wrote in message
> news:efN7P$0FEHA.4084@.TK2MSFTNGP11.phx.gbl...
And
think
noise.eng
tried
> for
children",
> but
> installation.
> server:
> fine;
> broken.
rebuilt
> yesterday,
has
> reason
> "814035
> this
must
the
> Control
work
> updated
noise.eng,
> catalog
0,
start/stop
a
SQL
(I've
>
|||Douglas,
If you can manage the FT Catalog via the system stored procs, then this is
NOT a Win2003 upgrade issue, but a specific SQL Server FTS issue.
If your production and dev machines are configured similarly, and you can
manage the FT Catalog via the system stored proc, but not via the EM, you
might be using "local accounts" and checkout the following KB article -
"270671 (Q270671) PRB: Full Text Search Menus Are Not Enabled for Local
Windows NT Accounts" at:
http://support.microsoft.com/default...;en-us;q270671
Regards,
John
"Douglas Steen" <dug@.pobox.com> wrote in message
news:OYTvY01FEHA.2732@.tk2msftngp13.phx.gbl...
> John -
> As it turns out, our production issues were solved by using
QueryAnalyzer
> instead of the Enterprise Manager to do the creation/population/etc.
> Unfortunately, I wasn't so lucky: it hasn't worked for me. No idea why
one
> would work and not the other, but it is feeling like it has something to
do
> with the Win2K3 upgrade and permissions.
> This is just a dev machine, so if all else fails (though I'd hate to do
> it), I can reinstall everything (starting with SQL server). I'm going to
> let it stew for a while & see if any other ideas come up. In the
meantime,
> I've gotta get back to work. Thanks for your efforts.
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:eVo7QR1FEHA.3568@.tk2msftngp13.phx.gbl...
Secondly,
> permission
checkbox
where
> the
to
as
changes
> to
calling
> And
> think
> noise.eng
it
> tried
tab
> children",
folder,
> rebuilt
we're
> has
be
Server
> must
> the
Full-Text
> work
> noise.eng,
the
> 0,
> start/stop
stopped
to
> a
> SQL
> (I've
>
sql

Item cannot be found in the collection corresponding to the requested name or ordinal.

I am retrieving the data using the below sql statement in VB 6.0 & it giving me the Error
Item cannot be found in the collection corresponding to the requested name or ordinal.
I have tried to run the same sql statement it ran fine
I am using a recordset to retrive a data & it looks like recorset do have a data init but when I am assigning it to a temp variable it ging me th eabove stated error
strsql = "select sum(isnull(Amount,0)) from Payments where Name ='" & Name & "'"
objRS.CursorLocation = enmCursorLocation
Call objRS.Open(vntSPNameOrSQLOrCmdObject, vntConn, enmCursorType, enmLockType, lngOptions) If (Not objRS Is Nothing) Then
If (Not objRS Is Nothing) Then
dblAmount = CDbl(Trim$(objRS.Fields.Item("Amount").Value))
end if
Please advice
Thanks
Your column is no longer called amount, since you are performing
aggregations against it. You can change your SQL statement to provide an
alias, e.g.
SELECT Amount = SUM(...) FROM ...
Or you can use a different, more meaningful name, e.g.
SELECT SumAmount = SUM(...) FROM ...
Or in your code you can refer to the ordinal position of the column, instead
of the name.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"SAMAY" <anonymous@.discussions.microsoft.com> wrote in message
news:6C1456DD-FBC0-4ADC-8B99-F7BFA10821F1@.microsoft.com...
> I am retrieving the data using the below sql statement in VB 6.0 & it
giving me the Error
> Item cannot be found in the collection corresponding to the requested name
or ordinal.
> I have tried to run the same sql statement it ran fine
> I am using a recordset to retrive a data & it looks like recorset do have
a data init but when I am assigning it to a temp variable it ging me th
eabove stated error
> strsql = "select sum(isnull(Amount,0)) from Payments where Name ='" & Name
& "'"
> objRS.CursorLocation = enmCursorLocation
> Call objRS.Open(vntSPNameOrSQLOrCmdObject, vntConn, enmCursorType,
enmLockType, lngOptions) If (Not objRS Is Nothing) Then
> If (Not objRS Is Nothing) Then
> dblAmount = CDbl(Trim$(objRS.Fields.Item("Amount").Value))
> end if
> Please advice
> Thanks
|||Thanks for your help
it worked
Thanks again

Item cannot be found in the collection corresponding to the requested name or ordinal.

I am retrieving the data using the below sql statement in VB 6.0 & it giving
me the Error
Item cannot be found in the collection corresponding to the requested name o
r ordinal.
I have tried to run the same sql statement it ran fine
I am using a recordset to retrive a data & it looks like recorset do have a
data init but when I am assigning it to a temp variable it ging me th eabov
e stated error
strsql = "select sum(isnull(Amount,0)) from Payments where Name ='" & Name &
"'"
objRS.CursorLocation = enmCursorLocation
Call objRS.Open(vntSPNameOrSQLOrCmdObject, vntConn, enmCursorType, enmLockTy
pe, lngOptions) If (Not objRS Is Nothing) Then
If (Not objRS Is Nothing) Then
dblAmount = CDbl(Trim$(objRS.Fields.Item("Amount").Value))
end if
Please advice
ThanksYour column is no longer called amount, since you are performing
aggregations against it. You can change your SQL statement to provide an
alias, e.g.
SELECT Amount = SUM(...) FROM ...
Or you can use a different, more meaningful name, e.g.
SELECT SumAmount = SUM(...) FROM ...
Or in your code you can refer to the ordinal position of the column, instead
of the name.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"SAMAY" <anonymous@.discussions.microsoft.com> wrote in message
news:6C1456DD-FBC0-4ADC-8B99-F7BFA10821F1@.microsoft.com...
> I am retrieving the data using the below sql statement in VB 6.0 & it
giving me the Error
> Item cannot be found in the collection corresponding to the requested name
or ordinal.
> I have tried to run the same sql statement it ran fine
> I am using a recordset to retrive a data & it looks like recorset do have
a data init but when I am assigning it to a temp variable it ging me th
eabove stated error
> strsql = "select sum(isnull(Amount,0)) from Payments where Name ='" & Name
& "'"
> objRS.CursorLocation = enmCursorLocation
> Call objRS.Open(vntSPNameOrSQLOrCmdObject, vntConn, enmCursorType,
enmLockType, lngOptions) If (Not objRS Is Nothing) Then
> If (Not objRS Is Nothing) Then
> dblAmount = CDbl(Trim$(objRS.Fields.Item("Amount").Value))
> end if
> Please advice
> Thanks|||Thanks for your help
it worked
Thanks again

Item

I want read
dr[2] = SqlDataReader dr1.item("lastmane");
from database
but I have error expected
I don't while

SqlDataReader dr1 = cmd.ExecuteReader();
dr1.Read();

dr[2] = SqlDataReader dr1.item("lastmane");Hello, what is dr ? and what is the error generated ?

regards|||dr [2] this is array
and I haw error
An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: CS1002: ; expected

And my code is

<%@. Import Namespace="System.Data.OleDb" %
<script language="vb" runat="server">
dim rek(100)
dim strImie as string = "adam"
public sub Page_Load(sender As Object, e As EventArgs)
dim dbconn,sql,dbcomm,dbread,dbconn1,dbcomm1
'dim a=New ArrayList
dim a=New SortedList
dim mycountries=New ArrayList
dim x
dim b(10)
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & server.mappath("baza/Blok.mdb"))
dbconn.Open()
'dim objCmd as new OleDbDataAdapter _
'("SELECT Login,IloscZlecen FROM Blokowanie where Blok=True", objConn)
sql="SELECT Login,IloscZlecen FROM Blokowanie where Blok=True"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
if Not Page.IsPostBack then
x=0
Do While dbread.Read()
'Authors.Items.Add(New ListItem(dbread.Item("Login") + " " + Cstr(dbread.Item("IloscZlecen"))))
'Authors.Items.Add(New ListItem(dbread.Item("Login") + " " + (Cstr(x))))
a.add((x),(dbread.Item("Login")))
'a.TrimToSize()
 'a.Sort()
 x=x+1
 loop
 rb.DataSource=a
 rb.DataValueField="Key"
 rb.DataTextField="Value"
 rb.DataBind()
'rb.DataSource=a
 'rb.DataBind()
end if
If Page.IsPostBack Then
x=0
'Czytanie z bazy kolumn
Do While dbread.Read()
rek(x)=dbread.item("IloscZlecen")
x=x+1
loop
 'SelectedAuthor.Text=(Authors.SelectedItem.Text)
'response.write(rb.SelectedItem.Value)
response.write(rek(rb.SelectedItem.Value))
response.write(rek(rb.SelectedItem.Value)+1)
 End if
dbread.Close()
dbconn.Close()
end sub
Public Sub button1(Sender As Object, e As EventArgs)
text.InnerHtml="You clicked the button"
response.write("Adam")
response.write(rek(rb.SelectedItem.Value))
End Sub
</script
<html>
<body>
<form runat="server">
 <asp:label id="Status" runat="server"/
 <asp:RadioButtonList id="rb" runat="server" AutoPostBack="True" />
 Wybrany serwisanta: <asp:label id="SelectedAuthor" runat="server" /><p></p
</asp:RadioButtonList>
<button id="b1" OnServerClick="button1" runat="server"
</button>
<p id="text" runat="server" />
 </form>
 </body>
 </html>