DataSource Controls :: Dbo Does Not Exist Or This Type Of Principal Can Not Be Impersonated
Apr 26, 2010
I have restored a database from the .bak file on live server.But it keeps creating error in log and I checked it through sql server 2005
management tool . I found the folloing error :"the activate proc[dbo].[procname] running on queue databasename.dbo. storedprocedurename output the following 'Cannot execute as the database prinicpal "dbo"
does not exist,this type of principal cannot be impersonated,or you do not have permission".
And the log file size is increasing with a great pace and I need to delete the log files mannualy as it reaches the size of 90gb in few days.
But if I restore the same .bak on my local system then it does not create the same error log.
View 1 Replies
Similar Messages:
Nov 12, 2010
I have a web site that is using windows authentication. 'Enable anonymous access' is unchecked. It works when I call it through Visual Studio but when I put the site on the server I get the following error:
Unable to cast object of type 'System.Security.Principal.GenericPrincipal' to type 'System.Web.Security.RolePrincipal'.
Here is the offending line:
System.Security.Principal.GenericPrincipal genericPrincipal = (System.Security.Principal.GenericPrincipal)HttpContext.Current.User;
View 3 Replies
May 19, 2010
I have this error "The given value of type String from the data source cannot be converted to type datetime of the specified target column." when I used sqlbulkcopy to do the transaction
Here is my code:
[code]....
View 3 Replies
Feb 17, 2010
I'm trying to get a value from a database and I'm getting an error, see code below:
[Code]....
I get and error when I'm trying to convert the value out of the stored procedure to the string SNAME. Error is as follows:
'Conversion from type 'DBNull' to type 'String' is not valid.'
and the stored procedure is as follows:
[Code]....
View 6 Replies
Jan 22, 2010
I get the error - Conversion from type 'DBNull' to type 'Integer' is not valid. - on the line.....
Dim newid As Integer = e.Command.Parameters("@latestRowId").Value.........in vb code behind.
I have the identical code for another page with the exception of the field names and it works fine. The only thing I did differently, as far as I know, is I copied the asp and code behind from the page that works into this page and manually changed the field and table names. I don't know what the problem is. Does anyone see any problems?
[Code]....
View 2 Replies
May 3, 2010
I have an Interface that has its concrete class defined via a factory. Because of this I found no way to use the Interface tpye directly in my LINQ quesry so I had to use the concrete class types to creat a generic list. The LINQ query works but after calling.ToList() on the LINQ query result I get a List(of MyConcreteClass), but I need a List(of IMyConcreteClass). I have tried everything I can find: .Cast, Ctype, implicit casting, etc. but I always get back one of the (2) messages (depending on if I attempt to cast)message:
"Unable to cast object of type 'System.Collections.Generic.List`1[MyConcreteClass]' to type 'System.Collections.Generic.IEnumerable`1[IMyConcreteClass]'."
...or
"Unable to cast object of type '<CastIterator>d__aa`1[IMyConcreteClass]' to type 'System.Collections.Generic.List`1[MyConcreteClass]'."
Here is the sample code:
[Code]....
View 2 Replies
Dec 22, 2010
I am making a website to store invoices so i can mail them to clients. So i got a table for clients, invoices and one with invoice products/services. When an invoice has no products/services added to them and it returns null i get the error "the null value cannot be assigned to a member with type System.Decimal which is a non-nullable value type."
I just started with linq. Before i always used mysql. Mostly i just had to call data from 1 table so forgive me if my linq query isn't really correct.
Dim invoices = From i In db.invoices _
Group Join p In db.products On i.id Equals p.invoiceId Into invoiceProducts = Group _
Select New With {i.client.naam, i.titel, (From iP In invoiceProducts Select iP.prijs).Sum}
i show the client's name, the title of the invoice and the total amount the clients will need to pay for products and services.
View 1 Replies
Jul 16, 2010
I get this error: Description: An error occurred during the compilation of a resource required to service this request. review the following specific error details and modify your source code appropriately. Compiler Error Message: CS0234: The type or namespace name 'Xml' does not exist in the namespace 'System' (are you missing an assembly reference?) Source Error:
[Code]....
Line 15: using System.Web.Services.Protocols;
Line 16: using System.ComponentModel;
Line 17: using System.Xml.Serialization;
Line 18:
Line 19:
Source File: c:WindowsMicrosoft.NETFrameworkv4.0.30319Temporary ASP.NET Files
oot4db438488b8d9090App_WebReferences.j5ljvr6f.0.cs
Line: 17
I have this in my web.config:
<compilation debug="true" strict="false" explicit="true" ><!--targetFramework="4.0"-->
<assemblies>
<clear />
<add assembly="System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
<add assembly="System.Web.Services, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
<add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
<add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
</assemblies>
</compilation>
<pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID">
[Code....]
View 7 Replies
Jan 3, 2011
I have a simple query
SELECT Number, CASE WHEN Num1 = @Num1 THEN 1 ELSE 0 END AS Occurences
FROM LotteryNumbersTX
The CLR type does not exist or you do not have permissionto access it
Num1 is a integer field. The parameter @Num1 is 01 or 02 etc
How do I correct this error?
If I replace @Num1 with 1 it works, no error!?
View 9 Replies
Apr 10, 2010
I created a PageLoad event, so when the page opens it fills all the fields from a DataSource control. However, the problem is that if the DataSource control is empty (the row does not exist yet) it gives me an error. How do I check that if DataSource Control has a row of data or not?
View 5 Replies
Apr 5, 2010
i am bulding something for myself in asp.net and SQL but am having a few problems. I will list them below and see what happens :)Please note that i have a lbl control permantly on my pages which is set in the master page, this is what displays my messages.example = message.text = "Please insert your name"1. I have a data table that calls a table with its values. its basicly 4 ddl's(day, month, date & year) select what date then search. Mon Mar 21 2010
SEARCH(btn)
" SqlExeption was unhandled by user code "
this is basicly because the table doesnt exist. How do i tell asp to return a message if the the table doesnt exist in sql server.
View 3 Replies
Mar 6, 2010
[Code]...
View 12 Replies
Sep 2, 2010
I am inserting a record and want to set the value for a foreign key but I am getting an error - I initally thought that it would insert it if it didn't exist but I must be wrong and want to confirm that I need to check all values and make a record for them if they don't exist... here's what I am trying to do - does his make sense?
var newAllPart = new Part();
newAllPart.PartNumber = partNumber;
newAllPart.Manufacturer.ManufacturerName = partManufacturer; // error here if the Manufacturer doesn't exists already
newAllPart.PartType.PartTypeName = partType;
newAllPart.Category.CategoryName = partCategory;
newAllPart.DateCreated = DateTime.Now;
newAllPart.UserCreated = userCreated;
newAllPart.Package.PackageName = partPackage;
newAllPart.Statuse.StatusName = partStatus;
localDB.Parts.InsertOnSubmit(newAllPart);
localDB.SubmitChanges();
View 2 Replies
May 8, 2010
I am new to LINQ, but learning Quickly. I get this error "Error 1 The name 'DetailsView1' does not exist in the current context C:UsersUserdocumentsvisual studio 2010WebSitesDursoftHRAGeneral.aspx.cs 40 9 C:...DursoftHR" for the code behind listed below:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class AGeneral : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
viewCompanyInfo();
}.......
"The name 'DetailsView1' does not exist in the current context" is the error I get.
View 5 Replies
May 11, 2010
I get the above error using this code. What am I missing?
[Code]....
View 4 Replies
Jan 2, 2010
I want to do paging the API Membership without using the datacontrols, but I get this error "Unable to cast object of type '<TakeIterator>d__3a`1[System.Char]' to type 'System.Collections.IList'." when I do this,
[code]....
View 1 Replies
May 28, 2010
I am trying to write a table output from SQL database to a gridview/ Data List through an Object Data Source. I am a new starter and your help will be useful.
public List<Staff> GetStaff()
cmd.CommandType =
SqlConnection con =
new
SqlConnection(connectionstring);SqlCommand cmd =
new
[code]...
View 4 Replies
Jan 26, 2010
On our company we have a intranet site which uses ASP classic to authenticate users before accesing the site. This site was working before but suddenly i throws an error which limits the users in accessing the intranet site. I made a debugger page in order to know the error of the application and it showed me this error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. On my local machine the page is accessible on my (IIS server) the connectionstring in the web server and in my localhost are the same. I just can't figure out what's causing this problem.
View 2 Replies
Feb 3, 2011
I'm trying to implement a custom principal and custom identity in a .NET MVC website. I've created a custom principal class which inherits from IPrincipal and a custom identity which inherits from IIdentity.
When a user logs in I set both Thread.CurrentPrincipal and HttpContext.Current.User to my custom principal. When I view either through the debugger the values are set with all the properties.
However once the request is complete and I try and request any other pages both Thread.CurrentPrincipal and HttpContext.Current.User are of type System.Security.Principal.GenericPrincipal and not my custom principal.
Do I need to do anything "extra" to get my custom principal out of the thread or HttpContext?
View 1 Replies
Mar 2, 2011
Does anyone know how to add a generic principal to the HTTPContext from the Forms Authentication Ticket?
View 1 Replies
Apr 19, 2010
i get the following error when trying to compile my asp.net site after updating the project from vs2008 to vs2010The type or namespace name 'Syndication' does not exist in the namespace 'System.ServiceModel' (are you missing an assembly reference?)I have the asp.net site targeting 3.5 framework (as it did in vs2008)I also added a reference to System.ServiceModel.Web
View 3 Replies
Oct 22, 2010
I'm using MonoDevelop on Mac OS X Snow Leopard to develop an ASP.NET MVC Application. I have tested it on Visual Studio 2008 on Windows 7 and it worked fine, but when compiling it on MonoDevelop it throws the error: The type or namespace name 'Objects' does not exist in the namespace 'System.Data' under this line: public partial class MoviesDBEntities : global::System.Data.Objects.ObjectContext
View 1 Replies
Jan 23, 2010
I use vs2008 and my MVC 1.0 and 2.0 Projects were working perfectly but all of a sudden i have an error on trying to compile all of them;
The error is of the form;
Error 1 The type or namespace name 'Controllers' does not exist in the namespace 'XXX' (are you missing an assembly reference?)
Error 3 The type or namespace name 'Models' does not exist in the namespace 'XXX' (are you missing an assembly reference?)
Error 4 The type or namespace name 'AccountController' could not be found (are you missing a using directive or an assembly reference?)
Error 5 The type or namespace name 'IFormsAuthenticationService' could not be found (are you missing a using directive or an assembly reference?)
Error 6 The type or namespace name 'IMembershipService' could not be found (are you missing a using directive or an assembly reference?)
These errors seem to come from the HomeControllerTest and the AccountControllerTest.
note that i recently installed Azure Tools using the Web Installer..Dunno if that could be the cause or problem.
View 4 Replies
Sep 9, 2010
I have a ASMX web service. When I access it from a client the ASMX get compiled but I get this error:
Looking at csc.exe command line from the error detail the System.Windows.Forms asseembly is not referenced.
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. review the following specific error details and modify your source code appropriately.
Compiler Error Message: CS0234: The type or namespace name 'Windows' does not exist in the namespace 'System' (are you missing an assembly reference?)
Source Error:
Line 3: using System.ComponentModel;
Line 4: using System.Drawing;
Line 5: using System.Windows.Forms;
Line 6: using System.Xml;
Line 7: using Idp.Core.Configuration;
View 1 Replies
Sep 2, 2010
I uploaded my website to the server, and I have there a working with wcf - it should be fw 3.5I saw that fw 3.5 is installed on the server and also we have re fw 3.0 sp1.I run my website : www.qenglishcenter.comand I'm getting an error : The type or namespace name 'Linq' does not exist in the namespace 'System' (are you missing an assembly reference?)shouldn't System.linq be already existed ?
View 2 Replies
