Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
ASP.NET 2.0 Professional If you are an experienced ASP.NET programmer, this is the forum for your 2.0 questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 27th, 2007, 02:18 PM
Registered User
 
Join Date: Apr 2007
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default error using excel files

I'm working on a asp.net 2.0 site with sql, and i use an excel file to upload mass input data to the db, it works fine in w2kserver but in w2k3server i get the following error:

OleDbException (0x80004005): The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by

another user, or you need permission to view its data.]

 
Old April 27th, 2007, 03:16 PM
Registered User
 
Join Date: Apr 2007
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

May be your Excel file is kept open. Close it and try. also try to close anyother programs that open ur excel file. also check ur code if ur excel file is being opened in anyother part of the code and not closed

 
Old April 27th, 2007, 04:28 PM
Registered User
 
Join Date: Apr 2007
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Guys, I've fixed it, you have to grant security access to the IUSR on the temp folder of aspnet (C:/Documents and Settings/[servername]/aspnet/local settings/temp). actually i grant permissions to everyone but it seems to be something about impersonation on the web.config file, later I'll study this issue, but for now it works for me. Thanks





Similar Threads
Thread Thread Starter Forum Replies Last Post
Generating Excel FIles from resource Files abinashpatra ASP.NET 1.0 and 1.1 Basics 0 July 28th, 2008 02:07 AM
Error opening Excel 2007 files in Express Edition Exsharaen Visual Basic 2008 Essentials 2 April 25th, 2008 01:47 AM
Very Slow Excel Files vikashtiwari Excel VBA 9 April 22nd, 2008 01:56 PM
Merge many excel files into one excel files Roshanjoshi2001 Excel VBA 2 November 14th, 2007 06:23 PM
Opening Excel and Excel files dinosaur_uk VB.NET 2002/2003 Basics 3 September 17th, 2004 03:22 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.