i have an access database which iv'e designed for my 'client' (ok, he's my friend) and now i'm also in the process of designing a website for his company - so his customers can log on and see their order status.
what's the best (and most secure) way to update the site - we don't host the site - it's hosted by someone else.
i'm totally at loss with this - since iv'e never worked with networks or servers and i just want someone to point me in the right direction. i don't want to get lock errors and the like.
iv'e heard a bit about ADO and i know some of the syntax although i'm not really sure how it applies to me here (i'm not exactly exposed to ADO since iv'e been learning asp.net 2.0 from which i understand, has totally eliminated ADO)
I have a client that wants a web form to send credit card information and other personal information to an email address. (such as name@aol.com) Now I am uncertain on how to do this. I know SSL must be involve, but what is the process with this and how to use it with ASP ? How do you use SSL with ASP .
I am building a small Web app that will allow end users to visit a Web page, click a button which will in turn execute a batch file on the Web server which will migrate code from the development environment to QA. The Web app will also capture logins and execution requests, and the batch file currently emails the robocopy log to me. In researching ways to get the ASP page to execute the batch file, I came across ASPExec from Server Objects - http://www.serverobjects.com/products.htm#free. It seemed straightforward enough, however I have not been able to get the permissions in sync for it to work.
I have just figured out how to use the global.asa file to track sessions on my site. However it relies on users logging off correctly. Is there no way that I can know that the user has closed the browser WITHOUT logging off my site? I am finding users registered as being logged in when they may not be Could anyone show me some code that I could put in Session_OnEnd that would clean up my database table of active users? Say if a user has been in-active for 60 minutes, clean him out. I have tried to do this but it hasn't worked. I cannot seem to connect to my access db from the global.asa file!
What difference does it make?I am building a table whose number of rows keep changing When i use the second method the space above my table keeps increasing.I just want to know which method is better..I had posted a similiar question....I'm still trying to figure out.
I'm currently working on a survey system that allowes users take the survey and then review/change their answeres in any order. The system uses 3 frame (Header,Body,Footer).
As it stands the system uses 3 sessions to get this done. One for the project they are in, one for the step they are in and one for their answers.
My question is at what point do I end up over whealming the system with sessions? I truly do not want to slow the system down that much. how I could optimize the usage of this?
Is there a way to use a Session Variable to prevent the successful resubmission of a form if the user uses the Back button and tries to submit it again?
Hi's there any concerns or disadvantages of using alot of respose write's (50) in a ASP page for calculations and is it better than using the recordsets to do the calculations?
Also, we are looking at moving to a secure server, will this cause any problems apart from changing all references to https?
Can anyone point me in the right direction for dealing with a dynamically created table of shopping cart items? Each row (or Item) has a column where the user can change the quantity. Is there an easy way to grab and use these changed values when they hit the form submit button?
Or, do I need to bite the bullet and write code that filters through the form fields named "quantity1," "quantity2," "quantity3," etc... And then determine which one goes with which cart item?
I have a problem with our web servers and memory etc.
We have one application pool with a few websites in it and the w3wp.exe is consuming about 800 mb memory now. First we had a rule for recycling the application every x minutes or when it's using more than 600 mb memory but when the recycle is activated the w3wc.exe process hangs and the cpu usage goes to 100% until we execute an iisreset.exe.
That's the reason why we disabled all the recycling options and configured only one worker process for that application. All the websites in the application pool use the same code, only they have a different skin. The website also uses xml/xsl transformations.
Is it normal for an application to push the w3wc.exe process to about 1GB??? If this is the case i really want to know how much memory dedicated hosting companies need in their webservers :-)
We are storing some information in the application cache, but this is only for the entire website and not per user... in plain text so the amount of data would be no greater than 100KB at most.
The application is in classic ASP. We walked thru the entire code and checked for correctly closing all sql recordsets, email components etc etc etc...
What is the best approach to find out what is using so much memory and why the recycle does not work correctly?
I have 4 ASP pages where an user can update some fields and submit the page, so that the fields are updated in the Database(Sqlserver), I need to handle one situation.
1) At a time I need to allow only one user to update the details in a page.
2) I need to stop other users who are trying to access the same page concurrently(probably with a message or Redirecting to other page where he can see the details in a report format).
3) Session timeout in my application is 60, So if the first user leaves the page open for a long time , I think it would be a problem....the other session has to wait for a long time. I have no choice in decreasing the session timeout interval.
I am in the process of writing a simple web server monitor (ASP.Net with VB.Net). One piece of useful information for me to gather would be the amount of memory used by objects stored in the cache, since objects are thrown in there left and right.
Items in the cache are either custom objects or are Hashtables. How can I get the memory size of these objects.
Marshal.SizeOf(object) does not work in this case because .Net cannot Marshal Managed objects. I thought that I might be able to pull out the component items in each object and build the total size from their aggregate sizes, however that would require me to determine each objects type so that I can correctly gather size info from the internal attributes, something that I do not want to do.
Is there a generic way to either:
1) get the size of Managed Objects
2) convert Managed Objects into Unmanaged Objects that can be marshaled?
OR
3) some other way to get memory sizes of cached objects
I am trying to get a thorough understanding of a code where a addition or deletion of records can be done from a list of records. For addition part of the form, data is being obtained from set of input boxes. Code:
When using cookies in classic asp, is it safe to assume that using a comma delimited list of values in one cookie is much more efficient than using multiple cookies? (example below)
Response.Cookies("someCookie") = "101,102,103,104,105,106" If InStr(Request.Cookies("someCookie"),"103") 0 Then.......
I have just started using ASP, I am normaly using PHP but I thought ASP might be a good road to go down. I am having a few problems, I am trying to limit the number of records I take out the database but I keep getting errors.
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09) Cannot update. Database or object is read-only. /SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
I'm current working on a project which need to upload local data to live server database.
Meanings that, i'm current having a server in my local mechine. I need upload data from local database to live database which host at oversea company. But i really have no idea how to do this in asp.
i wrote a shopping cart using cookies found out thatIE 7 won't let me add more cookies after a certian number. decided to use DB along with cookies and now i have very weired problem never encountered before Code:
With regardst the above many-to-many relationship:
Is there any advantage in creating seperate access databases for:
- Customer - Products
....Rather than keeping them as three tables in one database.
The reason I ask is that I have found that if I am using a ftp approach to overwriting or updating the remote database there are sometimes problems with synchronizing data .....This seems to be a better solution?
does any one know a simple free database driven website tutorial that i could learn? i need it for when someone searches a name ionformation on that name comes up along with photographs realating to them.
I have built several websites before but none are database driven so is there any dummy proof versions?
I have a Access DB with two tables (Users and tblpersons). Users are stored in table Users and their records in tblpersons. They are able to login, Enter, Search, Update their data.
I want users to be able to Enter and update only their data not other users data.
Example:User_Id 1 when logged in, is able to enter data for any user(1,2,3......) and able to modify their data.
I can make a simple database file and name it database.mdb, all I need to do is name a single field email and save it. But I dont know how to make it so that my page will become active and the emails submitted will be saved either to the mdb file or a text file, im not sure what goes on there.
They are on Windows 2000 IIS 5.0 and currently have an older version of their job database using Access hosted on a Brinkster server. The new server that they are on, when I contacted the host, they advised me against creating any new applications using Access, as the server is not meant for multi-users. So, I am thinking that they need to get their host to upgrade to a SQL database and have the job database developed using that. My question to this forum is: What do you think is the best combination for improvement here, SQL or MySQL or what, considering that their site is using asp and hosted on Win2000 IIS 5.0? Also, any recommendations on scripts that might be already available that could be customised to their site?
What we have is our own (in house) Windows 2000 Server which runs MS SQL for our data storage and we have writen our own VB6.0 Application which runs of the SQL DB to manange our stock, ordering, price's etc etc. Also we have our own Website with a Web Hosting Company which is also a Windows 2000 Server but can only Run access databases. What we what to do is somehow have the Access database and the SQL database sync together to have some of the same data in both database's. But I don't know where to start.
I have the following code to execute a SQL query.Code:
SQL = "INSERT INTO teams (`teama`, `teamb`, `pot`, `winner`, `finished`, `start`) VALUES ('" & teama & "', '" & teamb & "', 0, '', False, '" & gdate & "')" teamrs.Open SQL, conn all works fine. I just want to know what result it gives.because once i add it, the form submits, and its a blank page. I want it so it does this Code:
if sql = worked redirect else error end if so how can i make sure the query was executed successfully.
This is probably a stupid question (I'm good at those)... I would like to enable a user to be able to browse to a picture on their local machine and upload that picture to a remote directory where it can then be displayed along with it's other pertinent data. I thought it might be a good idea to use Front Page's "file upload" feature which includes a "browse" button and prompts me for a storing location - but I can't get it to work and am not even sure if that's its intended purpose. So my question is two-part, what should my insert or update page look like regarding an upload process, and then how would I link to or display that picture?
I have some questions in a database, i showed in the web page, for each questions i gave 3 (Yes, No, Not Applicable) options via select - option. when i get the variable with select name, it is showing with comma.
Example : If they select for like that
Ist question - Yes
IInd question - No
IIIrd question - Yes
IVth question - Not applicable
The variable is coming like (Yes, No, Yes, Not applicable)
