I have been working on this form for a couple of weeks already but I keep running into errors after errors. Can someone try to test it on their computer and see if it works? My guess is that our server's setting is causing all these problems. All the files are uploaded.
View RepliesFor some reason these errors have just appeared out of nowhere. Everytime I try to add, delete or update, I'm getting the following errors for both dns and dns-less connections:
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query. etc
I have checked the read and write permissions and they seem to be fine, as well as with the locations of the databases that are in inetpub/wwwroot. Anyone know of anything else I can do to solve this?
When simultaneous requests to open an Access Database occur, the Jet Database engine returns an error stating: Cannot Open file, already in use.
I know this occurs because I'm using a file-based Access database, and it's locked while data access is taking place. However, at this time, its the only platform available on the site.
My question is, can I somehow use an On Error GoTo Blah statement to catch the error, clear it, and then attempt the ADODB.Connection.Open statement again?
Right now I think I've got the idea on how to work on ASP pages after such a hectic start, then I 've got a small problem . i have contructed my form but i can't seem to add to the dbase, i can fill the info but i see nothing on my dbase.
View Replies View RelatedI am trying to run a script that will add users to a database so they can register with the site. ive got it working so that the users are added however i am trying to prevent people from registering the same username or email address and this is not working.
the script firstly checks that the user has filled out all the fields in the form from the previous page then the script is supposed to check the database for the username and email then adds the user if it is all ok however if the fields have all been filled out it simply adds the users anyway. here is one of the check scripts i am using VBscript and an access database .....
I am trying to add entries in a database together and place the summed value into a text box. Like a total ordered type function for an ecommerce site. I have a field called ArmChairs in my database and based on how many people buy them, I want to know how many I need to have shipped.
I am really struggling with this last bit and would be really appreciative if someone has some code examples.
i cant add a record to my access database! i think the code is right which i used asp script but then only blank record was added! It added a record but then no data in it! Code:
View Replies View RelatedThis code has worked in the past on this same page, and for some reason it doesn't want to calculate the numbers anymore. Anyone see anything that is out of whack?
Basically I am taking the input numbers for each field and adding them up on one column, then taking the totals of all of those columns and adding it up to display as an overall total. Code:
I'm trying to add a record to an access database using asp. I create the database, the input form where i put the information, the asp code where i process the information and last the asp code to view the record added but when i press the submit button it show me a Downloading box for a downloaing process.
View Replies View RelatedI am trying to make a guestbook, wich should be accessable through a executable exe. I think, the easyest way to do this, is through your browser. I am looking how to add text to a database without entering text in a form, but only text in the address bar of your browser.
View Replies View RelatedI am trying to write a basic holiday booking system for the company I work for, it is quite simple in that the user selects the dates they want off work, and they can view if it has been approved or not. It has an admin screen so that the manager can go in and approve the holiday request.
To do this I would like the admin screen to display all the dates in the database that the user has selected off and to have a checkbox next to each that the manager can select to approve it. However I don't know how I would do this, at present all it does is read the info in the database. Code:
how to accept ' or apostrophe when adding on the database? because I created a simple guestbook and when i tested it it works fine but once i add apostrophe like TOY'S etc it generates error.
View Replies View RelatedExcept for extremely basic ASP programming that I did two years ago and have forgotten I have not touched coding since!
I've taken a look at a couple of tutorials but they all baffle me!
Can anyone tell me how I can just create a simple html form with input fields of FirstName, LastName, Email and Phone amd when the user hits submit it is recorded in an access database?
I can do the HTML part fine. And I believe I've set up access ok although Ive never used it before.
Also, if the server that the database will go on is a Microsoft one i suspect that is ok? Im not sure if all i have to do is upload the database and it will work? or do i need to talk to my hosting company to set up some kind of odbc thing that ive heard about?
My database will just be called clients.mdb and the table is called Customers.
Basically i have a form on a HTML page which someone fills out with a few IDs, then i have a .asp file which is meant to add the info to a database.
However it just wont work, the field names in the database are correct. - i hope the if statement is correct too. Code:
I have an array which I want to save into a database table I tried a few things but it doesn't work. This is as far as I got: Code:
View Replies View RelatedI want to add a row to library table. Table has total 7 fields. But I
want to create the new row with 5 field data. When I run the following query
in MS Access
strQ = "INSERT into library (index,title,author,itemtype,createdate) VALUES
('B-096','Hihihihihi','hello','Book','07/18/04')"
It successfully adds the row. But same thing I am trying with the following
ASP code. It gives error, saying syntax error in INSERT into statement. Code:
actually, I have a problem while i want to add, delete, or edit a record to a database through a asp page, I can read well but when i want to submit changes using rds object , the data does not change on the source database,
I tried hard to get a solution but i think that the actual problem is only on one figure which is the server value of the data control when i use my own iis server, I do not know this value and microsoft is saying use an empty value but it does not work either.
Let's say I have a dynamic list/menu, which gets its values from a
database table, for example a list of contact people where the value is
an ID number and the label is the name. However, if the value the user
wants is not in the list I would like to place a hyperlink which
will...
(1) open a small window, with an ASP form to allow the user to add a
new entry
(2) save the entry to the database
(3) add that value to the list/menu in the parent window and make it
the selected option
(4) close the small window and return to the original window.
I can handle the code for 1,2 and 4, but 3 is what I'm not sure about.
I don't like the idea of forcing the user to leave the current screen,
go to some other form, add the entry they need to the lookup table,
then come back; this seems like a logical approach, but just wondering
how to make it work.
This seems like a common enough situation; anyone have any code samples
or suggestions about how to do this?
I am trying to configure apache::asp on apache2 and when i try to serve an asp page I get an internal server error. I get this in the error logs
66.249.65.228 - - [10/Jan/2008:12:57:57 -0500] "GET /asp/includes/functions.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:58:38 -0500] "GET /asp/includes/feed.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:59:06 -0500] "GET /asp/includes/contactField.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:59:19 -0500] "GET /asp/includes/encryption.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:59:33 -0500] "GET /asp/includes/LogonEdit.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:59:47 -0500] "GET /asp/includes/header.asp HTTP/1.1" 500 603
We've been expriencing periodic database connection errors with ASP code
talking to an MS Access database. Every once in a while, the code can't
connect to the database.
Usually there are no log entries that might point
to difficulties, but early this morning the Application Log was filled with
the 2 errors below. Once we did an IISRESET, the problem cleared. Does IIS
need to be re-installed, or??
Since upgrading to Windows 2003 Server from Windows 2000
Enterprise Server we have had alot of ASP problems. The
problems are centered around asp pages which are one level
or more below the main folder within a web site. We have
many web sites which have used the database interface
wizard in FrontPage which puts these pages up to three
levels deep inside the folder hierarchy of the main site.
The pages will not work with IIS 6. I have had to re-
engineer many of these sites without the database
interface wizard. My solution at this point is to put all
ASP pages at the root level which seems to work but
negates all version of Frontpage management including
FrontPage 2003 Beta. This is a serious problem!
Especially for us who teach FrontPage and ASP!
first, in NS (version 3, don't ask), get a
Code:
HTTP Error 400
400 Bad Request
Due to malformed syntax, the request could not be understood
what's that?
second, how do you turn the pop-up error alert window in IE for Mac off so that we can see the error in the browser window?
just for the record, the app works in windows fine, seems to have troubles on the Mac side.
I have a classic ASP application that runs fine on IIS on win 2000 or IIS on XP. But recently a client installed it on Win 2003 and now consistently gets an Internet Explorer-side error:' syntax error line. char 1' when he browses to it with IE 6.0.
When client moved the whole app as-is to an XP machine and then browsed to
it, he had no problem. I suspect the error involves client-side javascript. Iam looking into it; in the meantime:Are there a known issues of this kind involving IE 6.0 and windows 2003?
I recently finished a project for someone and they are getting 500 errors. What's driving me nuts is the application works fine from my location. All I can think is it could be a firewall issue but I've messed with my firewall and I can't reproduce the error.
What's ever more annoying is they are getting this error from more than one location. I don't see anything that would cause this. This is an admin application that uses Session and adds/updates an access DB. Works fine here.
Before we upgraded our intranet server to Windows 2000, when I had an ASP error the page used to load up to the point where it was crashing out and then I would get an error message. This allowed me to response.write values to find out where the error was happening.
Since we upgraded, all I get now is a 'page cannot be displayed' with the error message on it. This means that I can't response.write values anymore and makes debugging a lot more difficult.
Is there a setting somewhere that controls how the message is displayed? Is this in IIS or is it a browser issue?
I'm afraid I have a technical problem here. Basically what happens is that I'm getting some random errors(like Type mismatch... etc) that shouldn't under normal circumstances occur. Then I connect to my server via remote desktop and Recycle the application pool on which my asp pages run. Errors then disappear
View Replies View RelatedAll across my site i am getting 0x80020009 errors every so often.
they point to lines of code like
where FolderNAMEIN is a string such as "Botswana" and the
VarFolderNameLength is 150
if len(FolderNAMEIN) > VarFolderNameLength then
and
RS("Company") where Company is a valid field in the database.
I've get a problem in browsing .aspx pages locally.
I'm using Windows 2000 Advanced Server with IIS enabled
and .NET framework SDK installed, as well as Visual
Studio.NET.
But when I browse .aspx pages locally, I.E. shows "Server
Application Unavailable" message. In the Event log, I find
error event of ASP.NET 1.0.3705.0 with the description :
aspnet_wp.exe could not be launched because the username
and/or password supplied in the processModel section of
the config file are invalid.
I have written a script on an include page which pretty much will write all the required ServerVariables and session variables into a string and email off to me incase a page happens to error out.
I have the code working as I want it to using the folllowing:
If Err.Number = <> 0 Then
'RUN INCLUDE
End If
My issue is, where do I include this on the pages? If I put it at the top will it only run if there is an error at the start of the page or will it be assigned no matter how far down the page the error exists.
Or do I need to put in On Error Resume Next at the top then put the include at the bottom?
example,
I have 3 drop down boxes n a page.
1st box contains all countries,
2nd box contains all locations in that country selected from the 1st box
3rd box contains all items at that particular location selected from the 2nd box
Despite trying the codes given, I am still not getting it right!
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xf14 Thread 0x4a4 DBC 0x10bbfcc Jet'.
/sanbookshop/searchtest.asp, line 22
I am trying to write a search script in my spare time at work. We have a knowledge base consisting of 200+ .mht files. My script was working ok when I was testing it on just a few files but I am getting out of memory errors trying to search through the whole KB. Here is the search code:
View Replies View Related3 workstations previously installed and able to access server.
4th workstation am able to map to server access files but when
attempting to log in receive the following error.
EXTERNAL DATABASE OPEN FAILURE
Error: -2147467259[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL
Server does not exist.
The workstation that is unable to connect is running XP SP2, MDAC 2.7..
the difference btwn this and the others is that it is running wireless.
Ruled out wirelss as being the problem because hooked LAN cable and
receive the same error. Code: