Re: Output parameters

From: Roji. P. Thomas (lazydragon_at_nowhere.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 11:23:26 +0530

Use the OLDEDB Provide instead.
that will solve this issue. 

-- 
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"Willie Bodger" <willie@bodgerfam.com> wrote in message
news:eg058C1bEHA.636@TK2MSFTNGP12.phx.gbl...
> OK, I'm not sure if I'm missing something or the SQ Server is missing
> something, but when I try this
> Dim dbConn, connectionstring, Cmd, CmdParams, Description, EndDate
> Set dbConn = Server.CreateObject("ADODB.Connection")
> Set Cmd = Server.CreateObject("ADODB.Command")
> Set CmdParams = Cmd.Parameters
> CmdParams.Append Cmd.CreateParameter("@iTMSNSEntityID", adInteger,
> adParamInput, 10, Request.QueryString("iEntityID")) CmdParams.Append
> Cmd.CreateParameter("Description",adVarChar,adParamOutput,50)
> CmdParams.Append Cmd.CreateParameter("EndDate",adDate,adParamOutput)
> connectionstring="DRIVER={SQL
> Server};SERVER=MyServer;UID=uid;PWD=pwd;DATABASE=db"
> dbConn.Open connectionString
> Set Cmd.ActiveConnection = dbConn
> Cmd.CommandType = adCmdStoredProc
> Cmd.Prepared = True
> Cmd.CommandText = "wsp_CancelSubscription"
>  cmd.Execute ,,adCmdStoredProc + adExecuteNoRecords
>
> Set Cmd = Nothing
> Set CmdParams = Nothing
>
> I get this:
>
>  Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
> [Microsoft][ODBC SQL Server Driver]Optional feature not implemented
>
> /mysupport/CancelSubscription.asp, line 22
>
> Where line 22 is the execution of the sproc and I'm stumped and to my eyes
> the error doesn't help me much. Any thoughts on where the problem lies?
Thx
> for the help!
>
> wb
>
> "Roji. P. Thomas" <lazydragon@nowhere.com> wrote in message
> news:%237EnGuubEHA.2544@TK2MSFTNGP10.phx.gbl...
>
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro01/html/sql01b1.asp
> >
> > -- 
> > Roji. P. Thomas
> > Net Asset Management
> > https://www.netassetmanagement.com
> >
> >
> > "Willie Bodger" <willie@bodgerfam.com> wrote in message
> > news:%23YXB3JrbEHA.3476@tk2msftngp13.phx.gbl...
> > > OK, if I have a sproc which has to return 2 values (a description and
a
> > > date) to an ASP page, what is the best way to do that? I was starting
> with
> > > Output parameters, but then realized I wasn't sure how to call them
from
> > the
> > > ASP page that called the sproc. Any examples would be greatly
> appreciated.
> > >
> > > wb
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Insert Query taking ages....
    ... P. Thomas ... > table command in query analyser and it also just sits there for ages.... ... >>> Roji. ... >>> Net Asset Management ...
    (microsoft.public.sqlserver.programming)
  • Re: DISTINCT and LEFT JOIN problem
    ... P. Thomas ... >>> Roji. ... >>> Net Asset Management ... >>>>> community of SQL Server professionals. ...
    (microsoft.public.sqlserver.programming)
  • Re: searching with varying parameters
    ... "Roji. ... P. Thomas" wrote in message ... > Net Asset Management ... >> body, Search by attachment name, search if message has attachments). ...
    (microsoft.public.sqlserver.programming)
  • Re: How to concat the values in a column across rows.
    ... P. Thomas ... "Colin Halliday" wrote in message ... >> Roji. ... >> Net Asset Management ...
    (microsoft.public.sqlserver.programming)
  • Re: Dynamic table name in query
    ... "Roji. ... P. Thomas" wrote in message ... >> Dynamic SQL, you could just explain your position or at least write the ... >>> You are trying to write a procedure without any cohesion at all. ...
    (microsoft.public.sqlserver.programming)