Straight ASP problem

Hi there.
I am having a weird problem. Currently I have a straight ASP page that
queries an Access database and returns the large recordset on a page that
loops through the recordset and writes the appropriate <td> tags in order to
put the data into a table. Now when I run it in my test environment it runs
no problem, however when I upload to my ISP I get a iis 500 error. But no
error on test server.
A few things: I have noticed that if I decrease the the number of
Response.Write and rstSearch.Fields("FIeldName") code lines that it works
ok on the ISP server.
Any ideas?
JoePart of the web configuration in IIS is the time allowed for a page to run.
If it goes beyond say 900 seconds IIS thinks it's hit an error and declares
a problem.
Another part of the configuration tells IIS what to do with errors; either
give an unhelpful 'an error occurred...' message or give full details to
help the developer figure out what went wrong. In a production environment
IIS is usually set to give no help to potential hackers.
It may simply be that having so many response.write lines in your page takes
too long to process. That would explain why removing some of them fixes the
problem.
Suggestions:
Increase the time-out period by alering the config on your IIS server.
Decrease the size of the recordset. Maybe use paging?
Brian Lowe
--@.
"Joe Coppola" <jocojr@.hotmail.com> wrote in message
news:OyBzKycUEHA.3420@.TK2MSFTNGP12.phx.gbl...
> Hi there.
> I am having a weird problem. Currently I have a straight ASP page that
> queries an Access database and returns the large recordset on a page that
> loops through the recordset and writes the appropriate <td> tags in order
to
> put the data into a table. Now when I run it in my test environment it
runs
> no problem, however when I upload to my ISP I get a iis 500 error. But no
> error on test server.
> A few things: I have noticed that if I decrease the the number of
> Response.Write and rstSearch.Fields("FIeldName") code lines that it works
> ok on the ISP server.
> Any ideas?
> Joe
>
Brian,
Thanks for the reply. I too thought about the timeout setting, but
interestingly I changed the timeout setting on my test server to be like 1
second and I dont get the error, the page just doesnt finish loading
completely. Note I also set the timeout or ASP pages as well.
Is there a way to get a more complete error message?
You are correct the # of response lines is sort of the cause, and I have
thought of paging the results, however, I need the users to be able to
export the whole results to another program... any ideas of this?
Well thanks for the help.
Joe
"Brian Lowe" <no@.reply.address> wrote in message
news:%23ZJsgHeUEHA.2580@.TK2MSFTNGP12.phx.gbl...
> Part of the web configuration in IIS is the time allowed for a page to
run.
> If it goes beyond say 900 seconds IIS thinks it's hit an error and
declares
> a problem.
> Another part of the configuration tells IIS what to do with errors; either
> give an unhelpful 'an error occurred...' message or give full details to
> help the developer figure out what went wrong. In a production environment
> IIS is usually set to give no help to potential hackers.
> It may simply be that having so many response.write lines in your page
takes
> too long to process. That would explain why removing some of them fixes
the
> problem.
> Suggestions:
> Increase the time-out period by alering the config on your IIS server.
> Decrease the size of the recordset. Maybe use paging?
> Brian Lowe
> --@.
> "Joe Coppola" <jocojr@.hotmail.com> wrote in message
> news:OyBzKycUEHA.3420@.TK2MSFTNGP12.phx.gbl...
that
order
> to
> runs
no
works
>

Straight ASP problem

Hi there.

I am having a weird problem. Currently I have a straight ASP page that
queries an Access database and returns the large recordset on a page that
loops through the recordset and writes the appropriate <td> tags in order to
put the data into a table. Now when I run it in my test environment it runs
no problem, however when I upload to my ISP I get a iis 500 error. But no
error on test server.

A few things: I have noticed that if I decrease the the number of
Response.Write and rstSearch.Fields("FIeldName") code lines that it works
ok on the ISP server.

Any ideas?

JoePart of the web configuration in IIS is the time allowed for a page to run.
If it goes beyond say 900 seconds IIS thinks it's hit an error and declares
a problem.

Another part of the configuration tells IIS what to do with errors; either
give an unhelpful 'an error occurred...' message or give full details to
help the developer figure out what went wrong. In a production environment
IIS is usually set to give no help to potential hackers.

It may simply be that having so many response.write lines in your page takes
too long to process. That would explain why removing some of them fixes the
problem.

Suggestions:

Increase the time-out period by alering the config on your IIS server.

Decrease the size of the recordset. Maybe use paging?

Brian Lowe
---@.

"Joe Coppola" <jocojr@.hotmail.com> wrote in message
news:OyBzKycUEHA.3420@.TK2MSFTNGP12.phx.gbl...
> Hi there.
> I am having a weird problem. Currently I have a straight ASP page that
> queries an Access database and returns the large recordset on a page that
> loops through the recordset and writes the appropriate <td> tags in order
to
> put the data into a table. Now when I run it in my test environment it
runs
> no problem, however when I upload to my ISP I get a iis 500 error. But no
> error on test server.
> A few things: I have noticed that if I decrease the the number of
> Response.Write and rstSearch.Fields("FIeldName") code lines that it works
> ok on the ISP server.
> Any ideas?
> Joe
Brian,

Thanks for the reply. I too thought about the timeout setting, but
interestingly I changed the timeout setting on my test server to be like 1
second and I dont get the error, the page just doesnt finish loading
completely. Note I also set the timeout or ASP pages as well.

Is there a way to get a more complete error message?

You are correct the # of response lines is sort of the cause, and I have
thought of paging the results, however, I need the users to be able to
export the whole results to another program... any ideas of this?

Well thanks for the help.

Joe

"Brian Lowe" <no@.reply.address> wrote in message
news:%23ZJsgHeUEHA.2580@.TK2MSFTNGP12.phx.gbl...
> Part of the web configuration in IIS is the time allowed for a page to
run.
> If it goes beyond say 900 seconds IIS thinks it's hit an error and
declares
> a problem.
> Another part of the configuration tells IIS what to do with errors; either
> give an unhelpful 'an error occurred...' message or give full details to
> help the developer figure out what went wrong. In a production environment
> IIS is usually set to give no help to potential hackers.
> It may simply be that having so many response.write lines in your page
takes
> too long to process. That would explain why removing some of them fixes
the
> problem.
> Suggestions:
> Increase the time-out period by alering the config on your IIS server.
> Decrease the size of the recordset. Maybe use paging?
> Brian Lowe
> ---@.
> "Joe Coppola" <jocojr@.hotmail.com> wrote in message
> news:OyBzKycUEHA.3420@.TK2MSFTNGP12.phx.gbl...
> > Hi there.
> > I am having a weird problem. Currently I have a straight ASP page that
> > queries an Access database and returns the large recordset on a page
that
> > loops through the recordset and writes the appropriate <td> tags in
order
> to
> > put the data into a table. Now when I run it in my test environment it
> runs
> > no problem, however when I upload to my ISP I get a iis 500 error. But
no
> > error on test server.
> > A few things: I have noticed that if I decrease the the number of
> > Response.Write and rstSearch.Fields("FIeldName") code lines that it
works
> > ok on the ISP server.
> > Any ideas?
> > Joe

strange but true

Hi all,

I have been working on an Asp .Net project that reports from a database.
The project was going great, until all of a sudden the results stopped
displaying!. I do not know if it is a buffering problem, the thing is that
I did not get any warning at compilation time, and when trying to display
output from within VS I did not see the labels with the values coming out
of the database. I was able to get evrything perfect until I added a new
datagrid to display a new result set. I then tried to comment out the
code that operates on that result set, but I still get no output.

Can anybody help?

Thanks,

Carlos.And if you take a look at the HTML source? Could be that you might have
added additional code and forgot to add the closing tag or forgot the end
quote of an attribute value or something.

Gabriel Lozano-Morn

"Carlos" <ch_sanin@.yahoo.com> wrote in message
news:OkOAkZaSFHA.3788@.tk2msftngp13.phx.gbl...
> Hi all,
> I have been working on an Asp .Net project that reports from a database.
> The project was going great, until all of a sudden the results stopped
> displaying!. I do not know if it is a buffering problem, the thing is that
> I did not get any warning at compilation time, and when trying to display
> output from within VS I did not see the labels with the values coming out
> of the database. I was able to get evrything perfect until I added a new
> datagrid to display a new result set. I then tried to comment out the
> code that operates on that result set, but I still get no output.
> Can anybody help?
> Thanks,
> Carlos.
Thank you Gabriel for your answer,

I noticed that I placed some initialization code inside the
initializeComponent() function, that got wiped out when I updated
the page while working in the designer pane (i.e. even the event handler
got removed..) is it not recommended to place code inside this function?

Please let me know if this function is something that I should not be
messing with... Thanks again,

Carlos.

"Gabriel Lozano-Morn" <gabriel.lozano@.no-spam.com> wrote in message
news:ODWYbraSFHA.3988@.tk2msftngp13.phx.gbl...
> And if you take a look at the HTML source? Could be that you might have
> added additional code and forgot to add the closing tag or forgot the end
> quote of an attribute value or something.
> Gabriel Lozano-Morn
> "Carlos" <ch_sanin@.yahoo.com> wrote in message
> news:OkOAkZaSFHA.3788@.tk2msftngp13.phx.gbl...
> > Hi all,
> > I have been working on an Asp .Net project that reports from a database.
> > The project was going great, until all of a sudden the results stopped
> > displaying!. I do not know if it is a buffering problem, the thing is
that
> > I did not get any warning at compilation time, and when trying to
display
> > output from within VS I did not see the labels with the values coming
out
> > of the database. I was able to get evrything perfect until I added a new
> > datagrid to display a new result set. I then tried to comment out the
> > code that operates on that result set, but I still get no output.
> > Can anybody help?
> > Thanks,
> > Carlos.

strange but true

Hi all,
I have been working on an Asp .Net project that reports from a database.
The project was going great, until all of a sudden the results stopped
displaying!. I do not know if it is a buffering problem, the thing is that
I did not get any warning at compilation time, and when trying to display
output from within VS I did not see the labels with the values coming out
of the database. I was able to get evrything perfect until I added a new
datagrid to display a new result set. I then tried to comment out the
code that operates on that result set, but I still get no output.
Can anybody help?
Thanks,
Carlos.And if you take a look at the HTML source? Could be that you might have
added additional code and forgot to add the closing tag or forgot the end
quote of an attribute value or something.
Gabriel Lozano-Morn
"Carlos" <ch_sanin@.yahoo.com> wrote in message
news:OkOAkZaSFHA.3788@.tk2msftngp13.phx.gbl...
> Hi all,
> I have been working on an Asp .Net project that reports from a database.
> The project was going great, until all of a sudden the results stopped
> displaying!. I do not know if it is a buffering problem, the thing is that
> I did not get any warning at compilation time, and when trying to display
> output from within VS I did not see the labels with the values coming out
> of the database. I was able to get evrything perfect until I added a new
> datagrid to display a new result set. I then tried to comment out the
> code that operates on that result set, but I still get no output.
> Can anybody help?
> Thanks,
> Carlos.
>
Thank you Gabriel for your answer,
I noticed that I placed some initialization code inside the
initializeComponent() function, that got wiped out when I updated
the page while working in the designer pane (i.e. even the event handler
got removed..) is it not recommended to place code inside this function?
Please let me know if this function is something that I should not be
messing with... Thanks again,
Carlos.
"Gabriel Lozano-Morn" <gabriel.lozano@.no-spam.com> wrote in message
news:ODWYbraSFHA.3988@.tk2msftngp13.phx.gbl...
> And if you take a look at the HTML source? Could be that you might have
> added additional code and forgot to add the closing tag or forgot the end
> quote of an attribute value or something.
> Gabriel Lozano-Morn
> "Carlos" <ch_sanin@.yahoo.com> wrote in message
> news:OkOAkZaSFHA.3788@.tk2msftngp13.phx.gbl...
that
display
out
>

Strange character transformations

Hi,

I have an ASP.Net website, which allows users to upload a file which is
then inserted into a database.

This is all fine until it reads a line with the string +Anu in it.
It transforms this to this char ? (which, if Googled for, is
described as Unicode Character 'LATIN SMALL LETTER TURNED R WITH HOOK'
(U+027B) or, in Phonetics, as a 'Retroflex approximant'.)

Has anyone seen this behaviour before, and know how to stop it?
The code's simple - here's an example. The ? appears in the output
where the input is +Anu - it's transformed before I can touch it!

using (StreamReader sr = new StreamReader(strFile,
System.Text.Encoding.UTF7)) {
// Read and display lines from the file until the end of the file is
reached.
while ((line = sr.ReadLine()) != null) {
Response.Write(line);
}
}

Regards

AdamLooks like an encoding issue, alright.
Have you tried using the StreamReader constructor that does not require a
character encoding?

"CyberSpyders@.gmail.com" wrote:

Quote:

Originally Posted by

Hi,
>
I have an ASP.Net website, which allows users to upload a file which is
then inserted into a database.
>
This is all fine until it reads a line with the string +Anu in it.
It transforms this to this char ? (which, if Googled for, is
described as Unicode Character 'LATIN SMALL LETTER TURNED R WITH HOOK'
(U+027B) or, in Phonetics, as a 'Retroflex approximant'.)
>
Has anyone seen this behaviour before, and know how to stop it?
The code's simple - here's an example. The ? appears in the output
where the input is +Anu - it's transformed before I can touch it!
>
using (StreamReader sr = new StreamReader(strFile,
System.Text.Encoding.UTF7)) {
// Read and display lines from the file until the end of the file is
reached.
while ((line = sr.ReadLine()) != null) {
Response.Write(line);
}
}
>
Regards
>
Adam
>
>

Graven,

I'm not sure how a 4 letter string like this could be seen as an
encoding issue, but I will certainly give it a go. Thanks for the
suggestion.

Adam

Graven wrote:

Quote:

Originally Posted by

Try to use plain latin-1 encoding. I think it's an unicode
normalization issue, but don't know if StreamReader performs it by
default.
>
>
CyberSpyders@.gmail.com wrote:

Quote:

Originally Posted by

Hi,

I have an ASP.Net website, which allows users to upload a file which is
then inserted into a database.

This is all fine until it reads a line with the string +Anu in it.
It transforms this to this char ? (which, if Googled for, is
described as Unicode Character 'LATIN SMALL LETTER TURNED R WITH HOOK'
(U+027B) or, in Phonetics, as a 'Retroflex approximant'.)

Has anyone seen this behaviour before, and know how to stop it?
The code's simple - here's an example. The ? appears in the output
where the input is +Anu - it's transformed before I can touch it!

using (StreamReader sr = new StreamReader(strFile,
System.Text.Encoding.UTF7)) {
// Read and display lines from the file until the end of the file is
reached.
while ((line = sr.ReadLine()) != null) {
Response.Write(line);
}
}

Regards

Adam

Larry,

You were spot on - changing to UTF8 stopped this transformation. Thanks

It's not quite solved my problem though.
The file is a Text file, each line being a series of files delimited by
the character, as this was unliekley to ever appear in the actual
data.

Unfortunately, UTF8 encoding strips these characters completely. ASCII
encoding, on the other hand, replaces them with ?

Oh the joy of character encoding.

Regards

Adam

Larry Lard wrote:

Quote:

Originally Posted by

This is why you are seeing what you are seeing. UTF7 encodes characters
outside the printable 7 bit range using UTF16 then modified base64, with
+ as the indicator mark for this encoding. I haven't checked, but I
imagine +Anu is the UTF7 encoding of that character. You shouldn't use a
UTF7 reader to read a file that you don't know for sure was produced by
a UTF7 writer.
>
The correct way to read the file depends on what kind of file it is. If
it is text of an unknown encoding, there is no way to be absolutely
sure, but UTF8 is a good starting point. If it's binary data, you
shouldn't be using a TextReader class at all.

Strange Datagrid Update Problem

Hi,

I'm having a strange problem with the update function of a datagrid:

I have a datagrid, the first column lists item names from a database.
Second column is an EditCommandColumn, and then I have a couple of
button columns after that to deal with row deletes etc.

The problem is occuring in the method that I have specified should
deal with the update event:

protected void nameEditUpdate(object sender, DataGridCommandEventArgs
e)

Because the first column I know contains the item that is getting
updated, I try:

tmpTextBox = (TextBox)e.Item.Cells[0].Controls[0];

To get the control, before looking at its Text property. However,
when I try this I get:

System.InvalidCastException: Specified cast is not valid.

So to try and figure out what is going on, I have tried looking at the
type being returned by e.Item.Cells[0].Controls[0], which turns out to
be type System.Web.UI.LiteralControl, the name and text properties of
it are blank. This has just confused me even more.

Anyone have any idea just what might be going on?

Appreciated!Use FindControl instead of hard coding the position in the Controls collection.
Otherwise iterate over the Controls collection until you find your TextBox
(I bet it's at position Controls[1]). What's happening is that there's whitespace
in your template after the <ItemTemplate> and before your <asp:TextBox> and
that's the LiteralControl you're seeing.

-Brock
DevelopMentor
http://staff.develop.com/ballen

> Hi,
> I'm having a strange problem with the update function of a datagrid:
> I have a datagrid, the first column lists item names from a database.
> Second column is an EditCommandColumn, and then I have a couple of
> button columns after that to deal with row deletes etc.
> The problem is occuring in the method that I have specified should
> deal with the update event:
> protected void nameEditUpdate(object sender, DataGridCommandEventArgs
> e)
> Because the first column I know contains the item that is getting
> updated, I try:
> tmpTextBox = (TextBox)e.Item.Cells[0].Controls[0];
> To get the control, before looking at its Text property. However,
> when I try this I get:
> System.InvalidCastException: Specified cast is not valid.
> So to try and figure out what is going on, I have tried looking at the
> type being returned by e.Item.Cells[0].Controls[0], which turns out to
> be type System.Web.UI.LiteralControl, the name and text properties of
> it are blank. This has just confused me even more.
> Anyone have any idea just what might be going on?
> Appreciated!
Thanks Brock. I would never have guessed that whitespace would be a
member of the controls collection!

On Sat, 11 Jun 2005 07:06:34 -0700, Brock Allen
<ballen@.NOSPAMdevelop.com> wrote:

>Use FindControl instead of hard coding the position in the Controls collection.
>Otherwise iterate over the Controls collection until you find your TextBox
>(I bet it's at position Controls[1]). What's happening is that there's whitespace
>in your template after the <ItemTemplate> and before your <asp:TextBox> and
>that's the LiteralControl you're seeing.
>-Brock
>DevelopMentor
>http://staff.develop.com/ballen

Strange error message at client

Hello!

I would like to do database change on a web page created with ASP.NET.

As soon as I click on Update in a datagrid web control, I get following
error message:

Unable to find script library
'/asp_client/system_web/1_0_3705_288/WebUIValidation.js'. Try placing this
file manually, or reinstall by running 'aspnet_regiis -c'.

I must say, that this file does exist in the path shown in the error
message. Insofar the error message is very strange.

Which are the reasons for the error? Could it be, that some ASP.NET sites
use a SmartNavigation or are the security settings at client to high?

Regards,
RobertTry running aspnet_regiis on the web site you are using. This is a
client-side error that is triggered by the file not being there, at least
from the client's perspective, so that's a good place to start.

--
Chris Jackson
Software Engineer
Microsoft MVP - Windows Shell/UI
Windows XP Associate Expert
--
More people read the newsgroups than read my email.
Reply to the newsgroup for a faster response.
(Control-G using Outlook Express)
--

"Robert Wehofer" <thalion77@.graffiti.net> wrote in message
news:c4%tb.112229$W7.62099@.news.chello.at...
> Hello!
> I would like to do database change on a web page created with ASP.NET.
> As soon as I click on Update in a datagrid web control, I get following
> error message:
> Unable to find script library
> '/asp_client/system_web/1_0_3705_288/WebUIValidation.js'. Try placing this
> file manually, or reinstall by running 'aspnet_regiis -c'.
> I must say, that this file does exist in the path shown in the error
> message. Insofar the error message is very strange.
> Which are the reasons for the error? Could it be, that some ASP.NET sites
> use a SmartNavigation or are the security settings at client to high?
> Regards,
> Robert

Strange IIS6.0/ASP.NET Behaviour (HELP!)

I have a web app that builds a tree from a database. The tree is built on
demand when the user POSTs the page back to the sever. The server maintains
a copy of the current tree in a session object.
This all works fine on the development server but I have a problem on my
live server (IIS6.0 ASP.NET 1.1). When the user posts the page back the
request is not getting to ASP.NET. When tracing is enabled there is no
entry. However the browser is getting an old picture of the tree from a
couple of clicks ago and things start going a bit haywire.
I have set every option I can find within my code to prevent caching
occuring, and I know that no servers along the route a caching because I get
the same problem when I access the app from the server using localhost.
I have read a bit about 2003 and the http.sys cache and believe that my
problem my lie here.
HELP!!
Thanks in anticipation
Mikere:
> I have read a bit about 2003 and the http.sys cache and believe that my
> problem my lie here.
There is a simple way to find out if the problem is with the http.sys cache.
You can disable it entirely.
That way, if the problem continues, you'll know it's not http.sys's fault.
Follow the instructions at http://support.microsoft.com/?id=820129
to create a DWORD value of zero for "UriEnableCache" at this key :
HKEY_LOCAL_MACHINE\System\CurrentControl
Set\Services\HTTP\Parameters
Mind you, use this only for test purposes.
The http.sys cache is important for IIS's performance.
Here's some more background info on http.sys cache which you will find
interesting, since it details the reasons for http.sys *not* caching content
:
http://support.microsoft.com/Default.aspx?id=817445
You might want to try out any of those techniques
to force http.sys to not cache content.
Juan T. Llibre
ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
==========================
"Mike Trebilcock" <no@.replies.here> wrote in message
news:dgb3gc$atl$1@.news8.svr.pol.co.uk...
>I have a web app that builds a tree from a database. The tree is built on
> demand when the user POSTs the page back to the sever. The server maintai
ns
> a copy of the current tree in a session object.
> This all works fine on the development server but I have a problem on my
> live server (IIS6.0 ASP.NET 1.1). When the user posts the page back the
> request is not getting to ASP.NET. When tracing is enabled there is no
> entry. However the browser is getting an old picture of the tree from a
> couple of clicks ago and things start going a bit haywire.
> I have set every option I can find within my code to prevent caching
> occuring, and I know that no servers along the route a caching because I g
et
> the same problem when I access the app from the server using localhost.
> I have read a bit about 2003 and the http.sys cache and believe that my
> problem my lie here.
> HELP!!
> Thanks in anticipation
> Mike
>
>

Strange IIS6.0/ASP.NET Behaviour (HELP!)

I have a web app that builds a tree from a database. The tree is built on
demand when the user POSTs the page back to the sever. The server maintains
a copy of the current tree in a session object.

This all works fine on the development server but I have a problem on my
live server (IIS6.0 ASP.NET 1.1). When the user posts the page back the
request is not getting to ASP.NET. When tracing is enabled there is no
entry. However the browser is getting an old picture of the tree from a
couple of clicks ago and things start going a bit haywire.

I have set every option I can find within my code to prevent caching
occuring, and I know that no servers along the route a caching because I get
the same problem when I access the app from the server using localhost.

I have read a bit about 2003 and the http.sys cache and believe that my
problem my lie here.

HELP!!

Thanks in anticipation

Mikere:
> I have read a bit about 2003 and the http.sys cache and believe that my
> problem my lie here.

There is a simple way to find out if the problem is with the http.sys cache.
You can disable it entirely.

That way, if the problem continues, you'll know it's not http.sys's fault.

Follow the instructions at http://support.microsoft.com/?id=820129
to create a DWORD value of zero for "UriEnableCache" at this key :

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Servic es\HTTP\Parameters

Mind you, use this only for test purposes.
The http.sys cache is important for IIS's performance.

Here's some more background info on http.sys cache which you will find
interesting, since it details the reasons for http.sys *not* caching content :

http://support.microsoft.com/Default.aspx?id=817445

You might want to try out any of those techniques
to force http.sys to not cache content.

Juan T. Llibre
ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
==========================

"Mike Trebilcock" <no@.replies.here> wrote in message
news:dgb3gc$atl$1@.news8.svr.pol.co.uk...
>I have a web app that builds a tree from a database. The tree is built on
> demand when the user POSTs the page back to the sever. The server maintains
> a copy of the current tree in a session object.
> This all works fine on the development server but I have a problem on my
> live server (IIS6.0 ASP.NET 1.1). When the user posts the page back the
> request is not getting to ASP.NET. When tracing is enabled there is no
> entry. However the browser is getting an old picture of the tree from a
> couple of clicks ago and things start going a bit haywire.
> I have set every option I can find within my code to prevent caching
> occuring, and I know that no servers along the route a caching because I get
> the same problem when I access the app from the server using localhost.
> I have read a bit about 2003 and the http.sys cache and believe that my
> problem my lie here.
> HELP!!
> Thanks in anticipation
> Mike
>

Strange problem on database update

Does anyone have this problem before, I was developing asp.net 2.0 using VS
2005, everything works fine, I had used "Publish Web Site" to deploy my app.
on local machine's IIS, works as I expected too.
But today, when I use same method to deploy my solution on my IIS, while I
do the testing, any function which requires performing action query on my
Access DB, the web page displayed following error:
Operation must use an updateable query
Exception Details: System.Data.OleDb.OleDbException: Operation must use an
updateable query.
Other than that, all "retrieve" data operation to display records on web
pages had no problem. If I use VS 2005 to run my app. this problem does not
occur, I had also copy the same folder of IIS to another machine, this
problem doesn't occur.
Does anyone know what would be the problem on my IIS or something else?This must be a security problem. If the process does not have access to
Change the MDB (or MDE) Access file then the database becomes read-only
and you cannot update. Make sure that the ASPNET local account in the
computer were IIS is running has Change rights on the MDB or MDE file.
Hope this helps.
thanks very much, you are absolutely right. I'm using WinXP as my IIS
platform for testing, once i share the web site's folder to "Allow network
users to change my files", the update operation working now!
If I don't want to share the directory this way. You mentioned setting
ASPNET local account to have change rights! how do you properly do this in
Win XP?
"Neutrino" <neo_virtual@.yahoo.com> wrote in message
news:1145249072.160245.235360@.v46g2000cwv.googlegroups.com...
> This must be a security problem. If the process does not have access to
> Change the MDB (or MDE) Access file then the database becomes read-only
> and you cannot update. Make sure that the ASPNET local account in the
> computer were IIS is running has Change rights on the MDB or MDE file.
> Hope this helps.
>
goodie, i went to my IIS root directory (C:\Inetpub\wwwroot) to add ASPNet
account to have write permission, which i think is a more proper way of
setting it up!
thanks for your help anyway!
"Neutrino" <neo_virtual@.yahoo.com> wrote in message
news:1145249072.160245.235360@.v46g2000cwv.googlegroups.com...
> This must be a security problem. If the process does not have access to
> Change the MDB (or MDE) Access file then the database becomes read-only
> and you cannot update. Make sure that the ASPNET local account in the
> computer were IIS is running has Change rights on the MDB or MDE file.
> Hope this helps.
>

Strange problem on database update

Does anyone have this problem before, I was developing asp.net 2.0 using VS
2005, everything works fine, I had used "Publish Web Site" to deploy my app.
on local machine's IIS, works as I expected too.

But today, when I use same method to deploy my solution on my IIS, while I
do the testing, any function which requires performing action query on my
Access DB, the web page displayed following error:

Operation must use an updateable query
Exception Details: System.Data.OleDb.OleDbException: Operation must use an
updateable query.

Other than that, all "retrieve" data operation to display records on web
pages had no problem. If I use VS 2005 to run my app. this problem does not
occur, I had also copy the same folder of IIS to another machine, this
problem doesn't occur.

Does anyone know what would be the problem on my IIS or something else?This must be a security problem. If the process does not have access to
Change the MDB (or MDE) Access file then the database becomes read-only
and you cannot update. Make sure that the ASPNET local account in the
computer were IIS is running has Change rights on the MDB or MDE file.

Hope this helps.
thanks very much, you are absolutely right. I'm using WinXP as my IIS
platform for testing, once i share the web site's folder to "Allow network
users to change my files", the update operation working now!

If I don't want to share the directory this way. You mentioned setting
ASPNET local account to have change rights! how do you properly do this in
Win XP?

"Neutrino" <neo_virtual@.yahoo.com> wrote in message
news:1145249072.160245.235360@.v46g2000cwv.googlegr oups.com...
> This must be a security problem. If the process does not have access to
> Change the MDB (or MDE) Access file then the database becomes read-only
> and you cannot update. Make sure that the ASPNET local account in the
> computer were IIS is running has Change rights on the MDB or MDE file.
> Hope this helps.
goodie, i went to my IIS root directory (C:\Inetpub\wwwroot) to add ASPNet
account to have write permission, which i think is a more proper way of
setting it up!

thanks for your help anyway!

"Neutrino" <neo_virtual@.yahoo.com> wrote in message
news:1145249072.160245.235360@.v46g2000cwv.googlegr oups.com...
> This must be a security problem. If the process does not have access to
> Change the MDB (or MDE) Access file then the database becomes read-only
> and you cannot update. Make sure that the ASPNET local account in the
> computer were IIS is running has Change rights on the MDB or MDE file.
> Hope this helps.