Does anyone here can explain me why I got this message Exception HRESULT : 0x80070008 (Not enough storage is available to process this command )? When I used to make lower version database from SQL2005 to SQL2K. First for lower version database process runs smoothly using Database Publishing Wizard, all process completed but when execute script the result of published database from SQL2005 in database SQL2K, the exception is occured.
How that happened ? Is database from SQL2005 has maximum capacity that in database SQL2K can't handle it or other things ?
Is there any solution so that I can get that database used in SQL2K ?
My web application some times gives error 'The handle is invalid. (Exception from HRESULT: 0x80070006 (E_HANDLE))' on server. I never comes on production server. Then I just upload the bin folder again on server and it starts running fine. I don't know what is the actual reason behind this.
Some experts suggested Min pool size =1, I applied that but no luck.
I am following this link: http://msdn.microsoft.com/en-us/library/aa701256(office.11).aspx to research on Excel project.
Everything works fine during development. When I publish to local computer IIS, I cannot open the excel file. The error is:
Could not load file or assembly 'DiagramOrder, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Failed to grant permission to execute. (Exception from HRESULT: 0x80131418)
I think it is related to Security Configuration and found this link: http://msdn.microsoft.com/en-us/library/zdc263t0(VS.80).aspx. I use step
To grant full trust to an assembly or folder on your local computer and also To grant full trust to an assembly or folder on a network computer or mapped drive.
I also refer to http://msdn.microsoft.com/en-us/library/9w6bd8f1(VS.80).aspx to add Msosec.dll to have Full Trust.
After all the settings, I do restart computer. All the steps taken just cannot resolve the problem.
I am not try using caspol utility because I think it should same as what I did using UI. Correct me if I'm wrong.
Notes: - Using ASP .NET Framework v2.0.50727 (.NET Framework 3.5 actually) - IIS v5.1
I am trying to Query a remote Oracle database from Windows Server(production environment) through a .net app. I keep getting this exception. I have Oracle XE client installed on the system. I tried to install Oracle 64 bit connectors but the jvm won't allow me to do so. Exception: System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
In my application I am accessing my DB using simple stored procedure..but My code got exception....while I debug the code I have seen that the code is executed successfully and while the whole try block has been executed then the code call the exception but more ridiculously without any kind of error..here is my code
I get a dataset from the OleDbDataAdapter for a query.I need to modify some the contents in the datatable.The first column is a date field which repeats. I want to delete the duplicates so that it looks like a group by column.I tried the following
1) Trying to modify the dataset looping through it. I get an error that dataset is read only
2) Cloned the dataset and tried to modify that rows. I get an error Column 'Entered_Date' is read only
I am reading records from ms-access 2003 and inserting into MySql Database daily. Sometimes I am getting "System.Data.OleDb.OleDbException: System resource exceeded" unhandled exception with dilalog box. When I click continue,it is working fine. But why that error message coming regularly.
A :{ id, selfId, name,} where selfId is a foreign key refered to Table A itself.
I generated the Entity automatically like this:
A :{ string id; A self; string name,} when i update the entity in gridview Edit/Update CommandField
i got the exception:
Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. Source Error:
[Code]....
Stack Trace:
[Code]....
I guess maybe this is caused by:
A is to be updated, and when the EntityDataSource construct the new A, the reference "self" is invalid at that moment. I do not want to modify my DB structure and do not want to lose the self reference, The event EntityDataSource_Updating is not triggered while the exception hit. so i can not access my entity at any time. Maybe the worst idea is deal the whole Update Procedure myself. However, is there any better workaround?
I am writing queries with CONVERT function. I have more than 200 columns in query. I am processing each row and write it to file.I need to log all errors occured during process. I need to capture column which is causing exception (Arithmetic overflow error converting numeric to data type varchar.) and log it in other file and send to administrator.
string connectionstring = WebConfigurationManager.ConnectionStrings["AdventureWorks"].ConnectionString; SqlConnection con = new SqlConnection(connectionstring); DataSet ds = new DataSet(); DataRelation dr = new DataRelation("show", ds.Tables["HumanResources.Employee"].Columns["EmployeeID"], ds.Tables["HumanResources.EmployeeAddress"].Columns["EmployeeID"],false); ds.Relations.Add(dr); foreach (DataRow row1 in ds.Tables["HumanResources.Employee"].Rows) { Response.Write("customertitle:" + row1["Title"].ToString()); foreach (DataRow row2 in row1.GetChildRows(dr)) { Response.Write("customer add" + row2["ModifiedDate"].ToString()); } }
Object reference not set to an instance of an object. 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.NullReferenceException: Object reference not set to an instance of an object. Source Error:
[Code]....
Line 31: Line 32: DataSet ds = new DataSet();Line 33: DataRelation dr = new DataRelation("show", ds.Tables["HumanResources.Employee"].Columns["EmployeeID"], ds.Tables["HumanResources.EmployeeAddress"].Columns["EmployeeID"],false);Line 34: //ds.Tables["HumanResources.Employee"].ParentRelations.Add(dr);Line 35: ds.Relations.Add(dr); Source File: d:databaseDataset showing selected field of 2 tables.aspx.cs Line: 33 Stack Trace:
[Code]....
[NullReferenceException: Object reference not set to an instance of an object.] dataset__with_two_tables.Page_Load(Object sender, EventArgs e) in d:databaseDataset showing selected field of 2 tables.aspx.cs:33 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436
I am developing one web application using MS Access database using oledb connection.Previously i checked the same application is works well in the same machine.Now Today i checked they provide "Unspecified Error". And also Provide the following Exception:
System.Data.OleDb.OleDbException: Unspecified errorat System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at clsOledbClass.opencon() in c:inetpubwwwrootcheckNPCApp_CodeclsOledbClass.cs:line 64
I am using the following connection string for connecting database:
I've been trying to set a STS project in my solution following these steps on Channel 9. Right after hitting "Finish", I get an exception saying: The system cannot find the file specified. (Exception from HRESULT: 0x80070002). After installing, uninstalling, rebooting, and so on, I still get the error.
My OS is Windows 7 Enterprise x64, both Visual Studio 2010 and Visual Web Developer 2010 Express are installed in my machine, the WIF SDK 4, the runtime 6.1 and the Identity Training Kit from January 2011.
I am working on a 3-tier asp.net application. Currently I'm stuck up in a situation where I need to handle a specific type of exception (User Defined) in DAL and Show alert to the user if that exception occurs in DAL.
I tried following things:
1) I raised that exception from the DAL and catch it in BLL and throw a new BLL exception to for that DAL exception and finally catch it in the UI layer to show the alert to the user. I've successfully implement this in my project. But there are some issues in this approach. First of all I feel this is not right way to do this as it may lead to performance related issues. Secondly, the application contains more than 500 pages and classes. so I need to attach additional catch block in every method to catch the BLL exception. which is the last option i'd like to take.
2) in second approach I logged the the DAL exception into a text file. but problem in this approach is that how could the UI layer know that exception has occurred and show the alert to the user. Is there any event in asp.net where i could handle all this activities?
my question is what is the best approach to handle this type of situation? Will Exception handling block help me in this?
I've tried reading many articles on this but i couldn't get an answer for my question? I might not be using right keywords for my search.
In ASP.NET,How can i know the Specific details about an exception (like What kind of Exception it is (FileNotFound /Arithmentc etc..) )from a General Exception class object.
3. Data Access Layer to do the dealing with the database.
Now i have a Contacts page from where i can add a new contact to the database.So to add a New Contact i fill in all the required details and then call a Add Method (residing in the BLL) from the page, which in turn call a Add Method residing in the DAL.this method in the DAL returns the Current Identity of the record which is then return back to the BLL method and finally delivered on the page.this is fine. but what if a get an exception how do i handle it properly because the method in DAL has a return type of int and i dont want to throw another error!! coz other wise i will have to write try catch in almost all the methods.
//something like this public int AddMethod(ContactClass contactObj) { int result = 0;[code]...
rather i want to show the user a user-friendly message which they can easily understand and in the mean while i will send a mail to myself documenting the Error that just occurred.how can i implement my custom exception classes.
