By admin | January 25, 2008
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>
Loading ...