Oledbconnection Unspecified Error
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack system.data.oledb.oledbexception: unspecified error Overflow the company Business Learn more about hiring developers or posting ads with us
Unspecified Error While Opening Oledb Connection
Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community system.data.oledb.oledbexception unspecified error excel 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
System.data.oledb.oledbexception Unspecified Error Excel Upload
uploads an Excel .xls file to the file system, opens the file with an oledbconnection object 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 system.data.oledb.oledbexception unspecified error c# 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 the file and open it and the methods do work on my workstation and two web servers. Windows 2000 SP4 servers. c# debugging connection-string xls oledbconnection share|improve this question edited Nov 18 '15 at 16:11 pnuts 33.9k63870 asked Sep 18 '08 at 19:41 Mike Smith 19113 add a comment| 6 Answers 6 active oldest votes up vote 3 down vote While the permissions issue may be more common you can also encounter this error from Windows file system/Access Jet DB Engine connection limits, 64/255 I think. If you bust the 255 Access read/write concurrent connections or the 64(?) connection limit per process you can get this exact same error. At least
here for a quick overview of the site Help Center Detailed answers to any questions you might have
System.data.oledb.oledbexception (0x80004005)
Meta Discuss the workings and policies of this site About Us
Unspecified Error While Opening Excel Connection
Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with unspecified error while opening oledb connection in c# us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just http://stackoverflow.com/questions/96150/oledbconnection-open-generates-unspecified-error like you, helping each other. Join them; it only takes a minute: Sign up C#/ASP.NET Oledb - MS Excel read “Unspecified error” up vote 5 down vote favorite 4 We have a C#/ASP.NET (2.0) application running on IIS 6 on Windows Server 2003 Enterprise Edition. This application reads Excel files using OleDb, but there are instances http://stackoverflow.com/questions/472079/c-asp-net-oledb-ms-excel-read-unspecified-error when we get an "Unspecified Error" exception thrown from within the application. The file is stored in the temporary directory by our file upload code before opening. Since we have anonymous access enabled in IIS and since we also use impersonation in web.config, the folder C:\Windows\Temp\ has the proper permissions for the Internet Guest User Account (IUSR_[MachineName]) to be able to create, modify and delete files there. OleDb connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Windows\Temp\tmp123.tmp.xls; Extended Properties="Excel 8.0;HDR=Yes;IMEX=1;" [The "Data Source" attribute above would change for every file.] The stack trace of the exception is: System.Exception: FileParsingFailed ---> System.Data.OleDb.OleDbException: Unspecified error at 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() Workaround: So far, the only workaround we could come up with was to do an iisreset (we also have application pool recycling configured to happen once everyday in IIS, but it doesn't seem to help since the issue someti
360 games PC games https://support.microsoft.com/en-us/kb/825738 Windows games Windows phone games Entertainment All Entertainment https://talk.plesk.com/threads/system-data-oledb-oledbexception-unspecified-error.79135/ Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet unspecified error Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All unspecified error while Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
started by rahulpandit, Dec 23, 2007. rahulpandit Guest 0 I am using MS Access as Database in ASP.NET application and I am running the application on a Web Server using Plesk 8.2 with ASP.NET Version 2.0 But several times i recieve System.Data.OleDb.OleDbException: Unspecified error Error Type: Provider (0x80004005) Unspecified error This is an temporary error and is usually rectified when I restart the IIS, some times the error gets rectified automatically in few minutes But the question is how to solve this problem permenantly i am attaching a screen shot of the error Please guide and provide some solution Rahul Ideogram Technology Solutions (P) Ltd. http://www.ideogram.co.in Attached Files: rahul.gif File size: 63.4 KB Views: 33 rahulpandit, Dec 23, 2007 #1 avsokolov Guest 0 Read the following article: http://support.microsoft.com/kb/825738 it should help you to solve the problem avsokolov, Dec 23, 2007 #2 (You must log in or sign up to reply here.) Show Ignored Content Share This Page Tweet Loading... Log in with Facebook Log in with Twitter Log in with Google Your name or email address: Do you already have an account? No, create an account now. Yes, my password is: Forgot your password? Stay logged in Plesk Forum Home Forum > Older Products Discussion > Older Panel Software Versions > Plesk for Windows - 8.x and Older > Go to plesk.com | documentation | community | knowledge base | feature requests | devblog Follow us on Facebook Twitter community forums Home Forum Forum Quick Links Search Forum Recent Posts Members Members Quick Links Notable Members Current Visitors Recent Activity Badges Badges Quick Links Badges Menu Search Search titles only Posted by Member: Separate names with a comma. Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... Contact Us Hel