I have a database which inputs usernames, passwords, and email addresses into the database. I'm trying to create an asp page that lists the data for a specific user when they are logged in so that they can change details (password, email address etc) any ideas how i can retrieve the data and append the new data to the database???
View RepliesI am trying to run and UPDATE, INSERT and DELETE SQL statements to update append and delete data from some tables in access. Here is the low down:
I want to update All of the fields from a table called TEMP into a table called POSTPONED, WHERE the 'postponed' fields = "False"
I want to then go on and clear the records from TEMP that have the field postponed = "false"
And finally i want to again append the remaining data in the TEMP folder into a table called RESULTS.
Does any one know how to do this or what the SQL statements should look like, i have tried writting them, no luck, i have tried generating them in Access but no luck because the ASP is erroring me on them and i dont know what its chatting about!
I am planning to design a database (destined for the web) that will have
between 20000 and 45000 records in it and will receive a lot of reads but
very very few writes (just from me).
Now the question is should I use:
1) The combination of Access 2000 (accessible through ASP or ASP.NET) using
OLEDB Jet
or
2) SQL Server 2000 ?
Of course I know that the SQL Server option is a better one, especially
since it's said that an Access DB can have about 9 users or so accessing it
at the same time. But is that a general rule or is it about many people
writing to the DB? In other words, if an Access DB has hardly any writes
and 99.9% reads can it be used as efficiently as it would be used on SQL
Server 2000?
I have a Development server that is running Win2k, IIS 5.0, and ASP enabled. I am trying to gain access to an Access 2000 DB located on a file server within my domain. I'm pretty sure I have all the correct permissions set, but I am having problems when trying to access the DB.
The error is similar to:
The Microsoft Jet Database engine cannot open the file '******'. It is already opened exclusively by another user, or you need permission to view its data.
I'm looking for ways to fix this... Microsoft suggests turning off the ability for IIS to sync passwords. Unfortunately, this is not a viable solution for me.
Is it possible to create a new virtual server that is a share to my file server? Put my ASP and MDB file in there and have it work? Anyone have any other ideas?
Does anyone know of a simple (and I stress simple as I'm a beginner with this asp stuff!!) script to allow for basic functionality of Add/Edit/Update/Delete ASP page which works with an Access 200 mdb. Something I may easily adapt for what I have??
I'm running Windows 2000 Professional with IIS 5.0.
What would I have to change in my code to make it work with sql, Just wanna see if its worth changeing to.
View Replies View RelatedI have created an Access database with an Autonumber field and set as promary Key. When I insert a record from my ASP web page it insists on making me add a value to this field.
Is there anyway to set this as an IDENTITY field.
I have an XML file that gets updated every 4 hours on a web server. I can check the XML modification time in ASP and compare to the databse. If it is newer, I need some ASP code to then import the XML into Access. Been trawling the net for an answer for a while .
View Replies View RelatedOur graphic designer is developing our new company website. We have switched
providers and currently she is working on the new website which currently
ressides on the new providers server as they support the ASP development
environment. Their server is a Win2K3 server.
She is writing an ASP module to connect to an MS Access 2000 database and is
having problems connecting. In this database there is only one table.
She has tried many different connection strings all to no avail and then
found from investigating that the best and fastest method is to use the OLE
connection string. However, each time she runs the ASP code she gets the
following error... Code:
what I want to be able to do it take data from one of my Access 2000 queries and automatically export that to an XML file. then that XML file is going to be loaded with Google Maps API for use. What options do I have in exporting the data in access automatically? would it be just implemented everytime i call the function, lets say an ASP page?
to give a little more (hopefully helpful) information, I want users to go to my site which has the Google Maps API implemented, and it will show them the rainfall and lake level data in my area. I figured XML would be best as I have seen someone implement a similar design in Canada using an XML file, however, I need to be able to get the
information from the query in Access so it can be loaded onto the map for people to see recent data. Again, I'm guessing ASP would be the best bet in accessing the data from the database.
I'm using sql server 2000 database and trying to access it using asp. when i installed sql server, i selected the mixed mode of authentication(windows and sql server). Code:
View Replies View Relateddoes anyone know of a free utility that allows you to alter/create tables through the web for access 2000. I'm talking about the table/db structure, not creating records.
View Replies View RelatedCould someone highlight any known problems in converting an access 2000 to
access 2002 database....should I expect a painful transition or can I expect
a quick turnaround time to get my existing 2000 apps into 2002 format?
I have a page which works fine testing locally on my win XP PC, using an access database file. When I place it on the server (all code and database file being the same)... it gives an SQL error :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2
The SQL statement is as follows: Code:
I have been doing adodb connections and using Access2000 for several lightweight websites. I have never had any problem with any of the SQL commands to insert, update, delete, etc.
I can insert a record into a memo field just fine ... up to a certain number of characters (nowhere near the 65K limit). After several hundred characters, the insert fails ... nothing happens ... the execute just idles and no insert is done. Anyone help? I have read about data types, etc., but everything I read sounds as if ASP and Access 2000 are suppose to handle the type conversions. They have been doing it up to this certain size.
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DRIVER={SQL Server}; Server=;Database=pubs;Uid=myUsername;Pwd=myPasswor d;"
Instead of database, how can I set the DSN in this connection string?
DSN is DSNName. I am trying to connect to a SQL Server 2000 database.
I want to open a text file for appending purpose but it gives me the following error..
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument
/cgi-bin/Anagram_Utils/welcome_letter/generatedoc.asp, line 19
Code: ......
I need to dynamically append a session variable to a querystring to every link on our site. Is this possible in ASP?
View Replies View RelatedI need to take a bunch of PDFs that I have made using Appligent's FDFMerge and append them together. I know I could use Appligent's AppendPDF. But I was wondering if there were any free toolkits that I could use with a bit more work out there?
I cannot tell what on the Adobe site would be a candidate for me to even look at. The Acrobat SDK seems to be for Acrobat Reader plugins. Not what I am going for. The PDF library seems a candidate, but what *is* it? A C library? I cannot use a C library unless it has a COM wrapper.
I have one 3 tier architecture application running on Windows 2000 Server.
I have created replica of same machine on another machine where OS is
Windows 2000 Advance Server.
But when I port same running application on new machine i.e. Machine with OS
as Windows 2000 Advance Server, my middle tier (Active-X Dll, COM+
application) fails.
It throws common error
Invalid Procedure Call or argument
What could be the problem? Do I need to change any settings for running
application on Windows 2000 advance Server.
Is it possible to find, and display a pc name in an asp web page using vb.
I'm trying to get a very simple task to work. Using the users login name
(gained from IE) I want to get their full name from AD (Win 2k and 2003 AD
domain).I'm using this ASP code on the IIS server:
usr=mid(request.ServerVariables("LOGON_USER"),8)
Set User = GetObject("WinNT://domainname/" & usr & ",user")
response.write "Name is " & User.Fullname
set usr=nothing
This code works fine when run on the server direct using wscript, but when
served by the web server I get the error:
Active Directory (0x80070005)
General access denied error
I have a working members code now where members can sign up, login to a protected page and log out. I now want to personalise each members login so when a member logs in it says welcome [username] etc and then when the use logs out it says 'thanks [username] you have logged out'. I tried to query my database but it doesnt work.
View Replies View RelatedIs there a script ( without DB) I can use which can give the entire details of the server, including the root dir, folders info.
View Replies View Relatedhow I can repeat details in a ASP page. For example I have to fill in a a form which has the following quetion.Language : (a text box here to fill in the details)
and then a message with 2 buttons Do you want to insert another? YES NOWhen click on the button YES, I want my asp page to take the quetion "Language :" and the text box and copy it so the user can insert another value.How can I do it ??
Is there a way of detecting and then recording a visitors details(eg. browser, ip, country, OS...) and then storing that info to a database automatically?If, so, could you plz tell me how to record the info straight to a database without the user having to click on anything.
View Replies View RelatedI have seen an example of a page that displays the users browser details in a friendly manner like this:
Your operating system : Microsoft Windows NT
Your browser : Microsoft Internet Explorer 6.0
from a HTTP_User_Agent string like this: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) Can somebody give me some sample code of how I can extract this result out of the string, using asp.
I have a list of requests that I'm displaying. The client wants to be able
to display the details of the FIRST request as the page loads.
Right now, as I loop through the recordset, I'm checking the querystring for
"rid", and if rid = "" then I do a response.redirect to the page adding the
rid value to the querystring from the recordset.
I'm thinking this is not very effecient, but I can't figure out anything
better.. anyone have a good solution to show the details of the first item
on the list?
I am looking to create an upload page for my website. I would like to have the user login and depending on who they log in as depends on which folder they upload to. I'd like to be able to upload multiple files, have the file size(s) show up on the form and also be able to calculate how much time it will take to upload the file.
View Replies View RelatedIs it possible to run an asp script to display the details (i.e. last
modifed time/date) of several files held on the client and or on the server
running IIS (if i map it to the folder with the files in question).
im trying to work out basicly what i want to do his have a list of downloads and then at the top of the page have a form that has contact details that enables the download links and sends the details to an email address. is this possible and if so are there any scripts avaliable
View Replies View RelatedI'm trying to build a details page that is reachable when a user clicks on the ID of a query that's returned multiple rows of data. The first piece of code is the querytest.asp page, and the second is the details.asp page. However, how do I get the user_id passed to the details page? Code:
View Replies View RelatedThe code below takes the script name of a page (which is always an asp file) and substitutes the asp extension with html and then inserts the file in the <frame> tag.
This code works file for a url such as www.somesite.com/file.asp But if the url includes an index eg www.somesite.com/file.asp#position1 how do I get the #position1 added to the file name that is used in the <frame> tag? Is there a server variable for # info? Code: