Home > Unspecified Error > Unspecified Error In C#.net

Unspecified Error In C#.net

Ensure to select the correct platform 32 vs 64 Connection string = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=fileLocation;Extended Properties="Excel 12.0 Xml;HDR=Yes;IMEX=1" In the web configuration file turn off Impersonation  In the connection string Try doing what Jessica posted, and I am hoping it should work. Level? please help me. http://crimsonskysoftware.com/unspecified-error/unspecified-error-sql.html

Is Certificate validation done completely local? The impersonation issue in particular is where I was stuck. Won't solve this problem, but it should prevent much, much more serious ones in the future. 2 solutions Top Rated Most Recent Rate this: Please Sign up or sign in Thanks, Max Let Me Google That For You!

But when I upload a large file(71 rows and above)the error shows. Reply gdurmus None 0 Points 1 Post Re: System.Data.OleDb.OleDbException: Unspecified error Nov 01, 2005 05:02 AM|gdurmus|LINK i think the point here is that the asp.net user are not able to create Rajendra Dhakal replied to Restore SQL Server text dat...

  • Reply photoshoper Member 588 Points 280 Posts Re: unspecified error!!!!!
  • I'm not using impersonation, soI've tried granting full permissions to the temp folder for the local ASPNET account, even though it wasn't necessary before for this to work.
  • Please review the stack trace for more information about the error and where it originated in the code.
  • c# debugging connection-string xls oledbconnection share|improve this question edited Nov 18 '15 at 16:11 pnuts 34k63870 asked Sep 18 '08 at 19:41 Mike Smith 19113 add a comment| 6 Answers 6
  • I wrapped my call to the OleDb provider with the delegate below, which overrides the impersonation setting and runs the code under the identity of the application pool.
  • Save, and then close the Web.config file. 4.
  • Save it to the database when no errors occur When I upload a small file(less than 70 rows) the error is never thrown.
  • This is the full error message: Exception Details: System.Data.OleDb.OleDbException: Unspecified error.
  • My program logic is like this: 1.

d. And DbDataReader to read the rows. Thanks for your post. share|improve this answer answered Jul 18 '11 at 6:47 Steve Morgan 10.7k22942 add a comment| up vote 1 down vote OleDbConnection is a disposable resource.

Read each row 3. However, it is showing up more and more often now. My account is an administrative one and i did check the .mdb file. Click OK two times, and then close the Internet Information Services dialog box.

And how about your .mdb file: 64-bit or 32-bit? Create a new Microsoft Visual C# .NET or a new Microsoft Visual Basic .NET ASP.NET Web Application. I have an application in a ftp webserver in asp.net 1.1 and C#. However, the code seems to work in principle.

Girish Edited by Girish Jambagi Tuesday, July 02, 2013 2:40 PM error change Tuesday, July 02, 2013 2:40 PM Reply | Quote 0 Sign in to vote I am using a Could anyone help me to fix this 'Unspecific error'. Print some JSON Die Liebe höret nimmer auf Enable Wireless on Fresh Debian Build How to fix a bent lens mount hook? Leave a Reply Cancel reply Enter your comment here...

http://support.microsoft.com/kb/825738 Good luck.... this content It works like magic. OriginalGriff 15-Jul-11 4:22am You didn't offend...but you shouldn't do it like that anyway: look up SQL Injection Attack and then use Parametrized queries instead. I got a few hits just by googling "Unspecified Error".

Is it because of reconnecting in OleDb too many times? Windows 2000 SP4 servers. Contact Us Privacy Policy Terms & Conditions About Us ©2016 C# Corner. http://crimsonskysoftware.com/unspecified-error/unspecified-error-in-ie6.html share|improve this answer answered May 7 '13 at 16:43 GoatBreeder 1,08321940 add a comment| up vote -1 down vote I've gotten that error over the permissions thing, but it looks like

In my local machine i have to compile it and upload files to the server. share|improve this answer answered May 18 at 10:41 Medhat Fawzy 161 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign immediately after that.

this has to do with impersonation.

At least I've come across that in an application where connections were being continually created and never properly closed. Click OK. 5. What was that alien in Doctor Who that nobody saw? Can the editor of a book add citations of individual chapters to his own citation count?

Even if the inputs are all the same, still the error occur not in the first execution of the loop but on the n? Unspecified error0DevExpress ASPxUploadControl throwing unspecified error0UWP FileSavePicker.PickSaveFileAsync() throws Unspecified error Hot Network Questions Why is the size of my email so much bigger than the size of its attached files? In the Authentication Methods dialog box, click to select the Anonymous Access check box. check over here e.

Start Microsoft Visual Studio .NET. wizend Edited by Wizend Monday, July 01, 2013 6:10 PM correction Monday, July 01, 2013 6:09 PM Reply | Quote 0 Sign in to vote I am using a 64 bit I also gave it permissions on the Temp folder in Documents and Settings\FRED\aspnet\Local Setttings, but this didn't help either. Set the authentication method on the application.

After trying out different steps like uninstalling office, restarting iis etc. Information regarding the origin and location of the exception can be identified using the exception stack trace below. We typically acquire connections and release them quickly to take advantage of connection pooling but I'm not sure you'll get connection pooling with Jet. Why was Susan treated so unkindly?

not always? Related Categories: ASP.Net, Misc, MOSS 2007, SharePoint, SharePoint 2010, SharePoint 2013, WSS 3.0 Tags: OleDBConnection Comments (1) Trackbacks (0) Leave a comment Trackback John February 4, 2015 at 1:37 AM Reply Solution 1 Accept Solution Reject Solution OK, the code you have posted doesn't look too bad (apart from the SQL Injection Attack caveat I mentioned). Sometimes i get this error and some times i don't .I really don't know how to tackle this.Please do some one help me on this.Its urgent.

This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. C# - Binding ComboBox withEnum SharePoint Survey List -EventReceiver RSS feed Google Youdao Xian Guo Zhua Xia My Yahoo! Yes, it is subject to sql injections, but even if the values is correct the error still occur. Terms of Service Layout: fixed | fluid CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100 Developer Fusion - The global developer community for .NET and Java

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 After a lot of hunting about I fixed that, but now whenver a script tries to access an Access database I get the Unspecified error Description: An unhandled exception occurred during Encode the alphabet cipher How strange is it (as an undergrad) to email a professor from another institution about possibly working in their lab? more hot questions lang-cs about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Science Other

On Friday, my code was working just fine, but come Monday morning I'm now receiving this error on the "dataAdapter.Fill(dataset)" every time I try to read Excel into a dataset using