File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes XML and Related Technologies and the fly likes dynamic data updation-XML ms ACCESS-ASP-IIS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "dynamic data updation-XML ms ACCESS-ASP-IIS" Watch "dynamic data updation-XML ms ACCESS-ASP-IIS" New topic

dynamic data updation-XML ms ACCESS-ASP-IIS

sathya murthy

Joined: Jun 27, 2005
Posts: 3
i am having a database named "personaldb.mdb" which contains a table named "personnaldetails" in ms access and i could retrive the data as an xml file by using ASP+IIS combination. if i do changes in the table it reflects sometimes in xml file and sometimes if i refresh i wont get the updated data even if i delete all temporary internet files...
how to run the same ASP file in tomcat 5.0.?
thanks in advance...
here is my ASP file:

<%@ Language=VBScript %>
<?xml version="1.0"?>
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "D:\asp\personaldb.mdb"
Set Tape = Conn.Execute("select * from personaldetails")
Do While Not Tape.EOF
<% Tape.MoveNext

my XML output is:

<?xml version="1.0" ?>
<name>Sathya moorthy</name>
I agree. Here's the link:
subject: dynamic data updation-XML ms ACCESS-ASP-IIS
It's not a secret anymore!