Calling sp through ODBC

Third Party Software

Calling sp through ODBC

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

1 REPLY
Teradata Employee

Re: Calling sp through ODBC

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

<meta http-equiv="Content-Type" content="text/html; ch****t=windows-1252" />
<meta name="GENERATOR" content="Microsoft FrontPage 5.0" />
<meta name="ProgId" content="FrontPage.Editor.Document" />
Create User<meta name="Microsoft Theme" content="copy-of-citrus-punch3 011, default" />



Create User


<script language="JavaScript"></script><script language="JavaScript"></script>Up <script language="JavaScript"></script>Check User Exists Create User <script language="JavaScript"></script>Create Ops Lite02 <script language="JavaScript"></script>Delete 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

<script Language="JavaScript" Type="text/javascript"></script>

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
%>

bulletResult           : <%=FP_FieldVal(fp_rs,"ResultMsg")%>
bulletClick 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.