Coder Circle

XML and Database

XML interaction with multiple database. Here we have taken two databases - Oracle (Remote) and Access (Local)

<% @Language=VBScript %

<?xml version=’1.0′?>

<?xml-stylesheet type=”text/xsl” href=”Fstyle1.xsl”?>

<people>

<%

set con=server.CreateObject(”adodb.connection”)

con.Open “dsn=asu;uid=asu;pwd=asu”

set rs = server.CreateObject(”adodb.recordset”)

set rs = server.Execute(”Select *From Emp”)

%>

<student>

<name><%=rs(0)%></name>

<roll><%=rs(1)%></roll>

</student>

<%

rs.Movenext

loop

%>

</people>
 

Leave a Comment