Oledbconnection Unspecified Error Asp Net
Contents |
here for a quick overview of the site Help Center Detailed answers to oledbexception (0x80004005): unspecified error any questions you might have Meta Discuss the workings and system.data.oledb.oledbexception unspecified error c# policies of this site About Us Learn more about Stack Overflow the company Business Learn
System.data.oledb.oledbexception Unspecified Error Excel Upload
more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow
System.data.oledb.oledbexception (0x80004005)
Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up System.Data.OleDb.OleDbException: Unspecified error up vote 2 down vote favorite I'm Totally new in ASP.net and currently working on a CRM application. This project uses .mdb files system.data.oledb.oledbexception (0x80004005): unrecognized database format as backend but I am getting the following runtime error: 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.Data.OleDb.OleDbException: Unspecified error Stack Trace: [OleDbException (0x80004005): Unspecified error] EmployeeManager.isUser(String strUID, String strPswd) in d:\hosting\nitindia\App_Code\EmployeeManager.vb:481 Employees.BtnSubmit_Click(Object sender, EventArgs e) in d:\hosting\nitindia\Employees.aspx.vb:35 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565 The above error occurs only when we upload these pages & test online. When running on localhost the error is not being raised. What is the cause of this issue, and solution? asp.net ms-access oledbexception share|improve this question edited Apr 13 '11 at 11:26 Grant Thomas 33.2k55792 asked Apr 13 '11 at 11:23 Amol K 1112 add a comment| 2 Answers 2 active oldest vote
here for a quick overview of the site Help Center Detailed answers to any questions
System.data.oledb.oledbexception In C#
you might have Meta Discuss the workings and policies of system.data.oledb.oledbexception (0x80040e14) this site About Us Learn more about Stack Overflow the company Business Learn more about hiring unspecified error while opening oledb connection developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is http://stackoverflow.com/questions/5648362/system-data-oledb-oledbexception-unspecified-error a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up OLEDBConnection.Open() generates 'Unspecified error' up vote 2 down vote favorite 1 I have an application that uploads an Excel .xls file to the file system, opens the file with an oledbconnection object http://stackoverflow.com/questions/96150/oledbconnection-open-generates-unspecified-error using the .open() method on the object instance and then stores the data in a database. The upload and writing of the file to the file system works fine but I get an error when trying to open the file on our production server only. The application works fine on two other servers (development and testing servers). The following code generates an 'Unspecified Error' in the Exception.Message. Quote: System.Data.OleDb.OleDbConnection x = new System.Data.OleDb.OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + location + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'"); try { x.Open(); } catch (Exception exp) { string errorEmailBody = " OpenExcelSpreadSheet() in Utilities.cs. " + exp.Message; Utilities.SendErrorEmail(errorEmailBody); } :End Quote The server's c:\\temp and c:\Documents and Settings\\aspnet\local settings\temp folder both give \aspnet full control. I believe that there is some kind of permissions issue but can't seem to find any difference between the permissions on the noted folders and the folder/directory where the Excel file is uploaded. The same location is used to save
ASP.NET Community Standup Forums Help Home/ASP.NET Forums/Data Access/Access Databases and AccessDataSource Control/[solved] System.Data.OleDb.OleDbException: Unspecified error [solved] System.Data.OleDb.OleDbException: https://forums.asp.net/t/1877790.aspx?+solved+System+Data+OleDb+OleDbException+Unspecified+error Unspecified error [Answered]RSS 20 replies Last post Feb 15, 2013 08:25 AM by barmajiat ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply barmajiat None 0 Points 8 Posts [solved] System.Data.OleDb.OleDbException: Unspecified error Jan 24, 2013 05:54 PM|barmajiat|LINK I'm having unspecified error the same problem, did anyone find a solution? Thanks. Reply decker dong... All-Star 94122 Points 18125 Posts Re: [solved] System.Data.OleDb.OleDbException: Unspecified error Jan 25, 2013 10:17 PM|decker dong - msft|LINK barmajiat I'm having the same problem, did anyone find a solution? Thanks. Hi, Your description is too generic……So what codes have you system.data.oledb.oledbexception unspecified error written? At which statement the error is thrown out? Reply barmajiat None 0 Points 8 Posts Re: [solved] System.Data.OleDb.OleDbException: Unspecified error Jan 28, 2013 01:55 PM|barmajiat|LINK Dear Dong, Here is my problem, I have an Access2010 database split into FE&BE. BE is hosted on the server in a folder on drive E. Selected users have the FE on their PC to access the BE and do normal activities like inserting, updating and reporting. A web application done using ASP.net access the backend database for public users through the LAN. Everything works fine, but sometimes for unkown reasons I get the error shown below, however, the FE does not get effect by this error. If I don't do anything for 5 to 10 minutes, the web appliction somehow works ok and the error disappears. To do a quick fix, I openIIS and disable then enable windows authentication option and then the problem is solved right away.