RE: Calling sp through ODBC

Simon Chandler — Tue, 23 May 2006 12:18:06 GMT

Don't rubbish my code but it works fine. It was written in FrontPage.

Create User

If you need to create a Lite02 on OPS DATAMART User Do Not
use this page click ME to go to the right
page

User Name	" size="20" maxlength="7">
First Name	" size="20">
Last Name	" size="20">

<% if 0 then %>
<script Language="JavaScript">
document.write("

The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.

");
</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
%>

	Result : <%=FP_FieldVal(fp_rs,"ResultMsg")%>
	Click Here : "> <%=FP_FieldVal(fp_rs,"HypLink")%>

Click the
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.

Calling sp through ODBC

sharma.anurag — Tue, 07 Mar 2006 08:29:22 GMT

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

Teradata Forums / Teradata / Partner software applications/questions / Calling sp through ODBC / Latest Posts

RE: Calling sp through ODBC

Calling sp through ODBC