|
|
|
Forum Newbie
Group: Forum Members
Last Login: 3/7/2006 8:27:00 AM
Posts: 1,
Visits: 1
|
|
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
Hi
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/17/2006 4:25:00 AM
Posts: 3,
Visits: 1
|
|
Don't rubbish my code but it works fine. It was written in FrontPage.
Create User
<script language="JavaScript"></script><script language="JavaScript"></script> <script language="JavaScript"></script>  <script language="JavaScript"></script> <script language="JavaScript"></script>
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>
<% 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
%>
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.
Simon Chandler EDW Database Administrator
|
|
|
|