<%'Response.ContentType="text/xml"'above for debuggerydim conn'setting dbase parameters for select only userset conn = server.CreateObject("adodb.connection")'following is for localhostconn.open "DSN=sde;uid=sde_greg;pwd=chmod666"'following is for Wanda'conn.open "DSN=CONTENT;Trusted_Connection=yes"dim scrname,fname,sql,rs,hhead,hbody,rcopy1,rcopy2,rcopy3,lcopy1,lcopy2,lcopy3,bcopy1,bcopy2,metIDmetID = request.querystring("metID")sID = request.querystring("sID")sql = "select Xml from sde.GDB_Usermetadata where name ='" & metID & "' "set rs = server.createobject("adodb.recordset")rs.open sql,connif not rs.eof and not rs.bof thenrs.movefirst'Response.binarywrite rs("Xml")sourceFile = rs("Xml")'Response.binarywrite sourceFile'styleFile = Server.MapPath("sos.xsl")if sID = "f" then styleFile = Server.MapPath("fgdc.xsl")else styleFile = Server.MapPath("sosplay.xsl")end if'response.write styleFile'response.endset source = Server.CreateObject("Microsoft.XMLDOM")source.async = falsesource.load(sourceFile)set style = Server.CreateObject("Microsoft.XMLDOM")style.async = falsestyle.load(styleFile)Response.Write(source.transformNode(style))else response.write "Sorry, no metadata has been created for this data layer."end if%>