Don't rubbish my code but it works fine. It was written in FrontPage.
<!--mstheme-->
<!-- #include virtual="session.asp" --><!--webbot bot="Navigation" S-Type="banner" S-Orientation="horizontal" S-Rendering="graphics" startspan -->
<!--webbot bot="Navigation" i-checksum="420" endspan -->
<!--webbot bot="Navigation" S-Orientation="horizontal" S-Rendering="graphics" S-Type="siblings" B-Include-Home="FALSE" B-Include-Up="TRUE" startspan --><script language="JavaScript"><!--
MSFPhover =
(((navigator.appName == "Netscape") &&
(p****Int(navigator.appVersion) >= 3 )) ||
((navigator.appName == "Microsoft Internet Explorer") &&
(p****Int(navigator.appVersion) >= 4 )));
function MSFPpreload(img)
{
var a=new Image(); a.src=img; return a;
}
// --></script><script language="JavaScript"><!--
if(MSFPhover) { MSFPnav1n=MSFPpreload("../_derived/up_cmp_copy-of- citrus-punch3010_hbtn.gif"); MSFPnav1h=MSFPpreload("../_derived/up_cmp_copy-of- citrus-punch3010_hbtn_a.gif"); }
// --></script>
<script language="JavaScript"><!--
if(MSFPhover) { MSFPnav2n=MSFPpreload("_derived/ user_exists.asp_cmp_copy-of-citrus-punch3010_hbtn.gif" ); MSFPnav2h=MSFPpreload("_derived/ user_exists.asp_cmp_copy-of-citrus- punch3010_hbtn_a.gif"); }
// --></script>
<script language="JavaScript"><!--
if(MSFPhover) { MSFPnav3n=MSFPpreload("_derived/ Create_lite02_user.asp_cmp_copy-of-citrus- punch3010_hbtn.gif"); MSFPnav3h=MSFPpreload("_derived/ Create_lite02_user.asp_cmp_copy-of-citrus- punch3010_hbtn_a.gif"); }
// --></script>
<script language="JavaScript"><!--
if(MSFPhover) { MSFPnav4n=MSFPpreload("_derived/ delete_user.asp_cmp_copy-of-citrus-punch3010_hbtn.gif" ); MSFPnav4h=MSFPpreload("_derived/ delete_user.asp_cmp_copy-of-citrus- punch3010_hbtn_a.gif"); }
// --></script>
<!--webbot bot="Navigation" i-checksum="34099" endspan -->
If you need to create a Lite02 on OPS DATAMART User Do Not
use this page click ME to go to the right
page
<!--webbot BOT="GeneratedScript" PREVIEW=" " startspan --><script Language="JavaScript" Type="text/javascript"><!--
function FrontPage_Form1_Validator(theForm)
{
if (theForm.UserName.value == "")
{
alert("Please enter a value for the \"User Name\" field.");
theForm.UserName.focus();
return (false);
}
if (theForm.UserName.value.length < 7)
{
alert("Please enter at least 7 characters in the \"User Name\" field.");
theForm.UserName.focus();
return (false);
}
if (theForm.UserName.value.length > 7)
{
alert("Please enter at most 7 characters in the \"User Name\" field.");
theForm.UserName.focus();
return (false);
}
var checkOK = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyzƒ ŠŒŽšœžŸÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîï ðñòóôõöøùúûüýþÿ0123456789-";
var checkStr = theForm.UserName.value;
var allValid = true;
var validGroups = true;
for (i = 0; i < checkStr.length; i++)
{
ch = checkStr.charAt(i);
for (j = 0; j < checkOK.length; j++)
if (ch == checkOK.charAt(j))
break;
if (j == checkOK.length)
{
allValid = false;
break;
}
}
if (!allValid)
{
alert("Please enter only letter and digit characters in the \"User Name\" field.");
theForm.UserName.focus();
return (false);
}
if (theForm.GivenName.value == "")
{
alert("Please enter a value for the \"First Name\" field.");
theForm.GivenName.focus();
return (false);
}
if (theForm.GivenName.value.length < 1)
{
alert("Please enter at least 1 characters in the \"First Name\" field.");
theForm.GivenName.focus();
return (false);
}
if (theForm.FamilyName.value == "")
{
alert("Please enter a value for the \"Last Name\" field.");
theForm.FamilyName.focus();
return (false);
}
if (theForm.FamilyName.value.length < 1)
{
alert("Please enter at least 1 characters in the \"Last Name\" field.");
theForm.FamilyName.focus();
return (false);
}
return (true);
}
//--></script><!--webbot BOT="GeneratedScript" endspan -->
| <!--mstheme-->User Name<!--mstheme--> | <!--mstheme--> <!--webbot bot="Validation" s-display-name="User Name" s-data-type="String" b-allow-letters="TRUE" b-allow-digits="TRUE" b-value-required="TRUE" i-minimum-length="7" i-maximum-length="7" -->" size="20" maxlength="7"><!--mstheme--> |
| <!--mstheme-->First Name<!--mstheme--> | <!--mstheme--> <!--webbot bot="Validation" s-display-name="First Name" b-value-required="TRUE" i-minimum-length="1" -->" size="20"><!--mstheme--> |
| <!--mstheme-->Last Name<!--mstheme--> | <!--mstheme--> <!--webbot bot="Validation" s-display-name="Last Name" b-value-required="TRUE" i-minimum-length="1" -->" size="20"><!--mstheme--> |
<!--mstheme--> <!--webbot bot="SaveAsASP" clientside suggestedext="asp" preview=" " startspan --><!--webbot bot="SaveAsASP" endspan -->
<!--webbot bot="DatabaseRegionStart" s-columnnames=" Sys,UserName,Parent,Perm_GB,Spool_GB,Temp_GB,DefaultDB ,AccString,GivenName,FamilyName,ResultMsg,HypLink" s-columntypes=" 200,200,200,3,3,3,200,200,200,200,200,200" s-dataconnection="Database1" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice="ResultMsg" s-menuvalue="ResultMsg" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="2" b-makeform="TRUE" s-recordsource s-displaycolumns="ResultMsg,HypLink" s-criteria s-order s-sql="CALL PRODROOT.CREATEUSER5('PROD','::UserName::','REP' ,0,25,0,'::UserName::','$M1$PRODREP','::GivenName::',' ::FamilyName::',RESULTMSG,HypLink);<br>" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="UserName=&UserName=& GivenName=&FamilyName=" s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="0" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc" tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the start of a Database Results region.</font></td></tr></table>" startspan b-WasTableFormat="FALSE" b-ReplaceDatabaseRegion="FALSE" --><!--#include file="../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<script Language="JavaScript">
document.write("
");
</script>
<% end if %>
<%
fp_sQry="CALL PRODROOT.CREATEUSER5('PROD','::UserName::','REP' ,0,32,0,'::UserName::','$M1$PRODREP','::GivenName::',' ::FamilyName::',RESULTMSG,HypLink); "
fp_sDefault=" UserName=&UserName=&GivenName=&FamilyName="
fp_sNoRecords="No records returned."
fp_sDataConn="Database1"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="ResultMsg"
fp_sMenuValue="ResultMsg"
fp_iDisplayCols=2
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan --><!--mstheme-->
| <!--mstheme-->Result : <!--webbot bot="DatabaseResultColumn" s-columnnames=" Sys,UserName,Parent,Perm_GB,Spool_GB,Temp_GB,DefaultDB ,AccString,GivenName,FamilyName,ResultMsg,HypLink" s-column="ResultMsg" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>ResultMsg<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"ResultMsg")%><!--webbot bot="DatabaseResultColumn" endspan --><!--mstheme--><!--msthemelist--> | |
| <!--mstheme-->Click Here : "> <!--webbot bot="DatabaseResultColumn" s-columnnames=" Sys,UserName,Parent,Perm_GB,Spool_GB,Temp_GB,DefaultDB ,AccString,GivenName,FamilyName,ResultMsg,HypLink" s-column="HypLink" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>HypLink<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"HypLink")%><!--webbot bot="DatabaseResultColumn" endspan --><!--mstheme--><!--msthemelist--> |
<!--mstheme--> Click the
<!--msthemeseparator-->
![]()
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan -->
hyperlink Next to Click here. This will take you to the permissions page
directly with the Username already filled out for your convenience. If you receive an error please contact Simon Chandler Ext.4102.
<!--mstheme-->

Hi All,
I am facing a problem while call an stored procedure from odbc driver.
I m working with asp.net and my database is teradata. The page gets hanged while i call stored procedure.
If anyone have some code to call SP with in and out parameter please send it. May be it will held me