im running asp.net using visual studio .net on IIS and Windows XP Pro im tryying to run a web application with accessing an access database but when i try to open the connection it says the file is in use or dont have permission.
im pretty sure it is the permissions but i cant add asp.net user to have access like with windows server what do i have to do to fix this?
I am using winXP pro + IIS5.1 to develop my site offline.
My data is in a folder outside the web, and I am told "my IUSR account needs
to have read/write/modify NTFS permissions to the directory housing the
file"
I can find no info on how actually to do this. Can anyone explain?
I get the error below when I attempt to write to an access database.
Reading is fine.
I solved this on the DEV site by making the IUSR_machine a domain
administrator.
Now the website is up on a production server on SISNA. Code:
I am methodically working my way through the Sitepoint 'Build your own ASP.NET website' and have been successful in every lesson up to page 279. However I've come stuck when trying to add information to an Access Database. When I try to do so I get the message:
Operation must use an updateable query.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.
I have tried the solution described in the book but still get the message. I am using IIS and XP Professional. The database works for queries so how do I get it to accept information entries?
I had some issues with setting file permissions to write to my database in access. How do I go about, step - by - step setting the file permissions?
View Replies View RelatedI need to set an online directory and file the write permissions,fot JET to use it's temp file whthout problems.
Im using ACE FTP Freeware,and the properties I ask for each element directory and each file says that the write permissions are OK, but I still got errors while trying to update it online.How can I change IIS permissions?
I have a compiled activex dll component on my server. When I log into the website under the administrator I can successfully access the dll, however using another windows NT user simply shows 'unable to create component due to permission'.I have ensured that the user in question has all writes to the dll file on the server, including the IUSR and IWAM accounts.
View Replies View Relatedi got somethiung about permissions or something, like when
i goto my site, and theres a bunch of bs about folder
permissions set to non read... whats up witht that????
Does anyone know of an asp script, online somewhere, that I can use to find
out the permissions of a folder? My ISP says these folders have full
permissions, but my programs say "permission denied". I don't know if it is
the programming, or if the folder don't really have the right permissions.
Is there a way to list the permissions on a directory in my web folder? Like group permissions and such
View Replies View RelatedI keep getting"Unable to open registry key 'Temporary (volatile) Jet DSN "
errors pointing to my connection string when the same connection string
is working for a few of my other pages.The MSAccess database does have
the right permissions configured. Below is code I'm using:
<%
dbcon="DBQ=" & Server.Mappath("diary.mdb") & ";Driver={Microsoft Access
Driver (*.mdb)};"
Set calConn = Server.CreateObject("ADODB.Connection")
calConn.Open dbcon%>
<%dim freetsql,rsfree
freetsql = "select text_field from diary where dte ='" & dfm & "'"
set rsfree = Server.CreateObject("ADODB.Recordset")
rsfree.Open freetsql,calConn,3 %>
I know this isn't the best group to ask this in - but I also know a lot of
you have experience with this kind of stuff
I'm going to be creating a site where customers will be able to set up their
own sub-site (ie. www.mysite.com/theirsubsite). I'll need to be able to
create virtual directories on-the-fly, so I plan on using ADSI to accomplish
this. My question is - what are my options when it comes to permissions?
Will I need to give the IUSR account admin permissions to create these
directories, or is there some way to impersonate an admin account on the
script creating the directories? Has anyone dealt with this before?
i need to allow my ASP app to append and use data in text file, but restrict users from pointing directly to it and opening it for viewing.
what permissions should be set for the text file and is there a special way to access the file from the my ASPs? i am use JET ISAM driver to had data access to the text file. it all works fine except for the problem i mention. also, i have to reset permissions when ever i upload from my PC to development and production sites.
I have a database (*.mdb), which I can connect to, query on, and return results from in ASP. Now, I want to do some ADDs,UPDATEs,and DELETEs.... but I get errors executing my SQL... What's the trick?
PS My connection (thus far) is this, and works.
Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Provider="Microsoft.Jet.OLEDB.4.0"
Conn.Open Server.MapPath("myDatabase.mdb")
How do I setup perrmissions in my FTP to allow anonymous access where you can only upload to and download from a separate folder but not create sub folders or change any permissions etc.
I have my trusted users with extended permission in like c:ftproot ame1, c:ftproot ame2 etc and would like to have my anonymous access directed to something like c:anonymous. I do not want them to see the trusted accounts. Can I and how do I do that?
I have a mixure of .htm / .html / .asp files on an IIS Server at our main office. When people at another location goto the web they can view the .htm,.html files but can't access the .asp because of permissions.
Now i've checked the permissions on the individual files and the two file types have the same permission settings. Is there something in the ASP platform that adds extra permissions to .asp files. (Active Directory wise).
can someone explain to me what the following privelages . eg. in one folder i want my database to be written to, but not allowed to be downloaded as a single mdb file.
in another folder i want my user to be able to upload images into it freely. other folders i want untouchable. here are the settings my host give me. if somebody could explain to me what the different users are. what certain settings will allow. in terms of ftp and website use.
here are the settings i can apply to each directory/file ....
I have a asp page that I need to check to see if the current logged on user is a member of a specific active directory group. How can I do this? I have tried so many different LDAP code examples and none seem to work.
Do I need to include a administrator username and password in the code? Does any have any samples of code I can try?
I am trying to delete a file using an ftp script. But it is not working. Is there some setting for ftp delete permissions or something?
View Replies View Relatedi had this site of mine running from my pc with duc no-ip for avoiding my ip from changing my ip. it was working fine, but i made an upgrade to my machine, so had to start all over again;
my web app works with access and asp;
i gave my .mdb total control to IUSER_myPcName and, in iis, in mmconsole, i go to my websites/properties/security and then in this window i click edit and i have:
anonimous access checked but the rest of it i'm unsure
when i try my login, i get this error msg:
Provider (0x80004005)
unspecified error
/a/login.asp, linha 53
that's the line where, in my script, i connect to odbc.
Ive recently migrated from dirty ol' PWS on Win98 to IIS 5.1 on XP and Im a little unfamiliar with the IIS snap on. Would any of you be able to help me with permissions so the Db can be updated but without adding security risks.
View Replies View RelatedI keep getting this error when I want to upload an image .
Microsoft VBScript runtime error '800a0046'
Permission denied
/sljobs/uploadphoto.asp, line 39
Do I have to give read/write permissions to the Scripts folder as well? what is the process for managing permissions to the folder?
Could someone help tell me what permissions I need to set my websites to
that run under IIS5 (on a windows 2000 server)
At the moment I have folders of websites within the c:inetpub i.e web1 web2
and so on
Each folder has 'allow inheritable permissions' selected.
I have just installed a web site that I am developing on to an XP machine. I cannot run update or set sql statements as I get an error: Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an
updateable query.
I've seen it before, and I thought I'd resolved it: Code:
I am installing phpBB and it says that i need to change the permissions on config.php to be writebale by all (666 or-rw-rw-rw within your FTP Client). does anyone know how to do this. I have tried right clicking and going to permissions but i do not see anywhere to change it to 666 or -rw-rw-rw .
View Replies View Relatedi created an asp script that calls wscript which in turn calls up an .bat file. I have tested this script on my machine on my home win2k3 machine but cannot reproduce the same thing on my other server. Right now, IIS requres "intergrated windows authentication" login and run the script.
I ve given the user account every possible permission combo i thought of. The script in question has permissiont to run, it even has admin priviledges for testing purposes. But nothing happens when i run it from my page. I am completly stuck right now. No idea how to persue this b/c ive exhuasted every possible thing i know and every tip i read about.
I am trying to use JavaScript to write/select values into a form on a remote .aspx page using frames.
I can load the webpage into the frame and write to the frame on my local test page.
However, on the remote page I get this error from FireBug:
"uncaught exception: Permission denied to get property HTMLDocument.aspnetForm"
Is there any way around this?
I have been successfully running ASP on a W2K IIS5.0 server using Anon
Access enabled, but would like to be able to restrict access to a particular
folder containing some ASP content to a particular NTFS user group that I
have set
up.
I have added this group to the particular folder (giving Full Control) and
switched off anon access and added Intergrated Windows authentication in IIS
Admin. The problem is that although users can access static content in this
folder, any attempt to run an ASP fails with a logon box appearing and
"Error: access denied" apearing in the page.
Is the problem that this user group does not have permissions on the system
files used to execute the ASPs? Everything works fine under my admin
account or if I make it all Anonymous access.
When I try to edit the db, I get the message: "No update permissions" I wanted to find a way to find out what the error is so that I can fix the problem. I have checked the permissions on the db and they allow read and write, to i think the permissions on the table are fine. The code for my demo_update.asp is Code:
View Replies View RelatedI currently have a asp page that will display what is currently in my windows folder. The problem i have is with permissions. I have all my departments on a page when i type in called: http://myserver/Website/dir_list.asp
in this i am showing different departments in hyperlinks to the windows structure. I have beside each department to tell me the amount of files that are in that department(folder).
I am having a problem whereby if i right click n the eningeering department and get rid of myserverusers account. I do not want everybody to have access to this.Only a dedicated person for the engineering department.
when i put the person individual login name to have access to it and get rid of myserverusers, it will come up with permission denied on the count, even though i have given myself administrator permission to the folder.
I basically have to take the permissions for myserverusers away from the folder but if i do, no matter what permissions i give the folder, it will keep denying me access without this. IUSR_<machinename>
Has any one ever comes across something like this before?
I'm developing an administration tool on a WinXP Pro / ASP / VBScript / MSIE 6 platform. (I know, BOO! for WinXP & File Permissions) But nonetheless, it's formated on a NTFS partition.
Anyways, I've been getting errors whom after searching online (at BLAZING 56k speeds!) keep stating that improper permissions are setup. What's hilarious is that they all say the same thing (literally, word for word, "You need to give XXX Read and Write permissions") but NONE of them tell you how to do that.
Well, in IIS, I've given the directory READ/WRITE permissions and in WinXP I've Right-Clicked on a folder, enabled it under WEB SHARING and gave it READ/WRITE permissions, and still I get random errors. The 2 errors I've been getting are:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/clients/amCart/admin/adm_administrators_add.asp, line 115
Code:
Is there a way to change permissions on a folder in ASP? Basically I make a folder using the FSO, and I want to change the permissions on thaty folder with ASP commands.
View Replies View RelatedI previously used PWS on Win 98. Nothing special had to be done locally for a directory that contained an Access database.
But on the Web host I had to do this:
Access Permissions | [Go to proper folder] | Anonymous account given permission of Change
Now I've just gotten a PC with Win XP Pro and have just installed IIS. My development Web sites work fine locally except whenever the ASP page tries to write data to the database, then there is an error message at the line that first tries to write data.
What can I do to modify my settings?
I read something about NTFS, but my PC's drive is not set up with that. Is NTFS something that I need or is there hopefully another solution?