Im writing a script that has a lot of "nested" IF statements - it breaks a complicated situation down through a sort of logic system, and when it reaches the end of the tree it performs a certain task - in this case, it writes a row of data into a table.
Its very annoying that the IF statements work exactly as I want/expect them to...but when it gets to the end of the tree of IF's I get the following error: Code:
Error Type: (0x80020009) Exception occurred. /diary.asp, line 53
The specific part that causes the exception is when I try to access rsAppsTemp("AppointmentDate") in the While loop. For some reason it works fine in the If statement above it, but not in the While loop.
I got these error when I try to open an excel file on a Windows 2003 server, It works perfect on XP, 2000 and on my Windows 2003 server (test server) but not on my online Windows 2003 server. I have tried "on error resume next" but I got the same error!
i 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????
I am developing a small website using ASP scripts to format data retrieved from an Access database. It will run on a Windows 2003 server supporting FrontPage extensions 2002 hosted by the company 1&1 with only limited server configuration via a web based control panel.
My query relates to the ASP security model and how it relates to FrontPage options for setting file access on a database file. If you know of any online documentation covering the following issues I would be grateful for links to it.
For various reasons (session logging, synchronising data with a master database etc) I need to be able to write data to the database file. Essentially the problem is this: how do I make this possible without giving public access to the database file? Code:
Is it possiable via a ASP to set (NTFS) permissions on files not on the IIS server?I'm sticking together an ASP to create our new user Home/Profile dir file structure. The script is running in anonymous user mode using an account which has full perm on the file severers.
It's creating the file structure OK, but when it comes to the file permissions, CALCS direct or CACLS in a .CMD doesn't appear to be able to set ther permissions when invoked from the ASP. It does however work for the user when logged on the server's local console.
I'm trying to write a script that will allow validated users to download a file that has specific ntfs permissions. Here's a summary:
Scenario: 1) The name of the file is "binary.zip". 2) I've created a local account on the server called "dl_user". 3) dl_user is the only account that has permissions on binary.zip. 4) I've written a script that validates several people to access a web page that has a link to binary.zip. However whenever they click it, they get prompted for a username and pw. If they enter the "dl_user" credentials, it works.
Problem: I don't want these people to be prompted for the username and pw. Instead, I'd like IIS, through some ASP mechanism, to pass the dl_user credentials in the background so that the users are completely unaware of the account that has NTFS permissions to the file. Is there any way to do this?
I am trying to use this bit of code to change the permissions on a file. Apparently it should work but it isn't. I am getting no error messages just nothing is happening. The path to the file is definitley correct. Does anyone have any idea what I am doing wrong? Code: <% strFileOrFolder = "D:WebRoothtdocsProjects est.txt" strUserName = "Everyone"
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 have a page that allows someone to upload an image, and then the image is displayed on another page. Unfortunately, When the permissions are set to allow the photo to be uploaded, it won't allow it to display on the other page. When I change the permissions so that you can't upload an image, it will display on the other page. The page in question is http://www.atlantatoysfortots.com/Pictures.asp I'm at a complete loss. Is there anyone out there that knows enough to make this stupid thing work? I have checked every page and they are good....site is hosted on GoDaddy.
I am trying to do a real simple bit of code here but i cant see where i am going wrong. I am trying to pull some titles out of the database and when i have 5 i want it to stop.
Well it is giving me an Exception Occured error. I have checked that the query is valid SQL, and i have also restructured my Do While Loop so to test the data is being pulled from the db and it is fine.
Could some one please have a look at this for me as i don't really understand what is happening. The commented out part at the bottom is the code that i used to test that something could be extracted from the Database. Code:
I'm getting an '80020009 exception occurred' error for some reason, even though I know that there is a corresponding record in the database. This happens on some records but not most. Any ideas? Code:
In the SQL select statement I need to compare with another field. This, another, field is sitting in the stored procedure. I have to call to the stored procedure to get this field…So I can do the comparison.
I have a table inside access DB built like a tree, every record(=node) is a "title" that has a 'name' and 'paret' fields (and some other fields that are not relevant). I'm simpley trying to print out all the tree's records but I keep getting only a path from the root record to the first leaf.
I have a recursive sub called 'deleteTitles' that needs to perform this task. The var 'currentTitle' is the root node.
On every iteration of the sub I print one son of the current node 'T'. I'll be glad to give more information... Code:
I'm trying to delete a tree in my DB using a recursive function. The tree nodes are "T" (titles) The tree root is currentT, on the first call to the function. I get the error above.
I 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.
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.
I 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?