Home > Unspecified Error > Unspecified Error Excel Asp.net

Unspecified Error Excel Asp.net

OleDbCommand to execute a query. This answer solved your problem? –juan Sep 18 '08 at 20:15 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign 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). Resolution Give the ASP.NET user account create/write privileges to the folder where the excel/access file is placed. his comment is here

but the error occurs when Open() method of oledb connection is called. SpreadsheetGear actually creates and reads the workbook in less time than it takes to read the workbook with OleDB. 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 Resolution Give the impersonated account full access to the above mentioned folder.

VipulAgrawal 30-Apr-13 3:50am If it is not allowing to open connection.....definetly it is a connectionstring issue..... Thank you so much for your time. -Xuong Reply bullpit Star 13199 Points 4793 Posts Re: unspecified error!!!!! Sign in using Search within: Articles Quick Answers Messages Use my saved content filters home articles Chapters and Sections> Search Latest Articles Latest Tips/Tricks Top Articles Beginner Articles Technical Blogs Posting/Update http://www.spreadsheetgear.com/products/spreadsheetgear.net.aspx It provides binary Excel file reading/writing in native .NET, solving all the previous problems I've encountered trying to use OLE and JET to read and create Excel files.

  1. While this is not a good thing to do, what makes it worse is that we have other applications on the same web site that would get impacted whenever we reset
  2. i have tried almost all formats of connection strings.
  3. Yes, it is subject to sql injections, but even if the values is correct the error still occur.
  4. the value of test is this (i get his value putting in string of catch section): C:\aplicaciones\Offers\content\es\Temp\Files\SCD.xls and the same for strFilePath: ../../content/es/Temp/Files/SCD.xls The problem is the line marked in black:
  5. The most frustrating thing is that it will work for several times in a row, and then start failing every time (until IISREST).
  6. share|improve this answer answered Mar 8 '11 at 10:56 LearnEarn 111 add a comment| up vote 1 down vote Seems like I got it wrong, see Problem with OleDbConnection, Excel and
  7. 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
  8. I have checked permissions on various temp folders that JET supposedly uses, and permissions are fine.
  9. Found this when getting an error trying to open access DB on my 64-bit computer.
  10. Post that bit, and (say) 15 or so lines either side to give us context.

Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts try this patch http://support.microsoft.com/kb/827190 « Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes Understand that English isn't everyone's first language so be lenient of bad spelling and grammar. Solved ASP.NET System.Data.OleDb.OleDbException: Unspecified error reading Excel file Posted on 2009-01-14 C# 1 Verified Solution 7 Comments 4,181 Views Last Modified: 2012-05-06 I have the following code in a web service You also mentioned google for this matter.

Anyways, thank you, through for your time. -Xuong Reply bullpit Star 13199 Points 4793 Posts Re: unspecified error!!!!! Linux questions C# questions ASP.NET questions fabric questions SQL questions discussionsforums All Message Boards... I did that too. Under ASP.NET, these files will be created under the C:\Documents and Settings\MachineName\ASPNET\Local Settings\Temp folder.

I needed to… C# DRY Exception Handling with PostSharp Article by: Alexandre Exception Handling is in the core of any application that is able to dignify its name. Are there any better (and free) ways of processing Excel files from C#/ASP.NET apart from OleDb? (We prefer not to install MS Office on the servers since it's not recommended by It works like magic. unspecified error when Import data from Excel to DataGride .xls to .xlsx in c# Is it possible to read data of excel sheet(.xls) from client-side without uploading it onto server decimal

How many columns? As a guest, you can read any forum posting. It is easier to use and faster than OleDB or the Excel COM object model (keep reading for some evidence of this). This would automatically checks all the below boxes.

Insults are not welcome. this content How to fix a bent lens mount hook? Integer function which takes every value infinitely often If possible, how to include cut marks in PDF? (using watermark?) Why is the FBI making such a big deal out Hillary Clinton's How should I deal with players who prefer "realistic" approaches to challenges?

I assume you are also looping through a list of files and .Open() a new connection to each file. Select the 'Security' tab 3. Actually, Google is my number one source of debugging. weblink LEARN MORE Join & Write a Comment Already a member?

And DbDataReader to read the rows. Thanks, Max Let Me Google That For You! vikas2020 19-Dec-13 2:22am If yes then please share with me, I am also facing the same problem.

conn.Mode = ADODB.ConnectModeEnum.adModeReadWrite; Thanks, Max Let Me Google That For You!

In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming. .NET Programming C# System Programming Enterprise Software Programming BM(50000, 10); } static void BM(int rows, int cols) { // Compare the performance of OleDB to SpreadsheetGear for reading // workbooks. Windows 2000 SP4 servers. does setting "pooling=false" fixed the issue? 0 Featured Post What Security Threats Are You Missing?

Thanks in Advance. Terms of Service Layout: fixed | fluid CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100 MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Browse other questions tagged c# debugging connection-string xls oledbconnection or ask your own question. check over here Why does Deep Space Nine spin?

Thank you so much. share|improve this answer answered Dec 2 '09 at 11:04 mt99 111 add a comment| up vote 1 down vote Connection TimeOut might be one of the reason. For those of you who have the same problem, please let me know how did you solve it. Join the community of 500,000 technology professionals and ask your questions.

Please help! Join & Ask a Question Need Help in Real-Time? http://support.microsoft.com/kb/825738 Good luck.... share|improve this answer answered Jan 23 '09 at 11:32 Keith 67k39185293 add a comment| up vote 1 down vote SpreadsheetGear for .NET gives you an API for working with xls and

I am working on a website using VB.NET. What are the German equivalents of “First World War”, “World War I”, and “WWI”? Browse other questions tagged c# asp.net excel oledb or ask your own question.