DataSource Controls :: Cannot Find The Object 'AspNet_SqlCachePollingStoredProcedure'?

Jan 22, 2010

I have a Windows 2003 test server hosting an asp.net 2.0 application and Sql Server 2005 running as Sql Server 2000(80).During a recent a security review we decided that it wasn't such a hot idea to use sql authentication with an sysadm user as the database user for the asp.net application. Having done a bit of reading (http://msdn.microsoft.com/en-us/library/ms998258.aspx#pagguidelines0001_dataaccess) I decided to use a lower privilege database user account and windows authentication.Starting from scratch I created a new custom service account (http://msdn.microsoft.com/en-us/library/ms998297.aspx) and assigned this to the process identity for the application pool.I then created a new database login and user for this account. I added the db_datareader and db_datawriter roles to this user and I also granted EXECUTE permissions for user defined stored procedure and functions. However when I started the application I got this error 'User does not have permission to perform this action.Cannot find the object 'AspNet_SqlCachePollingStoredProcedure', because it does not exist or you do not have permission.' - after a quick hunt I found thishttp://forums.asp.net/p/1487216/3493362.aspx and followed the advice herehttp://msdn.microsoft.com/en-us/library/system.web.caching.sqlcachedependencyadmin.aspx and granted the user CREATE TABLE and CREATE PROCEDURE permissions.Still no joy - after digging around and looking at sql profiler I found what I believe to be the offending piece of sql:

/* Create notification table */
...sql
/* Create polling SP */
..more sql
..finally
GRANT EXECUTE ON dbo.AspNet_SqlCachePollingStoredProcedure to aspnet_ChangeNotification_ReceiveNotificationsOnlyAccess

My understanding is that to issue 'GRANT EXECUTE' the user must db_owner or db_secadmin. Indeed it all works fine if I give the service account user login the db_owner role.This sql is caused by: SqlCacheDependencyAdmin.EnableNotifications(ConnectionString), this is called once and once only by the application start event.Is there a work around for this? I would like to use the lower privilege account as per best practice but this issue is making it tricky.

View 4 Replies


Similar Messages:

DataSource Controls :: VS 2005 - Can't Find The 'Advanced Properties' For The XSD File - Can't Find The 'Custom Tool'?

Jan 29, 2010

I am trying to create strogly typed datasets for my project. When I right click on the xsd file that I need to generate a strongly typed dataset for I can't find the 'Advanced' properties as described in the below article (almost half way down)[URL]As I do not see the Advanced properties option I can't find the 'Custom Tool' property/option to set its value to 'MSDatasetGenerator'. Do I have to install some kind of patch on my VS 2005?

View 5 Replies

DataSource Controls :: Simple Login Form - Object Reference Not Set To An Instance Of An Object?

Apr 20, 2010

im tryin to create a login form.

and am receiving the following error:

Object reference not set to an instance of an object

[Code]....

and heres my aspx page:

[Code]....

Stored procedure:

[Code]....

View 2 Replies

DataSource Controls :: Get Child Properties Using Parent Object Error / Cannot Access A Disposed Object

Feb 17, 2010

On DBML I have two entities as Parent, Child. I am trying to assign Child class properites in a Parent.

[code]....

I am getting the following Error:

Cannot access a disposed object.

Object name: 'DataContext accessed after Dispose.'.

View 2 Replies

DataSource Controls :: Getting Error - Object Reference Not Set To An Instance Of An Object?

Jul 27, 2010

[code]....

i'm having trouble because when it has no return value i get the error

Object reference not set to an instance of an object.

View 10 Replies

DataSource Controls :: Error - Object Reference Not Set To An Instance Of An Object

Jan 24, 2010

im using a sqldatasource and i want it to query a table chosen from a dropdownlist, so i wrote the following in the .cs file

[Code]....

im recieving this error msg: Object reference not set to an instance of an object (pointing to the line containing the select command)

i don't know what's the problem, i tired a hard-coded statement and it worked fine!

View 2 Replies

DataSource Controls :: Object Reference Not Set To An Instance Of An Object?

May 26, 2010

I am adding rows to table and setting value row/cell value, but for datetime field it is giving me error

Object reference not set to an instance of an object.

Initially I am adding a column to table as

table.Columns.Add("Upload Date",
typeof(DateTime));

Then I assigning value to row as

row["UploadDate"] = result["Execution Date"].ToString();

As I have I also null or empty value in the "Execution Date" field .

View 3 Replies

DataSource Controls :: When Add A Object Datasource To Page, It Bring Only Common Layer Classes?

Mar 10, 2011

i have problem white Object datasource. i have a multi-tier Application that include common layer ,DAL Layer,business logic and persantation layerwhen i add a object datasource to my page, it bring me only common layer classes . but i want use bisuiness layer classes what do i do ?

View 1 Replies

DataSource Controls :: Access Property Of Object As Session Variable As Declarative Datasource Parameter Value

Oct 27, 2010

I am storing a custom "Organisation" object as a session variable. One of the properties of the Organisation object is "OrganisationID" (integer). I have a DataSource that requires a parameter value to run, and I want to use a SessionParameter to populate this. In a previous version, I stored the OrganisationID directly as a session variable. In that case, I could easily access it like this:

[Code]....

However, how do I now access the OrganisationID property of an "Organisation" type session variable (called "Organisation")? I have tried this, which does not seem to work: <asp:SessionParameter Name="OrganisationID" SessionField="Organisation.OrganisationID" Type="Int32" />

View 2 Replies

Forms Data Controls :: How To Find Specific Nested Object Type In Gridview

Sep 6, 2010

I have a gridview with a nested placeholder in each rows. I nested some checkboxes in each placeholders in each rows dynamically, so their ServerIDs are not the same (I dont want to use nested gridview). at the end in a button event I want to count checked checkboxes in gridview while I can not use findcontrol() method in each rows to find checkboxes due to their different ServerIDs.

View 3 Replies

DataSource Controls :: Inserting Data With Object Datasource?

Aug 9, 2010

This is the first time I have been working on databases and I am trying to insert data using an object datasource but no data is being inserted and no exception is thrown. I'm not sure where I am going to wrong. I am putting user data into session variables and inserting the session variables into the dataacess class layer and have a try and exception but nothing being thrown. Any help would be really appreciated because I don't know even where to start looking with this or how I can get the error to be thrown. Please see some of my code below to give an idea of what I am doing

Object Access Class
public void InsertCarPolicyHolder(PolicyHolderClass ph, CarInsuranceOptions options)
{

[code]...

View 2 Replies

DataSource Controls :: Assigning Method To Object Datasource?

Jan 17, 2010

I have a Public Sub listed in a class file that I am using to store Select, Update,etc...methods for an Object Datasource. When I attempt to configure the datasource, the Class appears as a business object, but the sub within the class is not available for method selection. (It does not appear in drop down list in wizard.)

The sub exists, so where is a good place for me to start looking for a fix? I have part of the class file listed below:

[Code]....

View 7 Replies

DataSource Controls :: Is It Possible To Use A Property Of An Object Instance Property For Object Data Source

May 3, 2010

Traditionally with an Object Data Source, the wired up class will have its public properties available for binding (i.e. Gridview columns, etc.) which works well. But what if one of my wired up business objects has a property that is an object itself; can I drill down to a property on that object property and still use it?

So in additiona to the traditional:MyBusniessObject.OrderID...I want to use:MyBusniessObject.Customer.NameID
Your 1st response might be to just wire up the 'Customer' class, but I need properties both on 'MyBusinessObject'and 'Customer'. I do not think this can be done, as the ODS will not display properties on an object instance property. I have tried manually typing in the drilled down value as well, but that wasn't a success either.

View 4 Replies

DataSource Controls :: Getting The Old "Object Reference Not Set To An Instance Of An Object" Error ?

Aug 25, 2010

I'm getting the old "Object reference not set to an instance of an object" error on this code:

nonqueryCommand.Parameters.Add("@comment", SqlDbType.VarChar, 500)
nonqueryCommand.Parameters("@comment").Value = CType(FormView1.Row.FindControl("CommentsLabel"), TextBox).Text
"CommentsLabel" is a textbox, despite it's name (and I've tried the CTYPE ot Label too).

View 3 Replies

DataSource Controls :: Using Web Service With Object Datasource?

Mar 5, 2010

have an object datasource that calls a web method to retrieve a set of data. That web service resides on another remote server with Windows Authentication enforced. How do I pass in the credentials required for the authentication from my web application? My code is as follows:

[Code]....

View 7 Replies

DataSource Controls :: Find The Five Last Records?

Feb 19, 2010

How can I find the 5 last records ?

CREATE PROC [dbo].[SP_NEWS_SELECT]
(
@NB_NEWS int,
@ID_NEWS int,
@DT_PUBLICATION datetime
)
AS
SELECT TOP @NB_NEWS *
FROM [REP_CLI].[S_ETATS].[T_NEWS]
ORDER BY [DT_PUBLICATION] ASC

This does not work

View 4 Replies

DataSource Controls :: Could Not Find Stored Procedure?

Jun 17, 2010

I created a database on SQL Server 2005 developer edition with MS SQL Server Mangement Studio Express. Now I created code that accessess a stored procedure named 'pS_TableData'. However I have one problem the code raises an exception "Could not find stored procedure 'pS_TableData 'Letters''."the code looks like this:

[Code]....

Note I am using (for now) the same connection that I used to create my database so in essence my web site is the administrator. I tried a simple SELECT from a table with the same connection and it raised no exceptions!When I run EXECUTE ps_TableData 'Letters' in SSMS it has no . I also tried EXECUTE ps_TableData 'Letters' as the command paramated for SqlCommand but it had the same effect

View 1 Replies

DataSource Controls :: Find The Biggest Two Numbers Out Of Three

Mar 30, 2010

I have to write a stored procedure to get the biggest two values out of three in three different columns in the same table.

I have a table , for instance,

total marks1 - column1 ( eg values - 1000)

total marks2 - column 2 (eg values - 500)

total marks3 - column 3 (eg values - 800)

i have to get (return the value) 1000 and 800.

View 6 Replies

DataSource Controls :: Best Way To Find Out If Record Exists?

May 14, 2010

best Way to find out if record exists?

[Code]....


View 2 Replies

DataSource Controls :: Find Particular Date Is Sunday Or Not?

Jun 12, 2010

how to find particular date is Sunday or not? in sql 2000

View 3 Replies

DataSource Controls :: Could Not Find Any Links About Data?

Feb 10, 2010

I think that type of data types is really smart.and hope some can help me with something more.I could not find any links about it.Right now, I can only make a getdata (), which shows all data:

[code]...

View 1 Replies

DataSource Controls :: Find A Table Row With 2 Columns?

Apr 2, 2010

I have created a table in my SQL database that has a primary column (Title) and another column named Callsign. How can I access the table row that has a certain title and Callsign using C# in a web page event handler?

View 7 Replies

DataSource Controls :: Where To Find The Northwind Database And Add To Sqldatabase

Jan 12, 2010

i need the northwind databse. i dont have it in the database where i can find it and who to add it to my database in sql server so can i c it in the combo box off the database

View 1 Replies

DataSource Controls :: How To Find Stored Procedure From Which This Is Called

May 19, 2010

There is one sp(1) which is called from another sp(2)How can I find from which sp it is called.

View 2 Replies

DataSource Controls :: Sql Server Compact Edition - How To Find / Use It

Jul 9, 2010

I have come accross a scott's blog today;

http://weblogs.asp.net/scottgu/archive/2010/06/30/new-embedded-database-support-with-asp-net.aspx

what is exactly Sql server compact edition? it says that I do not need a sql server to store my databases if I use that in my bin folder? so I can use my mdf databases in app_data folder. is that true?

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved