473,748 Members | 2,887 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

asp.net and excell.. file share problems

Hi guys, I have a asp.net web app and it's connecting to
an excell 2003 document (in another folder) via
OleDataAdapter. Everything works and all, it's just that
when I shutdown IE and try to access the excell document,
asp.net seems to still keep it and won't release it.
Excell gives some error saying it can't access it, but
It's when I terminate the asp.net process in the task
manager that the file is then released.

I'm wanting to know if there is a way to make asp.net
release the file so that changing the data is possible?
or for every time I need to change the data, I would have
to take down the web page?
Nov 17 '05 #1
2 1377
I tried shutting down IIS web server, and asp.net still
kept it going.. so I'm not sure what's going on..
Nov 17 '05 #2
To release the Web server's grip on some components, you sometimes need to
run this in the Run box:

net stop iisadmin /y

Use Task Manager to stop the Excel.exe process.

Then start your Web server again.
"Robert Halstead" <ha******@oit.e du> wrote in message
news:06******** *************** *****@phx.gbl.. .
Hi guys, I have a asp.net web app and it's connecting to
an excell 2003 document (in another folder) via
OleDataAdapter. Everything works and all, it's just that
when I shutdown IE and try to access the excell document,
asp.net seems to still keep it and won't release it.
Excell gives some error saying it can't access it, but
It's when I terminate the asp.net process in the task
manager that the file is then released.

I'm wanting to know if there is a way to make asp.net
release the file so that changing the data is possible?
or for every time I need to change the data, I would have
to take down the web page?

Nov 17 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1802
by: Dave Harris | last post by:
Is there any way to have VB6 programmatically convert an embedded Excell file into a text file (or any sequential file)? I am relatively new to VB6 and none of the books I have consulted have the solution. Thanks in advance. Dave
1
7056
by: fabrice | last post by:
Hello, I've got trouble reading a text file (event viewer dump) by using the getline() function... After 200 - 300 lines that are read correctly, it suddenly stops reading the rest of the file... Thank you to all of you who can help me with this one...
0
802
by: Sam | last post by:
Hi All, I would like to know if it is possible to group three excell files with only one worksheet inside each file into one excel file with three worksheets so, at the begining I have 1 excel file with one Worksheet inside another excel file with one Worksheet inside another excel file with one Worksheet inside
1
8134
by: Duffman | last post by:
Hi, I have what seems to be a common problem, but the solutions I've found don't seem to work. I would like to use a web service to create a file at a UNC location in a shared file. Currently I'm just running it locally and saving the file locally using my machines UNC path. I have given user ASPNET full control over the folder I want to write the file to. I've also tried using the web config identity impersonation to use my user...
0
1107
by: Delforce | last post by:
Hi all, My application allows you to create a new excel file and then double click it in the list view to start it in excell. If the excell file is an existing one then I can start it now problem. The problem is when I create a new excel file in my application and try and double click it excell starts and has the name of my newly created file however doesn't show any sheets in the xls file. If I shut down the computer and run my...
2
2043
seshu
by: seshu | last post by:
hi every body This is seshu i have doubt in mysql i have some date in excell sheet to export that data i have copied all the data into a text file and the wrote this code in mysql editor LOAD DATA LOCAL INFILE 'pet.txt' INTO TABLE pet; it has been exported but now the problem is insted giveing my id no as id_0033 it is giving Id_0033along with a box suffixed to the id and this is only to last coumn why is it showing so...
2
1633
by: Twanne | last post by:
Hi, I've got these files in excell that need to be imported to access. Now I've got one file, and when I try to import it, it acts weird. There are two fields in the excell fiile (Start, Stop) that are dates. When I have done my import the dates change to some number for some reason. 19/02/2007 changes into 39132. I've got an idea why it is done (dates are stored as long in access) but I got no idea how to get around this. This only happens...
1
2286
by: thripurari | last post by:
Hi ! Dear all! I am getting a problem while binding the data source to the ultragrid . pls can any one could help me to bind the excell file to my ultra grid. My Question is: How to bind the data to the Ultragrid in windows application using C#.net, if the data source is either excell file or .XLS file? pls urgent. thanx anil kumar
1
1476
Ali Rizwan
by: Ali Rizwan | last post by:
Hi all, I m creating a database. The data for database will fetched from an excell sheet. Now how can i read an excell sheet and update my database with that excell sheet. Or I want to show all records of excell sheet in a listbox having a title of speecific text like "Names". Thanx >> ALI <<
0
8991
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9544
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9247
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8243
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6796
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4874
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3313
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2783
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2215
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.