I have been tasked to manage an internal support web based system currently connecting to a local web server based MDB. I want to move this backend to a SQL DB on another server and use that instead as i plan on this support system growing fairly large, also trying to standardise on DB locations. Code:
View RepliesI am loading up a site for my boss to look through, I want to put it in my templates folder so they can surf it just like they would if it was loaded in the www page. The problem I am having is with my asp pages interaction with my database. I put my database in a folder called test in my templates folder (/templates/test/db)Now when I run the query I get this back:
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/templates/insertit.asp, line 22
I checked the folder and it is rw-rw-rw.
If I load this page is the www folder and adjust the map path it works excellent. Does anyone know what could be wrong? Here is my code:
I suspect this is a rather easy one however. I recently moved a web site developed by MS Front Page and a SQL Server database to a different computer. Now when I "Submit" field data, it no longer populates the database.
I've checked the main index.asp file and the global.asa file to find out how to repoint the form to the database and I can't figure it out. Can anyone give me any pointers?
I Have a form, and in that form I have a check box, I wish to say " If Checkbox is checked Then variable = true Else Variable = false". Here is what I have as far as code goes...
Thus far the variable is always false, leading me to believe that my syntax is wrong. All the SQL part of this is tested as working (Included to give a perspective on what I am trying to do) so you can for the most part ignore it. It is the form part that has a problem. Code:
I got a new server with Windows 2003 on. I moved a site that works fine from a Windows 2000 server. On many pages i get a convertion like this:
|Microsoft VBScript runtime error '800a000d'
|Type mismatch
|
|/test/test.asp, line 3
|
This is the code that i run to get the error:
|<%
| a = 1
| if a = 1 then response.write("a = 1")
|%>
|
It does work if i add "if cint(a) = 1 then...." but is it a way to make IIS6/ASP don't check the code so critical?
I'm having a problem whenever i enter 2 response.redirects() in one funcion.. it's weird. What i'm trying to do is to display a simple error message underneath a login. But i'm trying to do it by sending the user back to the SAME page (not sure if that's even possible!) and passing a variable, notLogged, to test against. I hope this makes sense! Code:
View Replies View Related