Showing posts with label sql. Show all posts
Showing posts with label sql. Show all posts

Monday, March 26, 2012

Access is denied

When I try to install the ASP.Net Ajax download I get an access is denied message. I have IE7, ASP.NET 2.0, Visual Studio Express and SQL Server installed. I also have Net Beans 5.5. Could one of these programs have some sort of conflict with t Ajax framework.

Have you checked all the event logs? You might find a log message that will give you some more information.


Did you get a message telling you that it cannot find the AJAXDownloader(or whatever it is called)[1].msi when in fact it is called AJAXDownloader(or whatever it is called) without the [1]? This happened to me and I just changed the name of the .msi file on my desktop (or wherever you downloaded it to) to AJAXDownloader(or whatever it is called)[1].msi. This worked for me anyway.


Event logs are not very helpful. I found the following warning which does not help much.

Product:Windows Operating SystemID:1015Source:EvntAgntVersion:5.2Symbolic Name:SNMPELEA_NO_REGISTRY_TRACE_LEVEL_PARAMETERMessage:TraceLevel parameter not located in registry; Default trace level used is %1.

The exact message I got is:

C:\Documents and settings\...\Content.IE5\56UJ3Mk4\ASPAJXExtSetup[1].msi

Acces is denied.

Does this provide any clues.


Try this:

Instead of running the .msi file, save it to desktop.

Change the actual name of the icon on the desktop from ASPAJXExtSetup.msi to ASPAJXExtSetup[1].msi.

Double click it to run and install it.

This worked for me. Let me know if it was any help.


The exact message I got is:

C:\Documents and settings\...\Content.IE5\56UJ3Mk4\ASPAJXExtSetup[1].msi

Acces is denied.

I tried saving the download in my documents and then renaming the file without the [1] but this did not help. Did you save the file in another location maybe in the root directory.


Just to add to the above post, if the acccess is denied message appears again then just browse to the renamed ASPAJXExtSetup[1].msi file on the desktop.


Saving the file to the desktop did not have any effect.


What exactly happens when you rename the file to ...[1].msi and double click on it?


I get the same Access is denied message.

The latest clue I have about my problem came from trying to install the Vista advisor. I got the same Access denied message.

C:\Documents and Settings\Administrator\Local Settings\Temporary Internet Files\Content.IE5\3LUJIBF4\Windows Vista Upgrade Advisor[1].msi

Access is denied.

I installed both programs in my office computer without any problems. I don't know if this problem has to do with the fact that I downloaded these two programs to two different computers connected through a network or the problem has to do with the computer's regisistry.


when you run a .exe installer it unpacks the .msi in a tempory directory, this is the directory you dont have permission to write to, hence the error. Turning off UAC or right clicking the .exe file and selecting run as administrator will solve the problem.

Guessing Installing at the office worked because your IT administrator turned off UAC on the pcs to slow the wave of support calls

Saturday, March 24, 2012

Abort SQL query when aborting callback

Hi,

I have got a page that depends on database queries that may take a couple of minutes to complete.
The page shows an UpdateProgress element and the idea is to add an "abort" button to it.
As far as I remember it should be easy to abort the browser callback.

Ideally I would like to have the database query/command aborted too to prevent a waste of precious resources (SQL Server 2005).

I wonder what will happen to the orphan callback after it has been aborted.
If I am lucky, what happens is the following:

1. When the user aborts the callback, the HttpRequest is destroyed.
2. The keep-alive mechanism allows the web server to detect that the request under process is now orphan.
3. The relevant Page object is then destroyed.
4. Similarly, SQL Server looses contact with the "consumer", that is the Page, and automatically aborts the query.

If this is not the case, is there a way to obtain the same result?

Thanks in advance,

Paolo

Here are some sample codes to abort asynchronous post back through javascript for your reference.

<script type="text/javascript">
var prm = Sys.WebForms.PageRequestManager.getInstance();
function AbortPostBack() {
if (prm.get_isInAsyncPostBack()) {
prm.abortPostBack();
}
}
</script>

Wish the above can help you.


Thanks. What I am asking is if there is a way of cancelling the SQL query run by the call.

When a call is aborted the Response.IsClientConnected property value will become false. So I think what you need to do is to poll for the Response.IsClientConnected value and abort the query when it returns false (using SqlCommand.Cancel). This also means that you need to execute your query asynchronously.


I am facing similar problem.I try to use "Response.IsClientConnected".ut I found that it always returns "true" ( seems to be a bug).I am using IIS 6.

Is there any other work around for it ?

Thanks,

Vijay